Welcome to the Oracle DB Connector Setup guide!
In this article, we will cover the following:
Authenticating Oracle DB in Savant
Connecting Data from Oracle DB
Authenticating Oracle DB in Savant
IP Whitelisting
Savant accesses your Oracle DB from two IP addresses:
35.188.163.165
34.122.126.216
If your network is configured to only allow access from certain IPs, include these in your whitelist.
Create a Savant User in Oracle DB
We recommend creating a specific user and role for Savant with permission to access the required table(s) in Oracle DB. If you already have a user and role created with appropriate permissions, you can skip this step.
CREATE ROLE savant_role NOT IDENTIFIED;
CREATE USER savant_user IDENTIFIED BY {password};
GRANT UNLIMITED TABLESPACE TO savant_user;
GRANT savant_role TO savant_user;
Grant Permissions in Oracle DB
Grant the Savant user privileges to access all tables.
Run these commands to grant permissions to the Savant role:
GRANT CONNECT TO savant_role;
GRANT CREATE ANY TABLE TO savant_role;
GRANT DROP ANY TABLE TO savant_role;
GRANT ALL ON {schema}.{table} TO savant_role;
Adding Oracle DB System in Savant
Once you’ve completed the steps above, follow these steps in Savant:
Go to the Systems page and click Add System
Select the Oracle DB connector and click Next
Enter your system information and credentials from above
Configure SSL or SSH as required (see below).
Click Authenticate and then Confirm
SSL (Recommended)
To turn on SSL, check the "Use SSL" option, and enter your self-signed certificate in the text box.
If you do not enter a certificate, a standard certificate will be used.
Example:
-----BEGIN CERTIFICATE-----
MIIDHzCCAgegAwIBAgIUFrpVEmv/6tsiiiuDXaxpEW4mNhUwDQYJKoZIhvcNAQEL
BQAwHzEdMBsGA1UEAwwUKi5zcWwuc2F2YW50LWRldi5uZXQwHhcNMjIwMzI2MTM1
NjQzWhcNMjMwMzI2MTM1NjQzWjAfMR0wGwYDVQQDDBQqLnNxbC5zYXZhbnQtZGV2
Lm5ldDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAL57IDUoPLtIpheL
LiOcc2xIBhtMZfE4g4CCmbetwoIJXYptbxld/lS7xbOgdpWK0FMpuIg5x+NBWfqw
bLnp0/2INP/78LO4U5aAJp3m45mNRKWzAKMtcrX7kW4OfL2DcaIb5vKkFY+Y3oDr
3JVsnOfbx5vS2ppfIuQEKX+gRoijTEaMxQoyaV6MSsJ9HVMidlKG+4KO3/V29Wst
rvGbbSnS5rvFIgGTahcwMa7C/pngGTbGZW8gUE21G2e7Iq1Lv7y7Yw89xW227ttG
T84BdsTjSVAFgaddENftSSsHUrlsKUfV1VqjQpyxEXPI3wLFR/0LaWaJl571EONm
eNjV4+UCAwEAAaNTMFEwHQYDVR0OBBYEFIYXUucb43NG/HFwqtsSbdLtGCWVMB8G
A1UdIwQYMBaAFIYXUucb43NG/HFwqtsSbdLtGCWVMA8GA1UdEwEB/wQFMAMBAf8w
DQYJKoZIhvcNAQELBQADggEBAES5WrvFbRNILSMTdK39DcKBzhKTQ4GhPA8PrhxR
cNZQl7zqEzSxNaVRGTJlOEuUNAr2gnInnCT0CsraQ56f2glJWryQUoR0TDJvH1QY
KJJcyBBfYZaeNyuY+anNJgleIiZ3HD5H5/3Dr0hXhJKUH8O0/G1hNeVbilsgeApv
3T8hb/VcraeoHEDW39rleu2U0iosLgAbiC1SBwPu2xRSzZKjOU3X5FvahsG+aZfF
6KvcCAFYzR70RMo8bHhthh3F/6PoV4YIsoS1YbrHGt1T2GbrKJrdZfqO+IiQn7a0
r5BWz7FvduCH//L8TIW+ovB+mrEMzVP6KTn5EQhD2oKiBVA=
-----END CERTIFICATE-----
Connecting Data from Oracle DB
On the top left side of your canvas, click the Add Source button, shown below and select your new Shopify connection.
If you are not currently within an analysis, you can add your connection by navigating to Data and selecting New Dataset. Select your previously authenticated Oracle DB system from the list of available options and click Next.
Now you can configure the dataset and decide which data from various objects you would like to import into your analysis.
Select which Object you would like to import into your data source from the drop down menu.
Select which Columns you want to include in the dataset.
Once you're done, click Next.
Next, add a name and description to your data set to be used within your canvas and click Confirm.
Your data from Oracle DB is now placed on your canvas as a source for your analysis!