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

Configure Snowflake connection with EPM Integration Agent

Accepted answer
320
Views
7
Comments

I am trying to connect to Snowflake via the EPM integration agent.

I have followed the documented steps.

I am using a File Credential Store.

I am now receiving this error: Exception: java.lang.RuntimeException: EPM agent failed to extract data.

Oracle Doc ID 2666748.1 indicates that I may have the jdbc url incorrect, but I am struggling to reconcile the documented URL format with the Snowflake URL provided to me.

Documented format: jdbc:sqlserver://server:port;DatabaseName=dbname

jdbc:snowflake://<account_identifier>.snowflakecomputing.com/?<connection_params>

Has anyone successfully connected to Snowflake via the EPM Integration Agent and can share the JDBC File format that worked?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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