Show TOC

Creating Database Management Systems as Source SystemsLocate this document in the navigation structure

Use

With DB Connect, you have the option of opening up extra database connections in addition to the SAP default connection and using these connections to access these databases during a BW extraction in order to transfer data into a BW system. To do this, you have to create a database source system in which the connection data is specified and made known to the ABAP runtime environment. The connection data is used to identify the source database and authenticate the database.

Prerequisites

  • You have made the following settings in the Implementation Guide (IMG) under SAP NetWeaver Start of the navigation path Business Intelligence  Next navigation step Links to Other Source Systems End of the navigation path:

    • General connection settings

    • Automatic workflow customizing

  • As a rule, system changes are not permitted in productive systems. Connecting a system as a source system to a BW or connecting a BW to a new source system will, however, require changes as far as the system change options are concerned. In the client used in the BW system, you have therefore made sure that the following changes are permitted during the source system connection:

    • Cross-client Customizing and repository changes

      In the Implementation Guide (IMG) under SAP NetWeaver Start of the navigation path Business Intelligence  Next navigation step Links to Source Systems Next navigation step  General Connection Settings Next navigation step  Assign Logical System to Client End of the navigation path, select the client in question and choose Start of the navigation path Goto  Next navigation step Details End of the navigation path. In the Cross-Client Object Changes field, choose the Changes to Repository and Cross-Client Customizing Allowed option.

    • Changes to the local developments and Business Information Warehouse software components

      You use transaction SE03 (Organizer Tools) to set the change options. Choose Start of the navigation path Set Organizer Tools Next navigation step  Administration Next navigation step System Change Option End of the navigation path. Choose Execute . On the next screen, make the following settings:.

    • Changes to the customer name range.

      Again, you use transaction SE03 to set the change option for the customer name range.

    • Changes to BW namespaces /BIC/ and /BI0/

      Again, you use transaction SE03 to set the change option for the BW namespaces.

  • If the source DBMS and BW DBMS are different:

  • In the database system, you have created a user name and password that you want to use for the connection.

    See Database Users and Database Schemas .

Procedure

Before you can open a database connection, all the connection data that is used to identify the source database and authenticate the database has to be made known to the ABAP runtime environment. For this, you need to specify the connection data for each of the database connections that you want to set up in addition to the SAP default connection.

  1. In the source system tree in the Data Warehousing Workbench, choose Create in the context menu of the DB Connect folder.

  2. On the following screen, specify the logical system name (= DB connection) and a descriptive text for the source system. Choose Continue .

    The Change Description of Database Connection View: Detail screen appears.

  3. Select the database management system ( DBMS ) that you want to use to manage the database. This entry determines the database platform for the connection.

  4. Under User Name, specify the database user under whose name you want the connection to be opened.

  5. When establishing the connection, enter the user DB Password twice for authentication by the database. This password is encrypted and stored.

  6. Under Connection Info , specify the technical information required to open the database connection. This information, which is needed when you establish a connection using NATIVE SQL, depends on the database platform and encompasses the database names and the database host on which the database runs. The string informs the client library of the database to which you want to establish the connection.

Connection information that depends on the database platform

Supported Database

CON_ENV Connection Information

SAP DB (ada) or MaxDB (dbs)

<server_name>-<db_name>

Microsoft SQL Server (mss)

MSSQL_SERVER=<server_name> MSSQL_DBNAME=<db_name>

Example

MSSQL_SERVER=10.17.34.80 MSSQL_DBNAME=Northwind

(See SAP Note 178949 - MSSQL: Database MultiConnect with EXEC SQL)

Oracle (ora)

TNS Alias

(See SAP Note 339092 - DB-MultiConnect with Oracle as a secondary database)

DB2/390 (db2)
Example

PORT=4730;SAPSYSTEMNAME=D6B;SSID=D6B0;SAPSYSTEM=71;SAPDBHOST=ihsapfc; ICLILIBRARY=/usr/sap/D6D/SYS/exe/run/ibmiclic.o

The parameters describe the target system for the connection (see installation handbook DB2/390).

The individual parameters (PORT=... SAPSYSTEMNAME=... .....) must be separated with ' ' , ',' or ';'.

(See SAP Note 160484 - DB2/390: Database MultiConnect with EXEC SQL)

DB2/400 (db4)

<parameter_1>=<value_1>;...;<parameter_n>=<value_n>;

You can specify the following parameters:

  • AS4_HOST: Host name for the Remote DB Server. You have to enter the host name in the same format as is used under TCP/IP or OptiConnect, according to the connection type you are using.

    You have to specify the AS4_HOST parameter.

  • AS4_DB_LIBRARY: Library that the DB server job needs to use as the current library on the remote DB server.

    You have to enter parameter AS4_DB_LIBRARY.

  • AS4_CON_TYPE: Connection type; permitted values are OPTICONNECT and SOCKETS. SOCKETS means that a connection is used using TCP/IP sockets.

    Parameter AS4_CON_TYPE is optional. If you do not enter a value for this parameter, the system uses connection type SOCKETS.

    Example

    For a connection to the remote DB server as0001 on the RMTLIB library using TCP/IP sockets, you have to enter:

    AS4_HOST=as0001;AS4_DB_LIBRARY=RMTLIB;AS4_CON_TYPE=SOCKETS;

    The syntax must be exactly as described above. You cannot have any additional blank spaces between the entries and each entry has to end with a semicolon. Only the optional parameter AS4_CON_TYPE=SOCKETS can be omitted.

    (See SAP Note 146624 - AS/400: Database MultiConnect with EXEC SQL)

    (For DB MultiConnect from Windows AS to iSeries, see Note 445872)

DB2 UDB (db6)

DB6_DB_NAME=<db_name>, where <db_name> is the name of the DB2 UDB database on which you want to run Connect.

Example

You want to establish a connection to the 'mydb'database. Enter DB6_DB_NAME=mydb as the connection information.

(See SAP Note 200164 - DB6: Database MultiConnect with EXEC SQL)

SAP HANA Database (hdb)

<Hostname>:<SQL Port>

(see SAP Note 1597627 - HANA Connection)

  1. Specify whether your database connection needs to be permanent or not.

    If you set this indicator, losing an open database connection (for example due to a breakdown in the database itself or in the database connection [network]) has a negative impact.

    Regardless of whether this indicator is set, the SAP work process tries to reinstate the lost connection. If this fails, the system responds as follows:

    a. The database connection is not permanent, which means that the indicator is not set:

    The system ignores the connection failure and starts the requested transaction. However, if this transaction accesses the connection that is no longer available, the transaction terminates.

    b. The database connection is permanent, which means that the indicator is set:

    After the connection terminates for the first time, each transaction is checked to see if the connection can be reinstated. If this is not possible, the transaction is not started independently of whether the current transaction would access this special connection or not. The SAP system can only be used again once all the permanent DB connections have been reestablished.

    Recommendation

    We recommend setting the indicator if an open DB connection is essential or if it is accessed often.

  2. Save your entry and go back.

  3. The Change Description of Database Connections View: Overview screen appears. The system displays the entry for your database connection in the table.

  4. Go back.

Result

You have created IDoc basic types, port descriptions, and partner agreements. When you use the destinations that have been created, the ALE settings that enable a BW system to communicate with a database source system are created in BW in the background. In addition, the BW settings for the new connection are created in the BW system, and the access paths from the BW system to the database are stored.

You have now successfully created a connection to a database source system. The system displays the corresponding entry in the source system tree. You can now create DataSources for this source system.