Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to connect Oracle ADW with JDBC url in data management using EPM Agent? — Cloud Customer Connect
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
17
Views
3
Comments
edited Mar 16, 2021 7:44AM in Planning 3 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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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