Going Off-Piste: ODI 12c Standalone Agent Connection to Snowflake

Michael Rainey
Feb 16, 2019 · 4 min read
jdbc:snowflake://aws_cas2.snowflakecomputing.com/?warehouse=MRAINEYWH&db=MRAINEY&schema=DONORSCHOOSE
Image for post
Image for post
javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
Image for post
Image for post
if [ ! -z $IS_AGENT_SCRIPT ] ; then
ODI_SSL_PROPERTIES="-Djavax.net.ssl.trustStore=${WL_HOME}/server/lib/DemoTrust.jks -Djavax.net.ssl.keyStore=${DOMAIN_HOME}/security/DemoIdentity.jks"
else
ODI_SSL_PROPERTIES="-Djavax.net.ssl.trustStore=${WL_HOME}/server/lib/DemoTrust.jks -Djavax.net.ssl.trustStorePassword=DemoTrustKeyStorePassPhrase"
fi
# Added by the customer to unset the property
ODI_SSL_PROPERTIES=""
ODI_INSTANCE_JAVA_OPTIONS="$ODI_ADDITIONAL_JAVA_OPTIONS $ODI_SSL_PROPERTIES"

SnowflakeDB

Articles from Snowflake data engineers, evangelists…

Michael Rainey

Written by

Data warehousing in the cloud @SnowflakeDB, data integration, ETL, and everything in between.

SnowflakeDB

Articles from Snowflake data engineers, evangelists, developers, partners, and users on all things Snowflake and the cloud data warehouse.

Michael Rainey

Written by

Data warehousing in the cloud @SnowflakeDB, data integration, ETL, and everything in between.

SnowflakeDB

Articles from Snowflake data engineers, evangelists, developers, partners, and users on all things Snowflake and the cloud data warehouse.

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch

Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore

Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store