Universe connects to the Oracle database of ECC

Even if BW is not available, Bo can directly connect to the ECC database to generate reports. For webi, you can use universe-> data base, xcelsius, and more methods, including liveoffice, qaas, and Web Service. today we will talk about how universe connects to the Oracle database of ECC.

1. Prerequisites

• Oracle client and BOE client. Pay attention to version issues. The Oracle Client Version cannot be lower than the server version.
• The username and password of the Oracle database.

 

2. Process

After installing the client, configure tnsnames. ora. For more information, see net configuration assistant to test whether it can connect to the Oracle server. after confirmation, you can create a new native in universe to connect to the database. database Connection Mode: Enter the user name and password. The service name is the service name of the database, that is, the service name entered through the net configuration assistant test. after the connection is created, you can use this connection to insert an ECC table. select the sapsr3 database. Pay attention to this It will be slow because there are too many tables! Wait.

By directly connecting to the database, the pressure on the ECC database will increase. It is best to perform a stress test to check the pressure on the ECC server.

 

3. Possible Problems

The main problem is that you cannot connect to the Oracle database. Generally, it is caused by TNS configuration. Do not install multiple clients. Otherwise, the system cannot identify the Oracle Home variable.