Castodia automatically imports fresh data from your Oracle Database to your Google Sheets on a highly customizable schedule. Auto-refresh data as often as every 1 minute for near real-time data.
Castodia lets you pull data from your Oracle database directly into Google Sheets.
To connect your Oracle database, follow the steps below:
Step 1: Open the Castodia Admin Dashboard
Step 2: From the Databases Menu, click on Create
Step 3: Add a nickname for your database connection
Step 4: From the dropdown menu, select Oracle
Step 5: Gather and enter your database connection information. Note that you must whitelist our IP (184.108.40.206) if your database isn't open. Contact your IT team for help with this.
Step 6: Click the "Test" button to verify your credentials
Step 7: Click the "Save" button once a green notification pops up, indicating that the add-on was successfully installed.
And that's it! Enjoy running your queries.