Collect

Target Sources – DataServices Connection

Use this page to view sources for SAP Data Services while configuring sources for SAP Data Services.

To access this page:

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

Field available depends on the Data Services Connection Type selected on the Vertical View  of the Target Sources page:

ASE15

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

Server

Displays server and instance name of the database to which Data Services will connect when building or executing a package.

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Database

Displays the database name where the source or target tables are stored.

Test Connection

Click to test the connectivity to the database.

DB2 UDBv9

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

ODBC_DSN

Displays ODBC data source name used to connect to the database.

Test Connection

Click to test the connectivity to the database.

DB2 UDBv8

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

ODBC_DSN

Displays ODBC data source name used to connect to the database.

Test Connection

Click to test the connectivity to the database.

Informix v10

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

ODBC_DSN

Displays ODBC data source name used to connect to the database.

Test Connection

Click to test the connectivity to the database.

Informix v11

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

ODBC_DNS

Displays ODBC data source name used to connect to the database.

Test Connection

Click to test the connectivity to the database.

MySQL v5.0

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

odbcDSN

Displays ODBC data source name used to connect to the database.

MySQL v5.1

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

ODBC_DSN

Displays ODBC data source name used to connect to the database.

Test Connection

Click to test the connectivity to the database.

ODBC

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

ODBC_DSN

Displays ODBC data source name used to connect to the database.

Test Connection

Click to test the connectivity to the database.

Oracle12c

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Host String

Displays 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.

Test Connection

Click to test the connectivity to the database.

Oracle10g

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Host String

Displays 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.

Test Connection

Click to test the connectivity to the database.

Oracle11g

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Host String

Displays 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.

Test Connection

Click to test the connectivity to the database.

Oracle9i

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Host String

Displays 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.

Test Connection

Click to test the connectivity to the database.

SAP Application

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

Server

Displays server and instance name of the database to which Data Services will connect when building or executing a package.

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Initial Catalog

Displays the database name used by Data Services to connect to a SQL server.

Host String

Displays 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

Displays the database name where the source or target tables are stored.

ODBC_DSN

Displays ODBC data source name used to connect to the database.

Test Connection

Click to test the connectivity to the database.

SQL2005

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

Server

Displays server and instance name of the database to which Data Services will connect when building or executing a package.

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Initial Catalog

Displays the database name used by Data Services to connect to a SQL server.

Test Connection

Click to test the connectivity to the database.

SQL2008

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

Server

Displays server and instance name of the database to which Data Services will connect when building or executing a package.

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Initial Catalog

Displays the database name used by Data Services to connect to a SQL server.

Test Connection

Click to test the connectivity to the database.

SQL2012

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

Server

Displays server and instance name of the database to which Data Services will connect when building or executing a package.

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Initial Catalog

Displays the database name used by Data Services to connect to a SQL server.

Test Connection

Click to test the connectivity to the database.

SQL2014

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

Server

Displays server and instance name of the database to which Data Services will connect when building or executing a package.

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Initial Catalog

Displays the database name used by Data Services to connect to a SQL server.

Test Connection

Click to test the connectivity to the database.

SQL2016

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

Server

Displays server and instance name of the database to which Data Services will connect when building or executing a package.

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Initial Catalog

Displays the database name used by Data Services to connect to a SQL server.

Test Connection

Click to test the connectivity to the database.

SQL2017

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

Server

Displays server and instance name of the database to which Data Services will connect when building or executing a package.

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Initial Catalog

Displays the database name used by Data Services to connect to a SQL server.

Test Connection

Click to test the connectivity to the database.

SQL2019

Field

Description

Name

Displays the Data Services repository instance assigned to the target, which instructs Collect to use the Data Services instance for the creation and execution of packages. Click the link to open the Data Source Registry page in Common, which is where data services are configured.

Connection Settings

Server

Displays server and instance name of the database to which Data Services will connect when building or executing a package.

User

Displays user ID to connect to the database.

Password

Displays password for user ID to connect to the database.

Initial Catalog

Displays the database name used by Data Services to connect to a SQL server.

Test Connection

Click to test the connectivity to the database.