ClickHouse

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

​​

Provide the following information to create a ClickHouse Data Connector:

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

• Description: Provide 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. (TCP port)

• Database Name: Name of the database where you wish to store data.

• Http Port: (For Datastore purpose)

• SSL Type: Select SSL or Non SSL as choices.

• Upload Key: Select a upload key using the drop-down menu (This field appears only if the SSL option has been selected for the SSL Type field.

• Click the Save option.

• A success message appears confirming the connection.

​​

• Another success message appears confirming the creation of the Data Connector.

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

Please Note:

• The user can use the Environment Variables instead of the actual Username and Password to create the ClickHouse Data Connectors.

• The user needs to pass two Port numbers as listed below:

  • TCP Port Number

  • Http Port Number