Skip to main content

Oracle

Oracle is a supported data source for SQL queries.

How to Setup​

To connect to a Oracle data source you need to register a Oracle credential. This requires:

  • the name of the credential (which you can choose);
  • the hostname, port, username, password database and schema name to connect to.
info

Note that you must define a credential per remote schema; if you wish to access tables from two separate remote schemas, you must define two credentials, one per schema.

Table Mappings​

The tables available in the schema of the remote database are available to query using the name of the credential as the "schema name".

For instance, if you register a credential and call it "db01", then you can query a table in it using e.g. "SELECT * FROM db01.table".

Limitations​

  • Oracle DB versions 10.1+ are supported. Older versions are not yet tested.

Authorization and User Privileges​

  • Remote Schema Authorization: When the platform connects to a remote database, it adheres to the existing authorization rules and user privileges of that database. This means platform's access to data and schema elements is dictated by the permissions set in the remote database.
  • Local Schema Permissions Mapping: Once the remote schema is made available, the platform maps its permissions locally within its environment. This ensures that user access in the platform is reflective of the original database’s security constraints.
  • Dynamic Privileges Adjustment: As the platform synchronizes with the remote database, any changes in user privileges or authorization rules are dynamically updated locally. This feature maintains consistent security and access control, mirroring the remote database’s settings.