Collect

Configure Source for SAP Data Services

Before performing this task, Register Sources to Target.

If SAP Data Services are being used, specific connection information used by SAP Data Services must be configured at the Target Source level. This connection is then tested to ensure that Data Services can connect to the Source and Target instances.

To configure a source for SAP Data Services:

1. Click Targets in the Navigation pane.
2. Click the Sources icon for the Target.
3. Click Vertical View for the Source.
4. Click the Advanced Settings tab.
5. Click Edit.

   View the field descriptions for the Target Sources page's Vertical View

6. Select the name of the target source repository in the Data Services ID field.

   NOTE: If this field is blank, the repository set at the target level is used. Consider creating and registering an additional repository for separate target sources to minimize the chance of overloading the communication between Collect and Data Services.

7. If using change data capture jobs with DBMoto or Data Services, click the Do Not Delete Data check box to disable it.

   NOTE: This check box displays once the Data Services ID field is populated.

8. Select a database connection type from the Data Services Connection Type list box to connect to the source database if using SAP Data Services.

   NOTE: Refer to SAP documentation for details about the types of Data Services connections.

   NOTE: If the Data Services Connection Type is SAP Application for a Target Source, the Test Connection icon is disabled on the Target Sources page Horizontal View for that Target Source. Connections to SAP can only be made through Data Services or RFC.

9. Click Save.
10. Click Connection Settings.
11. Click Edit.

    View the field descriptions for the Target Sources – DataServices Connection page

    NOTE: The fields available on the Target-Sources – Data Services Connection page vary based on the Data Services Connection Type.

    Use the following table to populate the applicable fields.

    Field	Description
    Server	Enter server and instance name of the database to which Data Services will connect when building or executing a package.
    User	Enter user ID used to access the database.
    Password	Enter password for user ID to access the database.
    Initial Catalog	Enter the database name used by Data Services to connect to a SQL Server.
    Host String	Enter TNS name or string used to connect to the database using the following format: <Oracle_system>/<Oracle_SID>, where Oracle_system is the IP or network name of the system where Oracle is running, and Oracle_SID is the Oracle System identifier that identifies the database on the Oracle system.
    Database	Enter the database name where the source or target tables are stored.
    odbcDSN	Enter ODBC Data Source name used to connect to the database.

    NOTE: Once Data Services settings have been configured for the Target and Source, SAP Data Services packages can be registered for tables, and packages can be built and refreshed.

12. Click Save.

Continue with Test Connection - Sources.