•  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
  •  Schema drift handling
  •  Apply an audit history of all source table DML changes to target tables
  •  Ability to apply deletes as soft deletes on the target
  •  Configuring a database ingestion and replication task
    •  Before you begin
    •  Integrating Database Ingestion and Replication Tasks with Data Integration Taskflows
    •  Defining basic task information
    •  Configuring the source
    •  Configuring the target
    •  Configuring schedule and runtime options
  •  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

DBMI_DEFINITION_PAGE

DBMI_SOURCE_PAGE

DBMI_TARGET_PAGE1

DBMI_RUNTIME_PAGE