cancel
Showing results for 
Search instead for 
Did you mean: 

Connection to SAP oracle database from external utlities

Former Member
0 Kudos

We want execute reports with external tools to link together data from several sources.

Besides lotus notes, penta, loga and other sources we have to use some tables from the SAP database.

(for example the table CSKS)

A simple way to access the data in the oracle database of the SAP system could be:

- Create an new user in the database with low permissions.

- Grant select access for this user to the relevant SAP tables.

- Create some views under this user for the access from external tools.

But this leads us to the following questions:

- Is this way acceptable from a technical point of view?

- Are there any problems with SAP licenses?

- Are there any problems with the support of the SAP systems?

- What are the alternatives?

It would be nice, if somebody can answer this questions.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hallo Herbert

<i>- Is this way acceptable from a technical point of view?</i>

Would be possible, you will loose the grants everytime the object is recreated (ICNV etc), means slightly higher admin overhead needed

<i>- Are there any problems with SAP licenses?</i>

Yes, please check sap notes:

592393 - FAQ: Oracle <b>-> Number 24</b>

581312 - Oracle database: licensing restrictions

<i>- Are there any problems with the support of the SAP systems?</i>

You will not have any support on your solution.

Regards

Michael