on 11-20-2007 9:44 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.