Documentation
SQL Server to Redshift SCD Types 1-2 data feed
This option utilizes a Staging Data Store. It is a SQL Server DB where data is cached before it is pushed into IBM Db2 Warehouse on Cloud (formerly dashDB for Analytics). It is not a complete read-replica of the source database. Only tables selected for Db2 Warehouse replication are pulled into the Staging Data Store. Data changes are continuously being synchronized to the Staging Data Store. From there it is asynchronously exported and uploaded to the warehouse. This mechanism allows for minimizing the workload on the primary database. As well as allows for monitoring for SQL Server schema changes, which are automatically synchronized to the Db2 warehouse schema (certain restrictions apply, for details see https://cloudbasic.net/documentation/limitations/)
If you choose the option [SQL Server] to [Db2 Warehouse on Cloud] SCD Types 1-2 data feed, you will arrive at the following screen:
Advanced configuration options are located in the [Advanced] tab:
Populate the required fields for the Master / Source Database and the Staging Data Source, and proceed to the "Db2 Details" screen.
Copy the Db2 endpoint from the Db2\Database Details\Host Name field. Default SSL connection port is 5001. Default non-SSL port is 5000.
Populate the Db2 connection details, SCD Type (Type 1 or Type 2 historical data feed) and select tables to be included in the Db2 data feed:
Test connections and start the replication.