•  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
    •  Change capture mechanism for Db2 for i sources
    •  Database Ingestion and Replication journal receiver exit
    •  Deleting a journal lock when undeploying or stopping a job
    •  Installing the Database Ingestion and Replication journal receiver exit
  •  Db2 for LUW sources
  •  Db2 for z/OS sources
    •  Installing and configuring the stored procedure for Db2 for z/OS CDC
    •  Db2 for z/OS privileges
    •  Enabling Db2 DATA CAPTURE CHANGES
    •  Change capture mechanism for Db2 for z/OS sources
  •  Microsoft SQL Server, RDS for SQL Server, Azure SQL Database, and Azure Managed Instance sources
    •  SQL Server permissions
    •  Change capture mechanisms for SQL Server sources
  •  MongoDB sources
  •  MySQL sources
  •  Netezza sources
  •  Oracle sources
    •  Gathering Information About the Database Ingestion and Replication environment
    •  Oracle privileges
    •  Oracle privileges for Amazon RDS for Oracle sources
    •  Oracle log access methods for CDC
    •  Configuring BFILE access to Oracle redo logs in the Oracle file system
    •  Using BFILE Access to a TDE Wallet
    •  Oracle Data Guard databases or far sync instances as sources
    •  Oracle archive log retention considerations
    •  Providing JDBC connection details in the tnsnames.ora file
  •  PostgreSQL sources
  •  SAP HANA and SAP HANA Cloud sources
    •  SAP HANA change capture methods
    •  Log-based change data capture for SAP HANA sources
    •  SAP HANA source preparation
    •  Usage considerations
  •  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, and Oracle Cloud Object Storage targets
  •  Databricks targets
  •  Google BigQuery targets
  •  Kafka targets and Kafka-enabled Azure Event Hubs targets
    •  Generating custom message keys for Kafka targets
  •  Microsoft Azure Synapse Analytics targets
  •  Microsoft Fabric Data Warehouse targets
  •  Microsoft Fabric OneLake targets
    •  Using open mirroring to replicate data to Microsoft Fabric OneLake
  •  Microsoft SQL Server and Azure SQL Database targets
  •  Oracle targets
  •  PostgreSQL targets
  •  Salesforce Data 360 targets
  •  Snowflake targets
    •  Using Snowflake-managed Iceberg tables to store data in external cloud storage
    •  Configure private connectivity to Snowflake
  •  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
    •  INFA_DATA table for Db2 for z/OS sources in a staging group
  •  Integrating Database Ingestion and Replication tasks with Data Integration taskflows
  •  About LOB truncation
  •  Customizing data type mappings
  •  Auto-tuning
•  Configuring a database ingestion and replication task
  •  Before you begin
  •  Starting the ingestion and replication task wizard
  •  Primary cloud data warehouse setup
    •  Configuring a primary cloud data warehouse
    •  Changing or unselecting a primary cloud data warehouse
  •  Choose a runtime environment
  •  Configure the destination connection
  •  Configure the source connection
  •  Task Details: Configure how to replicate data from the source
    •  Configure a Db2 for i source
    •  Configure a Db2 for LUW source
    •  Configure a Db2 for z/OS source
    •  Configure a Microsoft SQL Server source
    •  Configure a MongoDB source
    •  Configure a MySQL source
    •  Configure a Netezza source
    •  Configure an Oracle source
    •  Configure a PostgreSQL source
    •  Configure a SAP HANA source
    •  Configure a Teradata source
  •  Task Details: Configure how to replicate data to the target
    •  Configure an Amazon Redshift target
    •  Configure an Amazon S3 target
    •  Configure a Databricks target
    •  Configure a Flat File target
    •  Configure a Google BigQuery target
    •  Configure a Google Cloud Storage target
    •  Configure a Kafka target
    •  Configure a Microsoft Azure Data Lake Storage target
    •  Configure a Microsoft Azure Synapse Analytics target
    •  Configure a Microsoft Fabric Data Warehouse target
    •  Configure a Microsoft Fabric OneLake target
    •  Configure a Microsoft SQL Server target
    •  Configure an Open Table target
    •  Configure an Oracle target
    •  Configure an Oracle Cloud Object Storage target
    •  Configure a PostgreSQL target
    •  Configure a Salesforce Data 360 target
    •  Configure a Snowflake Data Cloud target
  •  Transform the data
    •  Syntax for row-level filtering
    •  Data access policies overview
  •  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 Fabric Data Warehouse Target
  •  Oracle Source and Microsoft SQL Server Target
  •  Oracle Source and Open Table Target
  •  Oracle Source and Oracle Target
  •  Oracle Source and PostgreSQL Target
  •  Oracle Source and Salesforce Data 360 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

Teradata Source and Snowflake Target

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_FABRIC

TASKDETAILS_TGT_DBMI_TASK_ONE_LAKE

TASKDETAILS_TGT_DBMI_TASK_MSSQL

TASKDETAILS_TGT_DBMI_TASK_OPEN_TABLE

TASKDETAILS_TGT_DBMI_TASK_ORACLE

TASKDETAILS_TGT_DBMI_TASK_ORACLE_CLOUD_STORAGE

TASKDETAILS_TGT_DBMI_TASK_POSTGRESQL

TASKDETAILS_TGT_DBMI_TASK_SALESFORCE_DATA_CLOUD

TASKDETAILS_TGT_DBMI_TASK_SNOWFLAKE

TRANSFORM_DBMI_TASK

CDI_TRANSF_DATA_ACCESS_POLICIES_OVERVIEW

FINAL_DBMI_TASK