Connect Oracle to Row Zero

Row Zero's built-in Oracle connector makes it easy to connect your spreadsheets to Oracle. Follow the instructions below to connect to Oracle, share your connection with others, and import data.

Create your Oracle connection

To create a new connection:

1. From your Row Zero homepage, click + New in the upper left corner and then choose Connection.

   

2. Choose Oracle. The Oracle connector requires a few pieces of information defined below.

   

   • Connection name - This field can be anything that helps identify the data source being connected (e.g. "Production Data" or "Product Metrics"). It will be visible to all users who have access to this connection.
   • Host - This is the Oracle address that typically takes the form of a string like 'database.mydomain.com'.
   • Port - This is often 1521.
   • User - This is the username for your Oracle database.
   • Password - The password used to log into your Oracle Database.
   • Database - The name of the Oracle database being connected to.

3. Once all the information is entered, hit 'Test connection' to ensure the information is correct. If the test connection icon turns green and says 'Connected', proceed by clicking on 'Create Connection.'

Note: If your database is behind a VPN or firewall, you'll need to allow the Row Zero IP addresses: 18.217.97.112 and 18.224.119.220.

Share your connection with other users

If you would like other users to be able to use this user/password to query Oracle from Row Zero, you can securely share the connection with them in Row Zero. This is appropriate if multiple users share a service account. To share your connection in Row Zero:

1. Navigate to your Connections page.
2. Find the Connection that you'd like to share, click '...' next to the name of the connection, and select 'Manage sharing'.
3. Enter the emails of the users or groups that should have access to this connection.

Write a query to import Oracle data

Now that you have created an Oracle connection, you can import data by writing queries directly from Row Zero. See Data Import to learn how.