A Additional Information for SAP ABAP BW Adapter

This appendix describes the privileges that are required for connecting to SAP System, how you can test the connection outside of ODI using a standalone java utility, and how to uninstall SAP components.

This appendix contains the following sections:

SAP ABAP BW Required Privileges
SAP Stand-Alone Connection Test
Uninstalling ODI SAP Components

For more information about the SAP BW KMs see Oracle Fusion Middleware Connectivity and Knowledge Modules Guide for Oracle Data Integrator.

A.1 SAP ABAP BW Required Privileges

A SAP dialog user is required for connecting to the SAP system, for the RKM installation, and for the LKM execution during development. A SAP RFC user is NOT sufficient. During development, this user must have a developer license key. License keys can be retrieved from http://service.sap.com. Any execution attempts without this developer license key will lead to failure and may cause the need for clean-up operations.For RKM and LKM execution in production, a SAP RFC user is sufficient. The following sections list the privileges required for using SAP BW Knowledge Modules:

Authorizations Required for RKM SAP BW Setup
Authorizations Required for RKM Execution
Authorizations Required for LKM Execution
Authorizations Required for LKM Execution for Production

A.1.1 Authorizations Required for RKM SAP BW Setup

The authorizations required for setting up the configuration for the RKM SAP BW and installing the required RFC programs to retrieve the metadata about SAP tables are the same as the authorizations required for the RKM SAP ERP.

See Section B.1.1, "Authorizations Required for RKM SAP ERP Setup" for more information.

A.1.2 Authorizations Required for RKM Execution

The authorizations required for running a reverse-engineering using the RKM SAP BW are the same as the authorizations required for the RKM SAP ERP.

See Section B.1.2, "Authorizations Required for RKM Execution" for more information.

A.1.3 Authorizations Required for LKM Execution

The authorizations required for using the LKM SAP BW to Oracle (SQLLDR) are the same as the authorizations required for the LKM SAP ERP to Oracle (SQLLDR).

See Section B.1.3, "Authorizations Required for LKM Execution" for more information.

A.1.4 Authorizations Required for LKM Execution for Production

The authorizations required for using the LKM SAP BW to Oracle (SQLLDR) in a production environment are the same as the authorizations required for the LKM SAP ERP to Oracle (SQLLDR). In such environment, the ABAP code generated by the LKM is not installed by the LKM but simply executed.

See Section B.1.4, "Authorizations Required for LKM Execution for Production" for more information.

A.2 SAP Stand-Alone Connection Test

In addition to the Connection Testing described in the Getting Started with SAP ABAP Adapter guide, a test can be performed outside of ODI using a standalone java utility. This test is the same for SAP ERP and SAP BW.

See Section A.2, "SAP Stand-Alone Connection Test" for more information.

A.3 Uninstalling ODI SAP Components

In case of upgrading to a newer ODI SAP Connector release or for permanently removing ODI connectivity, please follow the steps described in this section.

Please note that this will delete ALL components including generated extractor programs.

To upgrade to a newer ODI SAP Connector release or to permanently remove the ODI connectivity:

Start the SAP GUI.
Connect to the SAP systems you want to uninstall.
Go to the transaction SE80.
Select the package or development class option from the drop down box.
Enter ZODIBW_PCKG in the package or development class field.
Right-click the ZODIBW_PCKG object below the object name tab.
Select Delete in the drop down menu and delete the development class.

If it does not allow deleting the development class individually, delete all the objects one by one and then delete the development class.

Note that the system will not allow deleting the development class since TADIR entries are there.
Go to transaction SE38.
Create a Z Program.
Enter the following code:

DELETE FROM TADIR WHERE DEVCLASS = ' ZODIBW_PCKG '.
Save, activate, and execute the program.
Now Go to transaction SE80 and delete the development class ZODIBW_PCKG.