Use an Oracle database for synthetic data

To use a Oracle database as a source for original data as well as a destination to deliver synthetic data, you need to create Oracle connectors.

For each Oracle data source or destination, you need a separate connector.

Prerequisites

To create an Oracle connector, you need the Oracle database connection details.

Host
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)

Create a new Oracle connector from the Connectors page.

Steps

From the Connectors page, select Oracle Database under the Connect your data header.
On the New connector modal, configure the connector.

Field	Description
Name	Enter a name that you can distinguish from other connectors.
Access type	Select whether you want to use the connector as a source or destination.
Host	The Oracle database hostname.
Port	The database port.
Username	The Oracle database username.
Password	The Oracle database password.
Database	The name of the database SID or service name depending on your selection for Connection type.
Connection type	Select whether you the connection uses SID or Service name.

Click Save to save your new Oracle connector.
- MOSTLY AI tests the connection. If you see an error, check the connection details, update them, and click Save again.
- You can click Save anyway to save the connector disregarding any errors.

What’s next

Depending on whether you created a source or a destination connector, you can use the connector as: