Database Ingestion and Replication > Database Ingestion and Replication source and target types
  

Database Ingestion and Replication source and target types

The source and target types that Database Ingestion and Replication supports depend on the load type that the database ingestion and replication tasks use: an initial load point-in-time operation, an incremental load of only the data changes, or an initial load followed by an incremental load.
For supported source and target versions, see the KB article What are the supported sources and targets for IICS Cloud Mass Ingestion service?.

Source types

The following table shows the source types that are supported (S) for each load type:
Source Type
Initial Load
Incremental Load
Initial and Incremental Loads
Db2 for i
S
S
S
Db2 for Linux, UNIX, and Windows (LUW)
S
S1
S1
Db2 for z/OS
S
S
S
Microsoft SQL Server, including on-premises SQL Server, RDS for SQL Server, Microsoft Azure SQL Database, and Azure SQL Managed Instance
S
S2
S2
MongoDB3
S
S
S
MySQL, including on-premises MySQL, Amazon Aurora MySQL, Azure Database for MySQL4, Cloud SQL for MySQL, and RDS for MySQL
S
S
S
Netezza
S
-
-
Oracle, including on-premises Oracle and RDS for Oracle
S
S
S
PostgreSQL, including on-premises PostgreSQL, Amazon Aurora PostgreSQL, Azure Database for PostgreSQL - Flexible Server, Cloud SQL for PostgreSQL, and RDS for PostgreSQL
S
S
S
SAP HANA, SAP HANA Cloud
S
S
S
Teradata
S
-
-
1. For Db2 for LUW sources, incremental load and combined load jobs are supported with either the Query-based or Log-based capture method.
2. For Azure SQL Database sources, incremental load and combined load jobs are supported with the Query-based and CDC Tables capture methods. Log-based capture with a transaction log is not supported.
3. MongoDB sharded clusters and replica sets are supported as sources.
4. Azure Database for MySQL is supported with Snowflake targets for all load types and with Confluent Kafka targets for incremental loads.
To determine the connectors to use for these source types, see Connectors and Connections > Database Ingestion and Replication connectors.

Target types

The following table shows the target types that are supported (S) for each load type:
Target Type
Initial Load
Incremental Load
Initial and Incremental Loads
Amazon Redshift, Amazon Redshift Serverless
S
S
S
Amazon S3
S
S
S
Apache Kafka, Confluent Kafka, Amazon Managed Streaming for Apache Kafka (MSK)
-
S
-
Azure Event Hubs enabled for use with Kafka clients
-
S
-
Microsoft SQL Server, including on-premises SQL Server, RDS for SQL Server, Microsoft Azure SQL Database, and Azure SQL Managed Instance
S
S
S
Databricks
S
S
S
Flat file
S
-
-
Google BigQuery
S
S
S
Google Cloud Storage
S
S
S
Microsoft Azure Data Lake Storage Gen2
S
S
S
Microsoft Azure Synapse Analytics
S
S
S
Microsoft Fabric Data Warehouse
S
S
S
Microsoft Fabric OneLake
S
S
S
Open Table
S
S
S
Oracle, including RDS for Oracle
S
S
S
Oracle Cloud Infrastructure (OCI) Object Storage
S
S
S
PostgreSQL, including Amazon Aurora PostgreSQL and RDS for PostgreSQL
S
S
S
Salesforce Data 360
S
S
S
Snowflake
S
S
S
To determine the connectors to use for these target types, see Connectors and Connections > Database Ingestion and Replication connectors.