SAP Oracle connection to Exgternal App

[sunilv_dev]

How can I establish a connection to SAP Oracle database from external application using .Net connector? I understand that an SAP User Id needs to be created and given certain permissions to allow external database access.

Can anybody provide me more details??

[former_member204746]

you need to access through SAP. you are not allowed to use an Oracle connector as per the SAP license.

Try a developper forum. maybe ?

[markus_doehr2]

Technically no problem but I´d say this depends on how you have licensed Oracle. Check

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:

• Creating database users

• Creating database segments

• Querying/changing/creating data in the database

• 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).

<...>

Markus