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 some 20 databases at this point. The rest we support in our other products will be supported very soon. See our databases page.
There is no comparison, really. We natively support all popular (and less popular) databases. We took the time to talk to each database directly instead of the easy way of using slow and buggy generic ODBC drivers. Just looking at the performance, features and stability, our software is in a class of it's own. And don't get us started about ease of use and our fantastic user interface...
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.
We have built proof of concept technology, but it is not yet available in the public Omni Loader images.
Of course. Please go to the demo request page .