Supported databases
Browse Omni Loader sources and targets across operational databases, cloud warehouses, data lakes, and file formats, then open an engine for its migration details.
A broad connection surface
Start with the source and target you actually have.
Review supported engines, warehouses, lakes, and file formats before you design the migration plan around a single assumed platform.
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 does Omni Loader migrate? +
Omni Loader moves full datasets between operational databases, cloud warehouses, data lakes, and supported file formats. It combines schema preparation with parallel, resumable bulk data movement.
Which databases can Omni Loader move? +
The supported database catalog covers operational databases, cloud warehouses, lakes, and file formats. Each database page identifies whether the engine can be used as a bulk migration source, target, or both.
How does Omni Loader handle very large tables? +
Large tables can be divided into bounded slices by partition, numeric or date range, text prefix, or file range. Multiple workers then process independent tables and slices in parallel.
Do I have to install anything on my database server? +
Omni Loader runs on Windows or Linux compute with network access to the source and target. Database drivers are included where licensing allows, and external drivers can be installed when a vendor license requires it.
How does Omni Loader choose a loading method? +
The project can use provider bulk APIs, multi-row statements, direct writers, or staged native ingestion according to the destination. Defaults provide a practical starting point and table-level overrides handle exceptions.
Can Omni Loader consolidate multiple sources? +
Yes. A saved project can define multiple aliased source catalogs and load selected objects into one target while preserving explicit mapping and selection rules.
How can I verify a completed migration? +
Validation can compare row counts, table hashes, or individual records according to the source and target capabilities. Snapshot reconciliation can also persist added, changed, and deleted differences for review and controlled repair.
Can a failed migration be resumed? +
Run history records completed and failed work. Reported failed work units can be replayed without restarting every table in a large migration project.