Registering an Oracle Data Source¶

Before synchronizing data from an Oracle data source, you need to register the data source to configure the Oracle connection.

This section shows the steps to register an Oracle data source in EnOS.

Procedure¶

In the EnOS Management Console, click Data Source Registration from the left navigation menu.
Click Add Data Source and provide information for the following.
- Data Source Type: Select ORACLE.
- Driver Version: Support ojdbc8 version and ojdbc14 version. Click Query Version, and view what’s new in ojdbc14(19C).
- Data Source Name: Enter a name for the data source. The maximum length is 50 characters and can be a combination of the following characters.
  - a through z
  - A through Z
  - 0 through 9
  - _ (underscore)
  - -（hyphen）
- Data Source Description: Enter a description for the data source.
- Host Name or IP Address: Enter the host name or IP address where the database is hosted.
- Service Name or SID: Enter the service name or the SID of the Oracle database.
- Port: Enter the port number. The default port is 1521.
- Username: Enter the user name for accessing the Oracle database.
- Password: Enter the password of the user name.
Click Test to test the data source connection.
Click Done to save the configuration.

The data source will be shown in the Data Source Registration table.

When the connection is successfully established, you can follow the steps below to synchronize data from the data source to EnOS Hive.

Create a channel to read Hive data source, refer to Creating a Channel.
Configure a data synchronization job to synchronize data from the data source to the target Hive table. For more information, see Data Synchronization.