https://store-images.s-microsoft.com/image/apps.10596.8fa19269-e760-4e09-a840-cfcd8f3bf144.38c5f22d-a37d-4606-9883-bb681dc735c3.fbc5bb45-6f7e-4a28-85b0-4c254e84d7bf

OmniLoader VM for Azure

Spectral Core Limited

OmniLoader VM for Azure

Spectral Core Limited

Effortless database migration - massively parallel, scalable, and self-tuning

OmniLoader enables migrations of even the largest databases with minimal effort. Many customizations are available, but the basic process is extremely simple and straightforward. Compared to other Data Integration solutions, OmniLoader saves a lot of time.
More info at omniloader.com

Source databases:
- Analytics Platform System
- Azure SQL Database
- Azure Synapse Analytics
- CSV
- DB2 LUW
- DB2 iSeries
- DB2 zOS
- MariaDB
- MySQL
- ODBC
- Oracle
- Parquet
- PostgreSQL
- SQL Server
- Sybase ASE
- Sybase IQ
- Teradata
- Vertica

Target databases:
- Analytics Platform System
- Azure SQL Database
- Azure Synapse Analytics
- CSV
- DB2 LUW
- DB2 iSeries
- DB2 zOS
- MariaDB
- MySQL
- ODBC
- Oracle
- Parquet
- PostgreSQL
- SQL Server
- Teradata
- Vertica

Parallelism
Depending on the VM size, OmniLoader will run as many jobs in parallel as there are vCPUs available.
For on-premises installation (a BYOL license), customer can run many agents on separate computers for even greater scalability. OmniLoader orchestrates jobs and connections of workers running on Windows or Linux machines with the same ease of use.

Heterogeneous data migration
For heterogeneous migration (source and target databases are not of the same type), OmniLoader automatically selects the closest possible data types available in the target database and ensures data is loaded in the most efficient way. Optimal data load mode is selected for each table separately, taking into account table structure and target database version. A single project can handle many source databases.

Azure Synapse Analytics
Special care has been taken to optimally load huge datasets into Azure Synapse Analytics.
https://store-images.s-microsoft.com/image/apps.32898.8fa19269-e760-4e09-a840-cfcd8f3bf144.38c5f22d-a37d-4606-9883-bb681dc735c3.fcae3985-a597-4ffc-8b71-1ec418022adb
https://store-images.s-microsoft.com/image/apps.32898.8fa19269-e760-4e09-a840-cfcd8f3bf144.38c5f22d-a37d-4606-9883-bb681dc735c3.fcae3985-a597-4ffc-8b71-1ec418022adb
https://store-images.s-microsoft.com/image/apps.18073.8fa19269-e760-4e09-a840-cfcd8f3bf144.38c5f22d-a37d-4606-9883-bb681dc735c3.83c7e1c2-2d60-42b1-82df-a088e8e45d37
https://store-images.s-microsoft.com/image/apps.61525.8fa19269-e760-4e09-a840-cfcd8f3bf144.38c5f22d-a37d-4606-9883-bb681dc735c3.6463b452-7d82-4733-8ca3-3947ed8780d7
https://store-images.s-microsoft.com/image/apps.64324.8fa19269-e760-4e09-a840-cfcd8f3bf144.38c5f22d-a37d-4606-9883-bb681dc735c3.936ad3b5-abfa-455d-b021-ce9a59c5a8b0
https://store-images.s-microsoft.com/image/apps.54437.8fa19269-e760-4e09-a840-cfcd8f3bf144.38c5f22d-a37d-4606-9883-bb681dc735c3.01121080-feca-48fb-b118-ae72a339b64b