Collect

Register Targets

Target connections must be SQL Server and located on the same server as the DSP.

To register a target:

  1. Click Targets in Navigation pane.

  2. Click Add.

    View the field descriptions for the Targets page

  3. Select a database from TARGET list box.

    NOTE: The Target must be a valid  Data Source.

  4. Click Save.
  5. Click Vertical View to further configure the Target.

  6. Click Edit.

    View the field descriptions for the Targets page's Vertical View

  7. Update Collation Type list box if the default value is not applicable.

    NOTE: The Collation Type controls the language option for text data in the database. Values are:

    • General Latin Case-insensitive –collation uses Latin characters and is case-insensitive
    • General Latin Case-sensitive –collation uses Latin characters and is case-sensitive

  8. Update Refresh Indices Option list box if the default value is not applicable.

    NOTE: The Refresh Indices Option controls the option to build indices or the key of registered tables. Select an option to increase the download and network performance. Values are:

    • Build Indices and Primary Keys
    • Build Indices only
    • Do Not Build Indices and Primary Keys
  9. Enter additional information about the target in Description field, e.g., DBA or business contact information, or when the target can be deleted from server.

  10. Select an ID from Data Services ID list box to assign the target to a Data Services implementation, if a Data Services instance is used for the creation and execution of packages.

    NOTE: If using Data Services, set the Data Services Connection Type at the Target-Source level. Refer to Configure Source for SAP Data Services section for detailed information.

  11. Click Save.

Continue with Test Connection - Targets.