When trying to connect to Snowflake via JDBC connection method to Reverse Engineer, connection fails with the below error:
"200015 JDBC driver encountered communication error. Message: Exception encountered for HTTP request: No trusted certificate found. "
To resolve this issue, you have to import the Snowflake SSL certificate into erwin Data Modeler's Java Trustore. Please follow the below steps to obtain and import the certificate.
1. In a browser, go to Snowflakes login page
2. To the left of the URL, click the lock icon and when the certificate window opens, go to the"Certification Path" tab. Chose "ESET SSL Filter CA" or the certificate name and click View Certificate.
3. On the resulting window, go to the "Details" tab and click "Copy to File"
4. Use the resulting wizard to export the certificate to a local file
Once you have the certificate, import it to Data Modeler's truststore using the below steps:
1. Open Command Prompt
2. Run the below command
"<Data Modeler Home>\JRE\bin\keytool.exe" -importcert -file <certificate from previous step> -keystore "<Date Modeler Home>\JRE\lib\security\cacerts" -alias <alias>
...where Data Modeler Home is the install location of Data Modeler and Alias is an identifier for the certificate. This will prompt for a password, which is "changeit" and then trust the cert.
If the above was done correctly, you will no longer get the "No trusted certificate error", but you may now see the below error instead:
- 0 No suitable driver found for jdbc:snowflake://snowflakecomputing.com ?user=&warehouse=WH_DEV&role=R_EDW_DATAMODELER&db=EDW&schema=WH
To resolve this, try typing the connection string directly instead of copy and paste. You should now be able to successfully reverse engineer from snowflake.