Required information - Connect_CDC - connect_cdc_mimix_share - 6.x

Source database server that contains the data to be distributed (copied or replicated)

• DBMS type

• DBMS version

• TCP/IP port number

• Server name (or database, or subsystem, or library name)

Note: MS SQL Server requires the ODBC data source name.

• Login ID and password of Connect CDC metabase owner

• Login ID and password authorized to update the test table

Source host computer on which source server resides

• Machine name or IP address

• Connect CDC Listener TCP/IP port

• Location of Connect CDC installation (jar) files

Target database server that receives the distributed data

• DBMS type

• DBMS version

• TCP/IP port number

• Server name (or database, or subsystem, or library name)

Note: MS SQL Server requires the ODBC data source name.

• Login ID and password of Connect CDC metabase owner

• Login ID and password authorized to query the test table

Target host computer on which target server resides

• Machine name or IP address

• Connect CDC Listener TCP/IP port number

• Location of Connect CDC installation (jar) files

Data to be distributed

• Name of SQL table containing the data to be distributed

Note: Name of receiving table is assumed to match this.

• Columns to be distributed and their receiving columns

Note: At least some of the corresponding source and target column names are assumed to match.

Method for updating source data

• SQL update statement(s) or script that updates the source columns