Oracle DB

Power internal tools, in-app experiences, and more

Supported syncing

Connect to Oracle DB

Go to the Destinations overview page and click the Add destination button. Select Oracle DB and click Continue. If you're not using a tunnel, you can then authenticate Hightouch to Oracle DB by entering the following fields:

• Host: The hostname or IP address of your Oracle server.
• Port: The port number of your Oracle server. The default port number is 1521, but yours may be different.
• Database: This specifies the database to use when Hightouch executes queries in Oracle DB. This is different than the host, but your host address might contain your database name.
• Username: The user that has access through Hightouch to the database and tables you want to sync to. It's best to create a new user specifically for Hightouch access. Do not use the root user.
• Password: The password for the specified user.

To ensure your credentials are correct, click Test connection. This confirms if Hightouch can connect to your database by running a basic SELECT query.

Required permissions

The user you use to authenticate must have the following permissions:

• Add, update, and delete (if applicable) rows in your sync's table.
• Create tables in your database, which are kept only temporarily and used to perform MERGE operations. These tables are cleaned up at the end of each sync.
• View the following tables which are used for gathering metadata to set up the sync:
  • USER_CONSTRAINTS
  • USER_CONS_COLUMNS
  • USER_CATALOG
  • USER_TAB_COLUMNS

SSH tunneling

Hightouch can connect directly to Oracle DB over the public internet or via an SSH tunnel. Since data is encrypted in transit via TLS, a direct connection is suitable for most use cases. You may need to set up a tunnel if your Oracle DB instance is on a private network or virtual private cloud (VPC).

Hightouch supports both standard and reverse SSH tunnels. To learn more about SSH tunneling, refer to Hightouch's tunneling documentation.

Sync configuration

Once you've set up your Oracle DB destination and have a model to pull data from, you can set up your sync configuration to begin syncing data. Go to the Syncs overview page and click the Add sync button to begin. Then, select the relevant model and the Oracle DB destination you want to sync to.

Hightouch supports Upsert mode, with the option to delete removed rows.

Record matching

Hightouch requires you select a unique identifier in the table you are syncing to. The model column you select must match a UNIQUE, PRIMARY KEY column within Oracle DB.

You can see columns that fit this criteria as available options in records matching section.

If there are no fields in the dropdown, you must add a unique type column to your Oracle DB table. Then, click the refresh icon to access the newly created column.

Column types

Hightouch works out of the box with most standard column types, including:

• VARCHAR2
• NUMBER
• TIMESTAMP
• DATE
• BINARY_FLOAT
• BINARY_DOUBLE

If you see type errors, it may be because your model is producing the wrong format. If so, use typecasting to resolve the issue.

Field mapping

Select which model columns you want to sync to your Oracle DB table columns. Hightouch automatically pulls the columns from your table to make them available for you to map.

Batch size

You can tune the number of rows that Hightouch upserts per query based on your needs and database threshold. The default is 1000 rows per batch.

Delete behavior

The delete behavior you select dictates what to do when a row no longer appears in your model's query results. You have the following options:

Tips and troubleshooting

Common errors

If you encounter an error or question not listed below and need assistance, don't hesitate to reach out. We're here to help.

Compatible versions

The supported Oracle DB version is 19c. Other versions aren't officially supported but may work regardless.

Live debugger

Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.

Sync alerts

Hightouch can alert you of sync issues via Slack, PagerDuty, SMS, or email. For details, please visit our article on alerting.

Unsupported data types

Hightouch does not support INTERVAL types for Oracle.