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?

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


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.


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=",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

Howdy, Stranger!

Log In

To view full details, sign in.


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