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 the Navigation pane.
2. Click Add.

   View the field descriptions for the Targets page

3. Select a database from the 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 the 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 the 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 the Description field; for example, DBA or business contact information, or when the target can be deleted from server.
10. Select an ID from the 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.

    NOTE: Consider creating and registering an additional repository for separate Target Sources to minimize the chance of overloading the communication between Collect and Data Services.

11. Click Save.

Continue with Test Connection - Targets.