Oracle

You can integrate with Oracle in a few steps.
Follow these steps:

• Create a read-only user
• Grant it the permissions required for Sifflet to operate
• Connect to Sifflet

1- Create a read-only for Sifflet

To create the user, you will need to run the following SQL query.

CREATE USER SIFFLET_READ_ONLY_USER IDENTIFIED BY <password>; --replace with a password

Store the username and the password carefully as you will need them to connect to Sifflet later.

2- Grant the permissions

You can now assign the permissions to the newly created user.

-- Permissions
GRANT CREATE SESSION TO SIFFLET_READ_ONLY_USER;
GRANT SELECT ANY DICTIONARY TO SIFFLET_READ_ONLY_USER;
GRANT SELECT ANY TABLE TO SIFFLET_READ_ONLY_USER;
GRANT SELECT_CATALOG_ROLE TO SIFFLET_READ_ONLY_USER; 

3- Connect to Sifflet

Create the Secret

• In "Integration" --> submenu "Secrets", create a new secret
• In the "Secret" area, copy-paste the username and password that you previously saved in step 1

{
  "user": "SIFFLET_READ_ONLY_USER",
  "password": "password"
}

Add the datasource

On the left panel, choose "Integration" and then the "Sources" submenu

• Click "New" Datasource and choose "Oracle"

• Information required:

  • Name: the Sifflet name of the datasource
  • Host: the host of your Oracle instance
  • Port: the port of your Oracle instance
  • Database: the database you want to connect to
  • Schema: the schema you want to connect to
  • Secret: the secret you just created in the previous step