How to select data of sap tables through oracle backend

[Former Member]

I need to fetch the data from oracle Backend for SAP tables. I am new to this and don't know how to work in this manner, so can you please tell me step-by-step procedure for the same.

Can you please help me, and can suggest for teh solution.

Rgds, Krishan Raheja.

[Former Member]

It seems SE16 (tcode) will be a better option as you can download the data as per your restriction to a flat/excel/csv file and upload/export it to Database.

All the best !

[Former Member]

Hi Krishan,

1. Login as orasid user on OS level

2. conn '/as sysdba'

3. on the SQL prompt type : desc SAPSCHEMA_OWMER.TABLE_NAME

for eg: desc sapr3.mseg or SAPSR3.MSEG

4. form a query as per your need by selecting the appropriate columns

Just a suggestion : you can also see the table content using SE16 tx..

Regards,

Anup

[lbreddemann]

Hi there!

Please, just ignore steps

> 1. Login as orasid user on OS level

to

> 4. form a query as per your need by selecting the appropriate columns

as these are fundamentally flawed and using them to access data in NetWeaver database is just wrong.

See my blog [Questions to SAP Support: Is ODBC access to the database a good idea?|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/9742] [original link is broken] [original link is broken] [original link is broken]; for a more complete discussion on this.

As a short version just don't do it.

> Just a suggestion : you can also see the table content using SE16 tx..

Now, that's some kind of advice!

Use the tools of NetWeaver to get your data, instead!

SE16, SAP Queries, ABAP reports - all this stuff is already available in your system and easy to use.

regards,

Lars

[Former Member]

Hi Lars,

Apologies and Agreed in principle.. Using the SAP provided tools is the best and safest option.

However, at my customer site they have some legacy systems which fetch data from SAP tables of the central ECC prod system using dblinks. Of course we have restricted the access to that user giving only select access. But still I think this is a major security concern. But is there any other way of doing it?

Regards,

Anup..

[lbreddemann]

> However, at my customer site they have some legacy systems which fetch data from SAP tables of the central ECC prod system using dblinks. Of course we have restricted the access to that user giving only select access. But still I think this is a major security concern. But is there any other way of doing it?

Well, the legacy systems you mentioned should use a proper data interface instead of direct data structure (e.g. table) access instead.

Something like RFC-calls for example.

Or a XI-connector.

Or a Web-Service.

Or ... or ... or ...

There are in fact many options.

Just acessing the tables is by far the worst option to go.

At the very least, I'd use views to ensure that only the required data is visible via this dblink and that the access structure (that is, how the views look like) remain the same, even if the SAP application changes in the background.

Even better would be to provide PL/SQL access procedures.

That way the legacy application could use a procedure call and wouldn't have to deal with the SAP table design.

regards,

Lars