Setting Up Client Access to the SAP NetWeaver System Database

If you want to look at the strategy management tables in the system database, you need a tool for client access to the database server. For example, if you want to look at the tables in a MaxDB database, you need MaxDB Database Studio installed on your client with access to the SAP NetWeaver server.

If you are using Entry and Approval or Model Designer, one of the following is required:

If using IBM DB2 as the system database to store strategy management application data, the 32-bit client software for DB2 is installed on the Windows server where Application Server is installed. The software must be configured to access the DB2 installation on the SAP NetWeaver system.

You must copy the files that reside in the following directory and paste them up one level into the \procs directory, replacing the MaxDB version of the same files:

<install-dir>\SAP Strategy Management\InternetPub\procs\db2_procs
If using MaxDB as the system database to store strategy management application data, the 32–bit ODBC drivers for MaxDB are installed on the Windows server where Application Server is installed.

If using MaxDB on a 64–bit system, then you must install the MaxDB Application Runtime Package to obtain the required 32–bit ODBC drivers. The 32-bit ODBC drivers are not included in version 7.7 and higher of the 64-bit MaxDB installs. To obtain the required 32-bit ODBC drivers, download and install the MAXDB Application Runtime Package following the instructions in SAP Note 1575053 .

Note
If you are running MaxDB on a 64–bit system, you might receive an error message when you run the 32-bit ODBC Administrator to configure the ODBC connection. You can ignore the message because the ODBC DSN is created correctly anyway. The error is likely caused by a missing CTRL3D32.DLL file that is not installed by default on the system. Not all 64–bit systems have this error because there are many software packages that install that file.
If using SQL Server as the system database, the 32–bit ODBC drivers for SQL Server are installed on the Windows server where Application Server is installed.

You must copy the files that reside in the following directory and paste them up one level into the \procs directory, replacing the MaxDB version of the same files:

<install-dir>\SAP Strategy Management\InternetPub\procs\sqlsrvr_procs
If using Oracle as your system database, the 32–bit client software for Oracle is installed on the Windows server where Application server is installed. A Local Net Service is defined for the server on which the Oracle SAP NetWeaver System database is installed.

You must copy the files that reside in the following directory and paste them up one level into the \procs directory, replacing the MaxDB version of the same files:

<install-dir>\SAP Strategy Management\InternetPub\procs\oracle_procs
If using Sybase ASE as the system database, the 32–bit ODBC drivers for Sybase ASE are installed on the Windows server where Application Server is installed.

You must copy the files that reside in the following directory and paste them up one level into the \procs directory, replacing the MaxDB version of the same files:

<install-dir>\SAP Strategy Management\InternetPub\procs\sybase_procs
If using HANA as the system database, the 32–bit ODBC drivers for HANA are installed on the Windows server where Application Server is installed.

You must copy the files that reside in the following directory and paste them up one level into the \procs directory, replacing the MaxDB version of the same files:

<install-dir>SAP Strategy Management\InternetPub\procs\hana_procs

For information about configuring and using Model Designer, see the Model Designer User's Guide on the SAP Help Portal at http://help.sap.com/bosm101 Information published on SAP site .

For information about configuring the system to use Entry and Approval, see Setting Up Entry and Approval.

For information about configuring the system to integrate SAP Planning and Consolidation data into the strategy management application, see Configuring the Application to Access Planning and Consolidation Data in the Configuration Help for SAP Strategy Management on the SAP Help Portal at http://help.sap.com/bosm101 Information published on SAP site .