I am trying to import a Clickhouse schema in Talend Open Studio ETL software. The steps that I have followed are:
I created a connection in Talend Open Studio with ClickHouse using the credentials shown below in screenshot 1. ScreenShot of Connection
In the mapping file option, There is no default file for Clickhouse. That's why I have tried both the Java or Mysql database mapping file and I can create a successful connection with both.
While importing schema, the menu shows me the "default" catalog. When I expand it, it lists all the schemas in it. When I select a schema to import, It keeps on retrieving the "Next" button remains disabled as shown in the image below 2. ScreenShot of Retrieving Schema
- I have also tried by creating a custom mapping file for Clickhouse and importing it in Talend. The content for that file is: