Mass Ingestion

Back Next

Supported source and target types

The source and target types that

Mass Ingestion Databases

supports depend on the load type that the

database ingestion

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.

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	-	-
Db2 for z/OS	S	S	-
Microsoft Azure SQL Database	S	-	-
Microsoft SQL Server, including RDS for SQL Server	S	S	S
MongoDB	S	S	-
MySQL, including RDS for MySQL	S	-	-
Netezza	S	-	-
Oracle, including RDS for Oracle	S	S	S
PostgreSQL, including Amazon Aurora PostgreSQL and RDS for PostgreSQL	S	S	-
SAP HANA	S	S	-
Teradata	S	-	-

To determine the connectors to use for these source types, see Connectors and Connections
> Mass Ingestion Databases connectors
.

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	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	-
Databricks Delta	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
Oracle, including RDS for Oracle	S	S	S
Snowflake	S	S	S

To determine the connectors to use for these target types, see Connectors and Connections
> Mass Ingestion Databases connectors
.