Oracle

Last updated on Feb 03, 2023

Hevo supports the following variations of Oracle as a Source:

Click each variant above to know the prerequisites and pre-configuration setups specific to it. Once you complete the setups, follow the steps mentioned below to configure it as a Source in your Hevo Pipeline and start ingesting data.


Select the Source Type

To select Oracle as the Source:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select the Oracle variant.


Specify MySQL Connection Settings

In the Configure your Oracle Source page, specify the connection settings for your Oracle Source.

Read the documents in this section to know the detailed configuration steps for each Oracle variant.


Objects and Query Mode

Do one of the following:

  • For Pipeline with Table or RedoLogs mode:

    1. Once your respective Source connection settings are specified in Step 2 above, select the objects to be replicated in the Select the Objects you want to replicate page, and then click CONTINUE.

      Object Selection

      Note: Each object represents a table in your database.

    2. In the CONFIGURE SOURCE OBJECTS page, specify the query mode to be used for each selected object.

  • For Pipeline with Custom SQL mode:

    1. In the Provide Query Settings page, enter the custom SQL query to fetch data from the Source.

      Custom SQL

    2. In the Query Mode drop-down, select the query mode.

Continue to complete the subsequent steps and configure the Destination system.


Limitations

None.



See Also



Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Aug-24-2022 1.96 Updated section, Limitations to remove limitation regarding Hevo not supporting RedoLog Ingestion mode for Oracle Database 19c or higher.
Apr-21-2022 1.86 - Updated sections, Specify Oracle Connection Settings and Objects and Query Mode.
- Removed section, Select the Pipeline Mode.
Dec-06-2021 1.77 Added a See Also link to the Pipeline failure due to Redo Log expiry page.
Nov-26-2021 NA Added section, Limitations
Jul-26-2021 1.68 Added a note for the Database Host field.
Jul-12-2021 1.67 Added the field Include New Tables in the Pipeline under Source configuration settings.

Tell us what went wrong