How to use TOAD software in SAP Oracle ?

[Former Member]

Dear Friends,

Is possible to use Toad sotware (for accessing tables & write query to get data from table) in SAP Oracle ?

Will it create any log or log file in Oracle or in SAP iteself ?

Kindly, suggest me.

Suppose, if you know any other query software to connect SAP oracle, kindly, get back to me.

Thanks & Regards,

Rajagopal

Chennai - INDIA

[lbreddemann · Accepted solution]

> Is possible to use Toad sotware (for accessing tables & write query to get data from table) in SAP Oracle ?

Possible: yes.

Good idea/recommended: no. no way. One of the worst things to do.

> Will it create any log or log file in Oracle or in SAP iteself ?

As long as Oracle auditing hadn't been enabled, no logs about any data access are created.

Even worse, by directly accessing the database 'below' NetWeaver you bypass all security and all consistency checks for your data.

You can see/edit all data in all tables.

As no referential constraints are implemented on DB level (these are only handled by the NetWeaver application tier) it's likely that inconsistencies are created by modifying data directly on DB level.

This would of course render any audit (SOX, etc.) result void as the data could have been manipulated.

> Suppose, if you know any other query software to connect SAP oracle, kindly, get back to me.

It really doesn't matter what query tool you're going to use.

The point is: direct SQL access for a SAP database is not what you should do and very likely not what you want to do.

If you need business data from your SAP instance, why not write a report, a BAPI, a WebServer ... that provides the data the way you want it? It's simple, clean, well documented and supported.

Direct SQL access to the SAP database is the same as looking to your Oracle data by displaying the blocks of a data file with a hex-editor. Although possible you don't do that to access your data, do you?

regards,

Lars

[fidel_vales · Accepted solution]

In addition to what Lars mentioned you should take a look at the SAP note 581312 "Oracle database: licensing restrictions"

As of point 3, it follows that direct access to the Oracle database is  
only allowed for tools from the areas of system administration and      
monitoring. If other software is used, the following actions, among     
other things, are therefore forbidden at database level:                                                                                
o  Creating database users                                                                                
o  Creating database segments                                                                                
o  Querying/changing/creating data in the database                                                                                
o  Using ODBC or other SAP external access methods                                                                                
This means that additional application software is only allowed if this 
accesses the database through SAP interfaces (for example, RFC, SAP J2EE
or BAPI).