Documentation

Connecting to Oracle

Integrating your Oracle database with Alooma is easy in just a few steps:

Note

Alooma does not support LOB data types (BLOB, CLOB, NCLOB) on Oracle 12c when using log replication / LogMiner.

  1. How do you want to connect to Alooma? If it's via an SSH server, check out how to connect via SSH. Otherwise, you'll need to whitelist access to Alooma's IP addresses.

  2. Add and name your Oracle input from the Plumbing screen and enter the following details:

    • Hostname or IP address of the Oracle server (default port is 1521)

    • Username and Password

    • Database name

    • Schema name (optional)

  3. If your Oracle server is behind an SSH server you can connect to Oracle via SSH.

  4. Choose the replication method you'd like to use for Oracle database replication

    For full dump/load replication, provide:

    • A comma-separated list of the names of the tables you want to replicate.

    • The frequency at which you'd like to replicate your tables. The more frequent, the more fresh your data will be, but the more load it puts on your Oracle database.

    For incremental dump/load replication, provide:

    • A set of table/update indicator column (dtLastModified) pairs for each table you want to replicate. You should also index the indicator columns.

    Follow the instructions for creating an index here: https://docs.oracle.com/cd/B28359_01/server.111/b28310/indexes003.htm#ADMIN11724

    For log replication:

    • Make sure you performed the required setup steps.

    • Provide a space- or comma-separated list of the names of the tables you wish to replicate (or leave blank to replicate all tables).

    • Choose whether you'd like to dump and load an initial snapshot of your tables into your data destination. This option only works if you've selected specific tables, and works best for small tables (under 100M rows). If you have larger tables or want all tables, please contact support@alooma.com.

Keep the mapping mode to the default of OneClick if you'd like Alooma to automatically map all Oracle tables exactly to your data destination. Otherwise, they'll have to be mapped manually from the Mapper screen.

Alooma maintains three tables in your target database per each table in Oracle.

That's it! You're done integrating Oracle and Alooma.

Search results

    No results found