{"id":11053,"date":"2021-02-28T13:31:10","date_gmt":"2021-02-28T12:31:10","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=11053"},"modified":"2023-11-08T14:59:16","modified_gmt":"2023-11-08T13:59:16","slug":"connecting-via-jdbc-to-the-oracle-cloud","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2021\/02\/28\/connecting-via-jdbc-to-the-oracle-cloud\/","title":{"rendered":"Connecting via JDBC to the Oracle Cloud"},"content":{"rendered":"\n

You can connect to an Oracle Autonomous Database in different ways. This is well documented here<\/a>. It’s a bit different from what we know from on-premises environments. In this blog post, I show the steps to connect to an Autonomous Database from a third-party IDE like DataGrip<\/a>.<\/p>\n\n\n\n

From a JDBC perspective, this is just an ordinary JDBC URL with some driver-specific properties. Therefore, this approach should work for any JDBC-based IDE and also for any Java application.<\/p>\n\n\n\n

Step 1 – Download the Wallet<\/h2>\n\n\n\n

Go to your Autonomous Database and click on the “DB Connection” button. A screen similar to the following appears:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Press on the “Download Wallet” button and enter a password. This password is used to protect the key and the trust store. We will need it later. I named my instance “ATP21”. Therefore, in my case, a zip archive named “Wallet_ATP21.zip” was downloaded.<\/p>\n\n\n\n

Step 2 – Unzip the Wallet<\/h2>\n\n\n\n

Unzip the downloaded zip file and move it to a location where want to keep it. The wallet contains the following files:<\/p>\n\n\n\n