Automatically create target tables and add to a distribution - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - Latest

You can use Connect CDC Director to automatically create target tables and add to a a distribution. The target tables that are automatically created have the same table names and column names as its source table. The datatype for each column will also be similar to that of the source table. To enable this feature, select the checkbox Create Tables at the target on the Distribute Tables dialog.

To create tables on a target server:

1. Right-click the source table from the Available Tables list on the source server, choose Select For Distribution>This Table Only... or All Checked Tables...

   The Distribute Tables dialog displays.

   Note: For specific information on all the sections and fields in this dialog refer to Select source tables for distribution.
   

2. Select a Distribution.

3. Select one or more target servers to distribute the table(s) to.

4. Select the checkbox Create Tables at the target. Connect CDC Director checks if the matching table name exists in the target server cache for each source table selected. By default the Create Tables at the target is unchecked. By selecting this option you are requesting Connect CDC Director to automatically create, map and distribute the selected tables.

5. Click OK. Connect CDC Director determines if there is a target table that matches the source table in the target servers cache. If there is not a match, Connect CDC Director continues to check all tables being distributed and then displays a list of tables it did not find.

   The following message dialog displays:

   
6. Click Yes, to create the target tables and launch the Target Table wizard.

   The Target Tables panel displays. Use this panel to specify information for the target tables you wish to create.

   

7. Select Default Schema/Catalog and/or Owner. The Default panel displays.

8. Specify the Schema/Catalog/Owner information for all tables for any given server. You can also individually change this information on the Target Tables panel, if needed. These are required fields.

   

9. Select Apply. The Target Tables panel re-displays with values for Schema, Catalog and Owner for all tables based on a specific server.

   

   • Create—Check this box to indicate you wish to create a target table. By default, this box is checked.

   • Table—Specifies the source table name. The target table will have the same name.

   • Server—Specifies the target server name you selected from the Select one or more target servers section on the Distribute Tables dialog.

   • DBMS Type—Specifies the database type.

   • Schema/Catalog—Specifies the name of the target server schema that the tables will be created in. This is a required field.

   • Owner—Specifies the owner of the database. This is a required field.

   Note: For Schema, Catalog and Owner, the case and value must match the value on the target server.

   • Apply Index—Check this box to apply an index to the target table. By default, this box is checked. Apply Index is applicable to indexes other than the primary index.

10. Click Next.

    The Target Server Login Details panel displays. Use this panel to specify login details for the target servers you wish to create tables on.

    

    • Target servers—This section displays the servers from the list of target tables chosen from the first screen.

    • Logon ID—Select the Logon ID from the dropdown for each server. The dropdown list is populated with the DBMS logon IDs specified on the Server Properties dialog box. The Logon ID should not be system administrator or replication user. This ID will need to have authority to create tables and indexes on the target database. This is a required field.

    • Password—This field will be automatically populated with the password associated with the Logon ID.

    • If a credential manager supplies the password, select Credential Management and click the credential manager type from the dropdown list.

    Click Configure... to open the CyberArk Options dialog, which accepts changes in 2 fields to configure the CyberArk connection required to connect to CyberArk:

    • Application ID: an application ID registered in CyberArk

    • Query String: query string listing CyberArk fields like Safe, Object, Address, PolicyID, etc.

11. Choose Add or Test Connect.

    • Add will first do a test connection and then add or overwrite the login information for the target server and populate the related fields in the section at the bottom of the panel.

    • Test Connect will validate the login details.

    Once completed, the section at the bottom of the panel provides login details for each pending target server.

12. Click Next.

    The Create and Map Output panel displays. This panel displays the results of the automatic table creation and mapping process.

    

13. Click Finish to complete the process.