Databases

Sources

  • Analytics Platform System
  • Azure SQL
  • Azure Synapse Analytics
  • CSV - Local disk and Azure storage locations supported
  • DB2 iSeries - Windows only, requires Microsoft OLE DB Provider for DB2
  • DB2 LUW
  • DB2 z/OS - Windows only, requires Microsoft OLE DB Provider for DB2
  • Ingres
  • MariaDB
  • MySQL
  • ODBC - Any ODBC source is supported, but the driver needs to be a 64-bit one
  • Oracle
  • Parquet - Local disk and Azure storage locations supported
  • PostgreSQL
  • SQL Server
  • SAP IQ - Windows only
  • SAP ASE - Windows only
  • Teradata
  • Vertica - Windows version uses native driver, while Linux version uses ODBC driver

Fast target

  • Analytics Platform System
  • Azure SQL
  • Azure Synapse Analytics - Highly optimized ingestion according to best practices
  • CSV - Local disk and Azure storage locations supported
  • DB2 LUW
  • MariaDB
  • MySQL
  • Oracle
  • Parquet - Local disk and Azure storage locations supported
  • PostgreSQL
  • SQL Server
  • Vertica - Windows version uses native driver, while Linux version uses ODBC driver

Slow targets

  • DB2 iSeries - Windows only, requires Microsoft OLE DB Provider for DB2
  • DB2 z/OS - Windows only, requires Microsoft OLE DB Provider for DB2
  • Ingres
  • ODBC - Any ODBC source is supported, but the driver needs to be a 64-bit one
  • SAP IQ - Windows only
  • SAP ASE - Windows only
  • Teradata