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
JavaOracle DatabaseSAP

Avatar of undefined
Last Comment
CEHJ

8/22/2022 - Mon
CEHJ

Why would you use JDBC and not SAP?
ASKER
finaris

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
mrcoffee365

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
finaris

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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
mrcoffee365

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
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
CEHJ

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.
ASKER
finaris

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,
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
CEHJ

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