OracleBI Clickhouse connection with odbc driver string datatype problem

hi,

we want to connect oracle bi 12c 2.1.4.0 version to clickhouse using odbc driver. We did configurations and connected to clickhouse default db with oracle bi. we fetch data types of numbers and dates but we can't fetch string data types.

clickhouse-odbc-1.1.10-Linux.tar.gz
libclickhouseodbc.so

odbc.ini file info
--------------------------------
[ClickHouse]
Driver=/u01/middleware/bi/modules/oracle.bi.datadirect.odbc/7.1.6/lib/libclickhouseodbc.so
# Optional settings:
Description = ClickHouse
server = 10.0.157.81
database = default
#uid = default
port = 8123
#sslmode = require
Timeout=300000
--------------------------

odbcinst.ini file info
--------------------------------------
[ClickHouse]
Driver=/u01/middleware/bi/modules/oracle.bi.datadirect.odbc/7.1.6/lib/libclickhouseodbc.so
Setup=/u01/middleware/bi/modules/oracle.bi.datadirect.odbc/7.1.6/lib/libclickhouseodbc.so
----------------------------------------

Sample Analyses with date and numeric data type columns

Sample Analyses with string and numeric data type columns, looks no value it doesn't gives any error.

With dbeaver screenshot.

Start with the odbc.ini and odbcinst.ini configuration and the ClickHouse ODBC driver version shown in the report. Reproduce the difference between Oracle BI and DBeaver for string columns, then trace how the driver exposes string data to Oracle BI. Done means string values are returned correctly in Oracle BI without breaking the working numeric and date columns.

Written by the indexing model from the issue text.