•  Database Ingestion and Replication
  •  Use cases
  •  Database Ingestion and Replication source and target types
  •  Database Ingestion and Replication architecture
  •  Database Ingestion and Replication system requirements
  •  Database Ingestion and Replication general limitations and guidelines
  •  Database Ingestion and Replication sources - preparation and usage
    •  Db2 for i sources
    •  Db2 for LUW sources
    •  Db2 for z/OS sources
    •  Microsoft SQL Server, RDS for SQL Server, Azure SQL Database, and Azure Managed Instance sources
    •  MongoDB sources
    •  MySQL sources
    •  Netezza sources
    •  Oracle sources
    •  PostgreSQL sources
    •  SAP HANA and SAP HANA Cloud sources
    •  Teradata sources
  •  Database Ingestion and Replication targets - preparation and usage
    •  Amazon Redshift targets
    •  Amazon S3, Flat File, Google Cloud Storage, Microsoft Azure Data Lake Storage, Microsoft Fabric OneLake, and Oracle Cloud Object Storage targets
    •  Databricks targets
    •  Google BigQuery targets
    •  Kafka targets and Kafka-enabled Azure Event Hubs targets
    •  Microsoft Azure Synapse Analytics targets
    •  Microsoft SQL Server and Azure SQL Database targets
    •  Oracle targets
    •  PostgreSQL targets
    •  Snowflake targets
    •  Default directory structure for CDC files on Amazon S3, Google Cloud Storage, Microsoft Azure Data Lake Storage Gen2, and Microsoft Fabric OneLake targets
    •  Custom directory structure for output files on Amazon S3, Google Cloud Storage, Flat File, Microsoft Fabric OneLake, and ADLS Gen2 targets
    •  Supported Avro data types
  •  Key concepts
    •  Schema drift handling
    •  Applying an audit history of all source table DML changes to target tables
    •  Applying deletes as soft deletes on the target
    •  CDC staging groups and tasks
    •  Integrating Database Ingestion and Replication Tasks with Data Integration Taskflows
    •  About LOB truncation
    •  Customizing data type mappings
  •  Configuring a database ingestion and replication task
    •  Before you begin
    •  Starting the ingestion and replication task wizard
    •  Primary cloud data warehouse setup
    •  Choose a runtime environment
    •  Configure the destination connection
    •  Configure the source connection
    •  Task Details: Configure how to replicate data from the source
    •  Task Details: Configure how to replicate data to the target
    •  Transform the data
    •  Finalize the task definition
  •  Deploying a database ingestion and replication task
  •  Running database ingestion and replication jobs
    •  Running a deployed database ingestion and replication job
    •  Running initial load jobs based on a schedule
  •  Managing database ingestion and replication jobs
    •  Stopping a database ingestion and replication job
    •  Aborting a database ingestion and replication job
    •  Resuming a database ingestion and replication job
    •  Overriding schema drift options when resuming a database ingestion and replication job
    •  Redeploying a database ingestion and replication job
    •  Undeploying a database ingestion and replication job
    •  Resynchronizing source and target objects
    •  Restart and recovery for incremental change data processing
    •  Running data validation for a database ingestion and replication jobs
  •  Default data-type mappings
    •  Db2 for i Source and Amazon Redshift Target
    •  Db2 for i Source and Databricks Target
    •  Db2 for i Source and Google BigQuery Target
    •  Db2 for i Source and Microsoft Azure Synapse Analytics Target
    •  Db2 for i Source and Microsoft SQL Server Target
    •  Db2 for i Source and Oracle Target
    •  Db2 for i Source and PostgreSQL Target
    •  Db2 for i Source and Snowflake Target
    •  Db2 for LUW Source and Amazon Redshift Target
    •  Db2 for LUW Source and Databricks Target
    •  Db2 for LUW Source and Google BigQuery Target
    •  Db2 for LUW Source and Microsoft Azure Synapse Analytics Target
    •  Db2 for LUW Source and Microsoft SQL Server Target
    •  Db2 for LUW Source and Oracle Target
    •  Db2 for LUW Source and Snowflake Target
    •  Db2 for z/OS Source and Amazon Redshift Target
    •  Db2 for z/OS Source and Databricks Target
    •  Db2 for z/OS Source and Google BigQuery Target
    •  Db2 for z/OS Source and Microsoft Azure Synapse Analytics Target
    •  Db2 for z/OS Source and Microsoft SQL Server Target
    •  Db2 for z/OS Source and Oracle Target
    •  Db2 for z/OS Source and Snowflake Target
    •  Microsoft SQL Server or Azure SQL Database Source and Amazon Redshift Target
    •  Microsoft SQL Server Source and Databricks Target
    •  Microsoft SQL Server Source and Google BigQuery Target
    •  Microsoft SQL Server Source and a Target That Uses the Parquet Output Format
    •  Microsoft SQL Server or Azure SQL Database Source and Microsoft Azure Synapse Analytics Target
    •  Microsoft SQL Server Source and Microsoft SQL Server Target
    •  Microsoft SQL Server Source and Oracle Target
    •  Microsoft SQL Server Source and PostgreSQL Target
    •  Microsoft SQL Server or Azure SQL Database Source and Snowflake Target
    •  MongoDB Source and Amazon Redshift Target
    •  MongoDB Source and Databricks Target
    •  MongoDB Source and Google BigQuery Target
    •  MongoDB Source and Microsoft Azure Synapse Analytics Target
    •  MongoDB Source and Microsoft SQL Server Target
    •  MongoDB Source and Oracle Target
    •  MongoDB Source and Snowflake Target
    •  MySQL Source and Amazon Redshift Target
    •  MySQL Source and Databricks Target
    •  MySQL Source and Google BigQuery Target
    •  MySQL Source and Microsoft Azure Synapse Analytics Target
    •  MySQL Source and Microsoft SQL Server Target
    •  MySQL Source and Oracle Target
    •  MySQL Source and Snowflake Target
    •  Netezza Source and Amazon Redshift Target
    •  Netezza Source and Databricks Target
    •  Netezza Source and Google BigQuery Target
    •  Netezza Source and Microsoft Azure Synapse Analytics Target
    •  Netezza Source and Microsoft SQL Server Target
    •  Netezza Source and Oracle Target
    •  Netezza Source and Snowflake Target
    •  Oracle Source and Amazon Redshift Target
    •  Oracle Source and Databricks Target
    •  Oracle Source and Google BigQuery Target
    •  Oracle Source and Microsoft Azure Synapse Analytics Target
    •  Oracle Source and Microsoft SQL Server Target
    •  Oracle Source and Oracle Target
    •  Oracle Source and PostgreSQL Target
    •  Oracle Source and Snowflake Target
    •  PostgreSQL Source and Amazon Redshift Target
    •  PostgreSQL Source and Databricks Target
    •  PostgreSQL Source and Google BigQuery Target
    •  PostgreSQL Source and Microsoft Azure Synapse Analytics Target
    •  PostgreSQL Source and Microsoft SQL Server Target
    •  PostgreSQL Source and Oracle Target
    •  PostgreSQL Source and PostgreSQL Target
    •  PostgreSQL Source and Snowflake Target
    •  SAP HANA Source and Amazon Redshift Target
    •  SAP HANA Source and Databricks Target
    •  SAP HANA Source and Google BigQuery Target
    •  SAP HANA Source and Microsoft Azure Synapse Analytics Target
    •  SAP HANA Source and Microsoft SQL Server Target
    •  SAP HANA Source and Oracle Target
    •  SAP HANA Source and Snowflake Target
    •  Teradata Source and Amazon Redshift Target
    •  Teradata Source and Databricks Target
    •  Teradata Source and Google BigQuery Target
    •  Teradata Source and Microsoft Azure Synapse Analytics Target
    •  Teradata Source and Oracle Target
    •  Teradata Source and Snowflake Target

