Omni Loader documentation

Databases

Sources

  1. - Analytics Platform System
  2. - Azure SQL
  3. - Azure Synapse Analytics
  4. - CSV - Local disk and Azure storage locations supported
  5. - DB2 iSeries - Windows only, requires Microsoft OLE DB Provider for DB2
  6. - DB2 LUW
  7. - DB2 z/OS - Windows only, requires Microsoft OLE DB Provider for DB2
  8. - Ingres
  9. - MariaDB
  10. - MySQL
  11. - ODBC - Any ODBC source is supported, but the driver needs to be a 64-bit one
  12. - Oracle
  13. - Parquet - Local disk and Azure storage locations supported
  14. - PostgreSQL
  15. - SQL Server
  16. - SAP IQ - Windows only
  17. - SAP ASE - Windows only
  18. - Teradata
  19. - Vertica - Windows version uses native driver, while Linux version uses ODBC driver

Fast targets

  1. - Analytics Platform System
  2. - Azure SQL
  3. - Azure Synapse Analytics - Highly optimized ingestion according to best practices
  4. - CSV - Local disk and Azure storage locations supported
  5. - DB2 LUW
  6. - MariaDB
  7. - MySQL
  8. - Oracle
  9. - Parquet - Local disk and Azure storage locations supported
  10. - PostgreSQL
  11. - SQL Server
  12. - Vertica - Windows version uses native driver, while Linux version uses ODBC driver

Slow targets

  1. - DB2 iSeries - Windows only, requires Microsoft OLE DB Provider for DB2
  2. - DB2 z/OS - Windows only, requires Microsoft OLE DB Provider for DB2
  3. - Ingres
  4. - ODBC - Any ODBC source is supported, but the driver needs to be a 64-bit one
  5. - SAP IQ - Windows only
  6. - SAP ASE - Windows only
  7. - Teradata