You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to connect Oracle ADW with JDBC url in data management using EPM Agent?

edited Mar 16, 2021 7:45AM in Autonomous Database 6 comments

Content

Hi Team,

We had the data and metadata integration with DBCS (Database cloud services) using EPM Agent. But, now we have opt for Oracle ADW (Oracle Autonomous Database). Hence when changing the JDBC URL in Application Filter (Target Application) pertaining to ADW, we are getting an error.

Hostname:1521/servicename

New JDBC URL (ADW): jdbc:oracle:thin:@(description= (address=(protocol=tcps)(port=1522)(host=Hostname))(connect_data=(service_name=ServieName))(security=(ssl_server_cert_dn="CN=CN.oraclecloud.com,OU=Oracle ADB SYDNEY,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))

While running the data load rule after changing the JDBC URL i am getting below error

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!