Link to home
Start Free TrialLog in
Avatar of finaris
finarisFlag for Germany

asked on

Selecting SAP data via JDBC (underlying Oracle DB)

Hi,

we would like to select data via JDBC from a SAP system, where the data is stored in an Oracle database. If possible we would like to select from a view or from objects in the business warehouse.
What is needed for this and what is the best practice approach?

Best regards
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

Why would you use JDBC and not SAP?
Avatar of finaris

ASKER

the SAP consultancy firm which is used to adjust reports is expensive and it always takes long. We have been asked to support using a JDBC based tool.
SOLUTION
Avatar of mrcoffee365
mrcoffee365
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of finaris

ASKER

This sounds too simple., although technically it will work as the Solution has nothing to do with SAP. I Wonder however if there is a practical best practical recommendation which is the correct Data Layer as SAP might apply Business Logic on table data.
I want to make sure to retrieve correct Data.  Experience with SAP is needed to fully answer this question and to get full points.
Best
You're unlikely to get help here with Java access to SAP.

Award points for the answers you got, and try an SAP forum with your SAP-specific questions.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It seems to me that what has not been made sufficiently clear here (and in some cases, completely obscured/ignored) is that you could get yourself in a lot of trouble by accessing the data layer directly and bypassing business rules in other layers, especially (but by no means only) if you start writing to tables.
Avatar of finaris

ASKER

Dear HEHJ,
I appreciate your risk point and I do perfectly agree with you.
However in many cases SAP data can be selected without applying ABAP business rules.
Normally I would never access views and tables directly, and of course interting data is certainly a no go.

Best regards,
However in many cases SAP data can be selected without applying ABAP business rules.
Yes, i'm sure that's theoretically the case, in which case, for those areas, you have complete SAP oversight (you are the SAP expert) and either

a. your business rules in those areas will be immutable
or
b. you will maintain your SAP expertise level and patch the direct access code as necessary when the business rules do mutate