Articles in this section

See more

Oracle DB + Smart Ingest

Smart Ingest lets you pull data stored in your Oracle Database and push it to Iterable. This integration is compatible with Oracle Database version 19c. Other versions may work as well but are not officially supported.

NOTE

Smart Ingest can only import data from Oracle Database.

In this article

Connection requirements

To connect to Oracle DB, you need the following details:

  • A connection type - Smart Ingest connects to Oracle DB using a direct connection or an SSH tunnel. To learn more about SSH tunneling and how to set up standard and reverse tunnels for Smart Ingest, read SSH Tunneling for Smart Ingest.

  • Host - The hostname or IP address of your Oracle DB.

  • Port - The port number of your Oracle DB. The default port number is 1521, but yours may be different.

  • Database - The name of the database to use when Smart Ingest executes queries in Oracle DB. This is different than the host, but your host address might contain your database name.

  • User - This can be your personal Oracle DB login or a dedicated user for Smart Ingest. The user should, at minimum, have permission to read the tables you want to sync.

  • Password - The password for the user specified above.

Before you connect Smart Ingest to Oracle DB, make sure to allow Smart Ingest IPs to connect to your database.

Connecting Oracle DB to Smart Ingest

To connect Smart Ingest with your Oracle database:

  1. Log in to Iterable as a user with the Manage Integrations project permission and open the project you’re working on.

  2. Go to Integrations > Smart Ingest.

  3. Click Connect a New Source.

  4. Select Oracle DB and click Continue.

  5. In Step 1 select the connection type your sync should use to connect:

    • Connect directly to Oracle DB. This creates a direct connection with no additional setup needed.

    • Connect via SSH Tunnel. This connects using SSH. Add a standard or reverse tunnel, or select an existing tunnel if you’ve already set one up.

      To learn more about SSH tunneling and how to set up standard and reverse tunnels for Smart Ingest, read SSH Tunneling for Smart Ingest.

  6. In Step 2, enter your Oracle DB database details: Host, Port, and Database.

  7. In Step 3, enter your user credentials for Oracle DB: User and Password.

  8. Click Continue. Smart Ingest automatically tests the connection.

  9. When the connection test is successful, click Continue. (If there are problems connecting, click Back and review the connection details for accuracy.)

  10. Add a name for your data source to display in Iterable.

  11. Click Finish.

Next steps

You've now connected your data warehouse to Smart Ingest. The next thing you can do is create a sync.

Troubleshooting

Unsupported data types

Smart Ingest does not support INTERVAL types for Oracle, including INTERVAL YES and INTERVAL DAY.

Related articles