Oracle

Pre-requisites

To connect your Oracle database , you need:

1. Your database host's IP (e.g., 1.1.1.2) or domain (e.g., my.server.com)

2. Your database's port (usually 1521 for unencrypted connections and 2484 for encrypted connections using SSL/TLS)

3. Your database's system identifier (SID)/service name

4. A user created for accessing the required data and username and password for that user

Supported versions: 19c , 23c

Currently, Oracle connector supports for Table, On platform asset creation and cannot be used as an export location.

Configuration steps

1. Go to Manage->Connectors, select Oracle option and create a connector using your database details

2. Connector can now be used within your organisation when creating assets

Creating assets from Oracle

1. When creating assets, user must select connector and:

   1. Schema

   2. Table or a view that will be used to create an asset

2. Once asset is created, further updates can be set up using Updates tab on a scheduled frequency or triggered manually