Guides
Connectors
Databases
Oracle

Connect to an Oracle database

MOSTLY AI can use an Oracle database as a source for original data and deliver synthetic data to another Oracle database. You can create separate connectors for the source and delivery of synthetic data.

Prerequisites

Obtain the Oracle database connection details.

  • hostname
  • port
  • whether you connect to your Oracle database with a SID or a service name connection type
  • database credentials
  • database name (SID or service name)
  • schema name

Steps

  1. From the Connectors tab, click Create connector. Click Create connector button The Create connector drawer appears on the right.
  2. On the Connect to database tab, select Oracle. Select Oracle connector
  3. On the Create Oracle connector page, configure the connector.

    1. For Connector name, enter a name that you can distinguish from other connectors.

      A combination of Oracle + _DATABASE_ + _SCHEMA_ might help you identify this connector among other Oracle connectors.

    2. For Connection type, select whether you want to use the connector as a source or destination.

      You can select only data source connectors when you create a new catalog.

      Similarly, you can select only data destination connectors when you configure a destination for the new synthetic dataset.

    3. For Hostname, enter the Oracle database hostname.

    4. For Port, enter the database port.

      By default, the port for Oracle databases is 1521.

    5. For Connection type, select SID or SERVICE_NAME.

    6. For Username and Password, enter your Oracle database credentials.

    7. For Database, enter the name of the database SID or service name depending on your selection in step 3d.

    8. For Schema, enter the name of the database schema.

      Select Oracle connector
  4. Click Test connection to make sure the configuration is correct.
    If you see a successful connection message, then MOSTLY AI connected to your Oracle database successfully and found the provided database and schema.
  5. Click Save to save your new Oracle connector.

What's next

You can now use the Oracle connector as a data source when you create a new catalog.

You can also use the Oracle connector as a destination.

You can use different types of data sources and destinations for a synthetic dataset. For example, if your data source is a Oracle database, you can deliver the generated synthetic to any of the supported databases or cloud storage providers.