Omni Loader Docs
  • OVERVIEW
    • About
    • Getting Started
    • Databases
    • Performance considerations
    • Prerequisites
  • Project Wizard
    • General
    • Database List
    • Favorites
    • Review
  • Project types
    • Full Table Copy
    • Data Compare & Sync
    • Change Data Capture
    • Overview
  • Project Options
    • General
    • Performance
    • Databases
    • Mapping
    • Logging
    • Troubleshooting
  • Table Options
    • Columns
    • WHERE clause
    • Partitioning
    • Cut-off
    • Options Override
  • Global Settings
    • Overview
  • Automations
    • Overview
    • JSON job specification
  • Microsoft training - Omni Loader
    • Synapse Dedicated Pool to Fabric Warehouse
  • Connections
    • Amazon RedShift
    • Analytics Platform System
    • Synapse Dedicated Pool
    • CockroachDB
    • CSV
    • Databricks
    • DB2 iSeries
    • DB2 LUW
    • DB2 zOS
    • Greenplum
    • Google AlloyDB
    • Google BigQuery
    • MariaDB
    • MySQL
    • Netezza
    • NuoDB
    • ODBC
    • Oracle
    • Parquet
    • PostgreSQL
    • Snowflake
    • Sybase ASE
    • Sybase IQ
    • SQL Server
    • Teradata
    • Vertica ODBC
    • Fabric Lakehouse
    • Fabric Warehouse
    • Azure SQL Database
    • V-ORDER Fabric Lakehouse Optimization
Powered by GitBook
On this page
  • Sources
  • Fast targets
  • Slow targets
  1. OVERVIEW

Databases

PreviousGetting StartedNextPerformance considerations

Last updated 11 months ago

Sources

Fast targets

Slow targets

Cover

Amazon Redshift

Cover

Analytics Platform System

Cover

Azure SQL

Cover

Azure Synapse Analytics

Cover

CockroachDB

Cover

CSV

Local disk and Azure storage locations supported

Cover

Databricks

Cover

DB2 iSeries

Windows only, requires Microsoft OLE DB Provider for DB2

Cover

DB2 LUW

Cover

DB2 z/OS

Windows only, requires Microsoft OLE DB Provider for DB2

Cover

Google AlloyDB

Cover

Google BigQuery

Cover

Google Spanner

Cover

Fabric Lakehouse

Cover

Fabric Warehouse

Cover

Greenplum

Cover

Ingres

Cover

MariaDB

Cover

MySQL

Cover

Netezza

Cover

NuoDB

Cover

ODBC

Any ODBC source is supported, but the driver needs to be 64-bit

Cover

Oracle

Cover

Parquet

Local disk and Azure storage locations supported

Cover

PostgreSQL

Cover

SQL Server

Cover

SAP IQ

Cover

SAP ASE

Cover

Snowflake

Cover

Teradata

Cover

Vertica

Cover

Analytics Platform System

Cover

Azure Synapse Analytics

Cover

Azure SQL

Cover

CSV

Cover

DB2 LUW

Cover

Google AlloyDB

Cover

Google BigQuery

Cover

Google Spanner

Cover

Fabric Lakehouse

Cover

Fabric Warehouse

Cover

MariaDB

Cover

MySQL

Cover

Oracle

Cover

Parquet

Local disk and Azure storage locations supported

Cover

PostgreSQL

Cover

SQL Server

Cover

Vertica

Cover

DB2 iSeries

Windows only, requires Microsoft OLE DB Provider for DB2

Cover

DB2 z/OS

Windows only, requires Microsoft OLE DB Provider for DB2

Cover

Ingres

Cover

ODBC

Any ODBC source is supported, but the driver needs to be 64-bit

Cover

SAP IQ

Windows only

Cover

SAP ASE

Windows only

Cover

Teradata