Supported databases

Beyond the list below, Omni Loader handles every database that speaks a PostgreSQL-compatible (or other standard) wire protocol. The real list is much larger than what fits on a page.

shape
Amazon RDS

Amazon RDS

Source Fast Target

A cloud-based database service that allows for easy set-up, scaling, and management of relational databases.

Amazon Redshift

Amazon Redshift

Source Slow Target

A fast and powerful data warehousing service, enabling efficient analysis and storage of large amounts of data.

Analytics Platform System

Analytics Platform System

Source Fast Target

A powerful and flexible solution for data warehousing and business intelligence, providing high-performance analytics and big data capabilities.

Apache Parquet

Apache Parquet

Source Fast Target

A columnar storage format designed for big data processing and analytics, making it efficient and useful for storing and querying large datasets.

Azure SQL

Azure SQL

Source Fast Target

A cloud-based relational database service, offering scalability and high availability, making it useful for businesses needing efficient data management.

CockroachDB

CockroachDB

Source-only

A distributed SQL database that allows for horizontal scaling, high availability, and strong consistency.

CSV

CSV

Source Fast Target

A file format for storing structured data. Commonly used for data import/export and data analysis in databases.

Databricks

Databricks

Source Fast Target

A unified analytics platform built on Apache Spark, designed to streamline data processing and analytics, facilitating collaboration and advanced data-driven insights.

Exadata

Exadata

Source Fast Target

A high-performance, scalable, and secure database management system designed for mission-critical enterprise systems.

Fabric Lakehouse

Fabric Lakehouse

Source Fast Target

Integrates OneLake as a foundational data lake, enabling users to create workspaces and lakehouses for seamless data collaboration and analysis across various Microsoft Fabric compute experiences.

Fabric Warehouse

Fabric Warehouse

Source Fast Target

Industry-leading performance, ease of use, and integration with Power BI, while converging data lakes and warehouses to simplify organizations' investments in their analytics estate.

Google AlloyDB

Google AlloyDB

Source Fast Target

A fully-managed, PostgreSQL-compatible database service designed for high performance and scalability. Geared toward enterprise applications requiring advanced security, performance, and analytical capabilities.

Google BigQuery

Google BigQuery

Source Fast Target

A fully managed, serverless data warehouse that enables scalable analysis over petabytes of data using SQL and built-in machine learning capabilities.

Google Spanner

Google Spanner

(coming soon)
Source Fast Target

A fully managed, scalable, relational database service for regional and global application data.

Greenplum

Greenplum

Source Target

A powerful, open-source data warehousing and analytics platform used for big data management and analysis.

IBM DB2 for i

IBM DB2 for i

Source Slow Target

A highly efficient and powerful IBM database system designed for IBM i platforms that helps to streamline and manage large amounts of data.

IBM DB2 LUW

IBM DB2 LUW

Source Fast Target

A powerful and versatile database management system that is useful for a wide variety of data storage and management tasks.

IBM DB2 z/OS

IBM DB2 z/OS

Source Slow Target

A high-performance, scalable, and secure database management system designed for mission-critical enterprise systems.

JSON

JSON

Source Fast Target

A lightweight data interchange format useful for storing and exchanging structured data in web applications.

MariaDB

MariaDB

Fast Target CDC (preview)

A widely used open-source relational database management system that offers high performance, scalability and data integrity.

MySQL

MySQL

Fast Target CDC (preview)

A popular open-source relational database management system, commonly used for web-based applications and data management.

Netezza

Netezza

Source-only

A high-performance, scalable data warehouse appliance that enables rapid querying and analysis of large datasets using SQL.

NuoDB

NuoDB

Source Slow Target

A distributed SQL database designed to provide elastic scalability, high availability, and ACID compliance for cloud-based and containerized environments.

ODBC

ODBC

Source Slow Target

A data access standard that enables connectivity between different databases, making it useful for cross-platform data integration.

Oracle

Oracle

Fast Target CDC (preview)

The world's most popular database in enterprise market. Designed for true distributed computing. Handles the most complex and demanding needs.

Oracle RDB

Oracle RDB

Fast Target CDC (preview)

The world's most popular database in enterprise market. Designed for true distributed computing. Handles the most complex and demanding needs.

PostgreSQL

PostgreSQL

Source Fast Target

A powerful open-source relational database management system. Known for its robust performance and scalability.

SAP Adaptive Server Enterprise

SAP Adaptive Server Enterprise

Source Slow Target

A high-performance relational database management system. Provides robust data management, scalability, and security for enterprise-level applications.

SAP IQ

SAP IQ

Source Slow Target

A high-performance, columnar database that allows for efficient data warehousing and analytics.

Snowflake

Snowflake

Source Fast Target

A cloud-based data warehouse platform that allows users to easily store, query and analyze large amounts of data in real-time.

SQL Server

SQL Server

Fast Target CDC (preview)

A relational database management system developed by Microsoft. Widely used for data warehousing, business intelligence, and analytics.

Synapse Dedicated Pool

Synapse Dedicated Pool

Source Fast Target

A cloud-based data integration and analytics platform that allows users to analyze and visualize data from various sources in real-time.

Synapse SQL Serverless

Synapse SQL Serverless

Fast Target

Provides an on-demand querying service for analyzing data directly in the data lake, using T-SQL without the need to manage infrastructure.

Teradata

Teradata

Source Slow Target

A high-performance, scale-out relational database used for data warehousing and business intelligence applications.

Vertica

Vertica

Source Fast Target

A high-performance, column-oriented database useful for handling big data analytics and business intelligence tasks.

Easy database connections

We include all native database drivers that we're licensed to distribute, so you can connect and start working immediately in most cases. For databases where licensing restrictions prevent bundling, we handle the license acceptance and driver installation automatically. It takes just seconds.

Our specialization in database migration ensures comprehensive support for modern database systems, delivering reliable and accurate migrations regardless of your source or target platform.

Vision illustration
FAQ

Frequently asked
questions