Supported databases
One catalog powers both Omni Loader capabilities. Browse Burst Load sources and targets, identify continuous CDC sources and relational destinations, then open an engine for its type details.
Amazon RDS
A cloud-based database service that allows for easy set-up, scaling, and management of relational databases.
Amazon Redshift
A fast and powerful data warehousing service, enabling efficient analysis and storage of large amounts of data.
Analytics Platform System
A powerful and flexible solution for data warehousing and business intelligence, providing high-performance analytics and big data capabilities.
Apache Parquet
A columnar storage format designed for big data processing and analytics, making it efficient and useful for storing and querying large datasets.
Azure SQL
A cloud-based relational database service, offering scalability and high availability, making it useful for businesses needing efficient data management.
CockroachDB
A distributed SQL database that allows for horizontal scaling, high availability, and strong consistency.
CSV
A file format for storing structured data. Commonly used for data import/export and data analysis in databases.
Databricks
A unified analytics platform built on Apache Spark, designed to streamline data processing and analytics, facilitating collaboration and advanced data-driven insights.
Exadata
A high-performance, scalable, and secure database management system designed for mission-critical enterprise systems.
Fabric Lakehouse
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
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
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
A fully managed, serverless data warehouse that enables scalable analysis over petabytes of data using SQL and built-in machine learning capabilities.
Google Spanner
A fully managed, scalable, relational database service for regional and global application data.
Greenplum
A powerful, open-source data warehousing and analytics platform used for big data management and analysis.
IBM DB2 for i
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
A powerful and versatile database management system that is useful for a wide variety of data storage and management tasks.
IBM DB2 z/OS
A high-performance, scalable, and secure database management system designed for mission-critical enterprise systems.
JSON
A lightweight data interchange format useful for storing and exchanging structured data in web applications.
MariaDB
A widely used open-source relational database management system that offers high performance, scalability and data integrity.
MySQL
A popular open-source relational database management system, commonly used for web-based applications and data management.
Netezza
A high-performance, scalable data warehouse appliance that enables rapid querying and analysis of large datasets using SQL.
NuoDB
A distributed SQL database designed to provide elastic scalability, high availability, and ACID compliance for cloud-based and containerized environments.
ODBC
A data access standard that enables connectivity between different databases, making it useful for cross-platform data integration.
Oracle
The world's most popular database in enterprise market. Designed for true distributed computing. Handles the most complex and demanding needs.
Oracle RDB
The world's most popular database in enterprise market. Designed for true distributed computing. Handles the most complex and demanding needs.
PostgreSQL
A powerful open-source relational database management system. Known for its robust performance and scalability.
SAP Adaptive Server Enterprise
A high-performance relational database management system. Provides robust data management, scalability, and security for enterprise-level applications.
SAP IQ
A high-performance, columnar database that allows for efficient data warehousing and analytics.
Snowflake
A cloud-based data warehouse platform that allows users to easily store, query and analyze large amounts of data in real-time.
SQL Server
A relational database management system developed by Microsoft. Widely used for data warehousing, business intelligence, and analytics.
Synapse Dedicated Pool
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
Provides an on-demand querying service for analyzing data directly in the data lake, using T-SQL without the need to manage infrastructure.
Teradata
A high-performance, scale-out relational database used for data warehousing and business intelligence applications.
Vertica
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.
The practical details
Frequently asked questions
What are Burst Load and Change Data Capture? +
Burst Load moves a full dataset once with parallel, resumable bulk movement. Change Data Capture keeps a target current by applying committed inserts, updates, and deletes. Omni Loader can run either capability independently or coordinate a parallel seed with a pinned CDC handoff.
Which databases can Burst Load move? +
The shared Omni Loader catalog currently presents 49 source and target engines, including operational databases, cloud warehouses, lakes, and file formats. The exact source and target capabilities are shown on the supported databases page.
Which databases can Omni Loader capture from? +
Omni Loader captures from Oracle, SQL Server and Azure SQL, PostgreSQL, MySQL, and Sybase ASE. DirectRedo, SQL Server Streaming, and DirectDevice are the high-performance direct-log choices when files or devices are reachable. Native streams and SQL-based readers cover environments with different access constraints.
Do I have to install anything on my database server? +
Nothing is installed inside the database. The agent runs on nearby or separate compute. PostgreSQL pgoutput, MySQL binlog, SQL Server native CDC, Oracle LogMiner, and Sybase reconstruction use database or replication connections. SQL Server Streaming and Sybase DirectDevice can leave only a tiny read-only broker beside the source while decode and apply run elsewhere. Managed-cloud availability still depends on what each provider exposes.
Will capture slow down my production database? +
Every read has a cost, but the cost changes by mode. Direct file and device readers move parsing, transaction assembly, spooling, and apply off the database engine, though log reads still consume storage or network I/O. PostgreSQL and MySQL use native push streams. SQL mining and polling ask the source to do more work, with Oracle LogMiner as the clearest example. Choose the mode against the source’s actual performance budget.
Can Omni Loader process multiple sources and sinks in parallel? +
Yes. Burst Load slices tables across parallel workers and can distribute work across agent machines. CDC can run multiple source pipelines and fan one captured stream out to multiple sinks. Every sink advances on an independent durable cursor, so one paused destination does not pause the others.
Where does Omni Loader run, and is my data safe? +
The agent runs in infrastructure you control on Windows or Linux. It initiates control traffic outbound, resolves connection secrets locally, and sends captured rows directly to your destinations. The control plane does not connect to your databases or receive the row stream. TLS is required by default for control traffic unless an operator deliberately enables an insecure development posture.
What can I replicate to? +
Eleven shipped sink connectors: PostgreSQL, MySQL, SQL Server, Azure SQL, Oracle, Sybase ASE, CockroachDB, Google Cloud Spanner, Apache Kafka, Google Pub/Sub, and Microsoft Fabric Open Mirroring.
How do I choose the right capture mode? +
Start with what the hosting model can expose. If logs are reachable, evaluate DirectRedo, SQL Server Streaming, or DirectDevice first for high-performance off-box parsing. If they are not, compare the native stream or SQL-based reader by source work, required privileges, before-image behavior, schema scope, and measured throughput boundary.