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
finarisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CEHJCommented:
Why would you use JDBC and not SAP?
0
finarisAuthor Commented:
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.
0
mrcoffee365Commented:
It's no problem.  You use normal jdbc calls.  The Oracle db has to be available to you and you have to have a login for the db you are accessing.  Then configure your jdbc access to the db and write Java code to query the tables.

Tutorial on using jdbc with Oracle:
http://docs.oracle.com/javase/tutorial/jdbc/
http://www.mkyong.com/jdbc/connect-to-oracle-db-via-jdbc-driver-java/
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

finarisAuthor Commented:
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
0
mrcoffee365Commented:
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.
0
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
finaris,

Your question has several parts:
1. connect via JDBC to SAP with a Oracle DB.
2. getting the access to SAP tables the right way, including the Business Logic.

The first part has been answered.
The second can't in a satisfying, easy way (on EE). Many of SAP tables and views are well-defined (see repository), and can be used that way. However, the relations of tables and the correlation to SAP GUI, BAPI / RFC or whatever actions are difficult to extract, and that is why the SAP Consultants are expensive. Usually they build custom objects, which are fully integrated via ABAP processes.
As there aren't many SAP consultants on EE (their job is to be busy all the time), I fear you won't get anything better than that. A SAP specific forum might be indeed the better idea to get something more substantial.
Should you do so, leave off the JDBC part, as the technique used is irrelevant for what you need to know. You need direct DB access to SAP with Oracle DB, and want to know what to do in SAP to allow that, and how to get some business logic info with table reference.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
BTW, we access SAP via ODBC or OLE DB (with MSSQL), but only Z tables, which are customized by default, will not change with releases, and have to be processed by custom ABAP code a SAP Consultancy firm has to create.
0
CEHJCommented:
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.
0
finarisAuthor Commented:
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,
0
CEHJCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.