Database Ingestion and Replication

Default data-type mappings

DBMI_TASKS_PAGE_LIST

CDIR_DESTINATION_STEP_DBMI_TASK

CDIR_SOURCE_STEP_DBMI_TASK

TASKDETAILS_SRC_DBMI_TASK_DB2I

TASKDETAILS_SRC_DBMI_TASK_DB2LUW

TASKDETAILS_SRC_DBMI_TASK_DB2Z

TASKDETAILS_SRC_DBMI_TASK_MSSQL

TASKDETAILS_SRC_DBMI_TASK_MONGODB

TASKDETAILS_SRC_DBMI_TASK_MYSQL

TASKDETAILS_SRC_DBMI_TASK_NETEZZA

TASKDETAILS_SRC_DBMI_TASK_ORACLE

TASKDETAILS_SRC_DBMI_TASK_POSTGRESQL

TASKDETAILS_SRC_DBMI_TASK_HANA

TASKDETAILS_SRC_DBMI_TASK_TERADATA

TASKDETAILS_TGT_DBMI_TASK_AMAZON_REDSHIFT

TASKDETAILS_TGT_DBMI_TASK_S3

TASKDETAILS_TGT_DBMI_TASK_DATABRICKS_DELTA_LAKE

TASKDETAILS_TGT_DBMI_TASK_CSVFILE

TASKDETAILS_TGT_DBMI_TASK_GOOGLE_BIG_QUERY

TASKDETAILS_TGT_DBMI_TASK_GCS

TASKDETAILS_TGT_DBMI_TASK_KAFKA

TASKDETAILS_TGT_DBMI_TASK_ADLS_GEN2

TASKDETAILS_TGT_DBMI_TASK_AZURE_SQL_DATA_WH

TASKDETAILS_TGT_DBMI_TASK_ONE_LAKE

TASKDETAILS_TGT_DBMI_TASK_MSSQL

TASKDETAILS_TGT_DBMI_TASK_ORACLE

TASKDETAILS_TGT_DBMI_TASK_ORACLE_CLOUD_STORAGE

TASKDETAILS_TGT_DBMI_TASK_POSTGRESQL

TASKDETAILS_TGT_DBMI_TASK_SNOWFLAKE

TRANSFORM_DBMI_TASK

FINAL_DBMI_TASK