Omni Loader is built on and improves our battle-tested migration technology used by many thousand companies in over 90 countries. We are working on database migrations for almost 20 years now.
A modern approach to data migration, relying on the fact that today massively parallel databases are very good at transforming data. It's far more efficient to load the data quickly into the target database and transform it once it's in compared to engineering complex workflows of joining and aggregating disparate data sources, joining and aggregating as intermediate step and pushing the result to the target. Omni Loader does transform schema and data on the fly, but it does a minimal transformation necessarry to bring everything over in a way compatible with the target database. It maps source data types to the closest available data types in the target database. It re-encodes data, if necessarry, on the fly. And it never touches the disk while it does so.
To efficiently migrate a lot of data, parallelism is essential. To efficiently ingest very large tables, data needs to be partitioned. To efficiently migrate very large single table, data from that single table needs to be sliced into smaller parts so that individual slices can be copied in parallel. Omni Loader does all that, automatically, while allowing adjustment of the defaults.
On cloud, access to powerful virtual machines with plenty of CPU cores is readily available, on-premises installation often runs on a more modest hardware. To enable the massive parallelism enabling the performance needed to push many terabytes to the cloud or to a powerful database server, Omni Loader controls agents running on as many machines as necessary. Each agent further runs many jobs in parallel. Both orchestrator and agents are native Windows and Linux applications and you can mix and match with no limitations.
We support over 20 databases at this point and are very likely to support yours. Take a look at the whole list on our databases page.
Omni Loader easily migrates absolutely huge databases. Our competitors either require a lot of time-consuming setup time or the performance is not suitable for very large databases.
Please contact us and we will discuss your needs.
Absolutely. Please head over to our demo request page.
Omni Loader is available in Azure Marketplace. Just select your desired virtual machine size and get started in minutes.
For on-premises installation please contact us to obtain a license. Once you do, you will get native executables for Windows and Linux. Run as many agents as your license allows to scale to the perfromance levels you need.
Absolutely - that's the core functionality of Omni Loader.
Yes! CDC is support for SQL Server, MySQL, MariaDB, and Oracle sources.