Collect
Register Targets
Target connections must be SQL Server and located on the same server as the DSP.
To register a target:
- Click Targets in Navigation pane.
-
Click Add.
-
Select a database from TARGET list box.
NOTE: The Target must be a valid Data Source.
- Click Save.
- Click Vertical View to further configure the Target.
-
Click Edit.
View the field descriptions for the Targets page's Vertical View
-
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
-
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
- 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.
-
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.
- Click Save.
Continue with Test Connection - Targets.