Oracle

Navigate to the page with all the Data Connector icons and search for Oracle Data connector. Click on the Oracle icon.

A form opens to create Oracle Data Connector. Provide the following information to create an Oracle Data Connector:

• Data Connector Name: Provide a user-defined name to identify the data connector.

• Description: Provide the connection details (optional).

• Username: Enter a Username (It should be the same as given in the connection server).

• Password: Enter the Password (It should be the same as provided in the connection server).

• IP/Host: Enter database server details (from where the user wants to fetch data).

• Port: Provide the server port number.

• SID Service Name: Provide the unique alias used for the database (when connecting).

• Click the ‘Save’ option.

• The success messages appear to confirm the connection and creation of the new Oracle data connector.

• The newly created Oracle data connector gets added to the Data Connectors list.

Note: Note: The user can use the following Environment Variables instead of the actual Username and Password to create the Oracle Data Connectors.

• Username: ENV.ORACLEUSERNAME

• Password: ENV.ORACLEPASSWORD