Oracle
An overview of the Oracle integration with Secoda
Getting Started with Oracle
There are three steps to get started using Oracle with Secoda:
Create a database user
Whitelist Secoda IP Address
Connect Oracle to Secoda
Create a Database User
The username and password you’ve already created for your database is your admin password, which you should keep for your own usage. For Secoda, and any other 3rd-parties, it is best to create distinct users.
To create a new user, you’ll need to log into the Oracle database directly and run the following SQL commands:
Whitelist Secoda IP Address
VPCs keep servers inaccessible to traffic from the internet. With VPC, you’re able to designate specific web servers access to your servers. In this case, you will be whitelisting the Secoda IPs to read from your data warehouse.
Allow Secoda to read into your Oracle database from the Secoda IP address.
Connect Oracle to Secoda
After creating a Oracle user, the next step is to connect Secoda:
In the Secoda App, select "New Integration" from https://app.secoda.co/integrations
Search for and select "Oracle"
Enter your Oracle credentials
Click "Test Connection"
Click "Submit"
Select the schemas you'd like to import and click "Submit"
Click "Run Initial Extraction"
Last updated