OracleBI Clickhouse connection with odbc driver string datatype problem

[ufukaslan86]

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.

[traceon]

Could you please enable driver tracing and post traces separately for the scenario with Sample Analyses with string and numeric data type columns and with dbeaver.

[ufukaslan86]

odbctrace10.zip

this is obi's trace file. dbeaver uses jdbc connection and has no error.

[ufukaslan86]

do you still want me to attach dbeaver 's trace file.

[Enmk]

Hi @ufukaslan86 ! Were you able to resolve the issue?

[ufukaslan86]

nope. issue is continue. we found a workaround with using fixedstring datatype. but this is not our answer.