Collect

Test Connection - Targets

Before performing this task, Register Targets.

Test the Data Source connection to verify the database User ID and Password login credentials are connected to the source or target databases.

NOTE: The Test Connection feature does not test the validity of SAP login credentials or the DSN connection options.

To test the target database connection:

  1. Click Targets in Navigation pane.
  2. Select the Target.  
  3. Click Test Connection on Page toolbar to test connectivity to the target database; a confirmation message displays.
  4. Click Ok.

  5. Click Vertical View icon to review the connection metrics:

  • Test ConnectionStatus – Displays status of the last test connection.

  • Test ConnectionOn – Displays last date time of test connection.

If a customized ODBC connection is used, the connection string variable is tested to ensure it can access the database. The SAP user ID, password and RFC DLL process that utilize the DSN must be verified outside this process. If a target or a source system password changes, update the password in the connection table and rebuild all the packages from the source.

Continue with Assign Target Security.