Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

can't connect to external Oracle DB with JDBC connector

Hello guys,

I had failed to connect to connect external Oracle via JDBC connector .

Could you please help me to resolve the problem ?


We need to connect the external Oracle DB with JDBC connector, because BI need to connect to the target Oracle. If the JDBC connector suceed, BI will create a UD which use the datasource

we create in Visual admin to connect to the external Oracle DB.


Our EP version is NW04S SP17 , OS is AIX .

The target Oracle DB version is 10g(, 64bi).

Configuration procedure :

1. Import Oracle driver "ojdbc14.jar" and create new driver which named "Oracle " under

JDBC Connector ->Run time ->Driver in Visual Admin.

2. Create datasource "Mydatasource" under JDBC Connector ->Run time ->Data Source,

Name : Mydatasource

Driver Name : Oracle

JDBC version: 2.0(with XA support)

JDBC compliant:

Object Factory :oracle.jdbc.pool.OracleDataSourceFactory

DataSource Type: ConnectionPoolDataSource

*CPDS class name :oracle.jdbc.pool.OracleConnectionPoolDataSource


Additional Properties:



Password: *****



URL :jdbc:oracel:thin@


Connectoin Pool:

Initial Connectons: 1 Expiration: (check)

Maximum Connections: 25 Connection Lifetime :600

Maximum time wait of connection : 60 Cleanup Thread : 200

Default Connectoin Isolaton :Default

SQL Engine:

Open SQL

3.Create Connector :

Copy the standard connector :SDK_JDBC to SDK_JDBC_Oracle,

Resource Adopter:

Loader References:

Add "libray:Oracle" .

Managed Connection Factory:

Configuration Property:


Password: ****


URL: jdbc:oracle:thin@

All fo my configuration had been listed.

And I had created JCO RFC : JT-BIDEV_PORTAL_BD1 , and created RFC connection with SM59 in BI.

Please give me some suggesiton.



Former Member
Not what you were looking for? View more on this topic or Ask a question