Driver not working with Azure data factory

[Dom4LM]

I am trying to use Azure data factory to insert data into a Clickhouse database using the Windows ODBC driver. Each time I try this I receive the following error from data factory:

{
"errorCode":"2200", "message":"Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function,Source=CLICKHOUSEODBCW.DLL,'", "failureType":"UserError", "target":"Copy Data1" }

I have my Clickhouse server set up on a Vagrant virtual machine mapped to a particular IP address on the host machine local network. Host machine is running Windows 7. I can successfully query this database from the host machine using both the HTTP interface. I've also been able to use the ODBC driver to query the database on the host machine using the following connection string:

Driver={ClickHouse ANSI};DSN=ClickHouse;SERVER=<ip address>;PORT=<port>;USER=<user>;PWD=<password>;

I'm using the host machine as the integration runtime (i.e. the compute environment which data factory uses to populate the database using ODBC). I can successfully test the connection to the database using the integration runtime on the host machine:

But trying to run the data factory (which takes a CSV file and tries to insert into a particular Clickhouse table) gives the error described above.

[filimonov]

Please collect odbc driver log - like in that instruction https://docs.oracle.com/cd/E17952_01/connector-odbc-en/connector-odbc-configuration-trace-windows.html

Start recording, do the steps leading to failure, stop recording, attach resulting log.

[Sam--Shan]

hi,@Dom4LM. i tried azure data factory too. and i tried to copy data to clickhouse db. and i got this issue。

Operation on target cp_pg_ck failed: 故障发生在“Sink”端。 ErrorCode=UserErrorOdbcOperationFailed，'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Unknown SQL type 0.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcBulkCopyException,Message=Unknown SQL type 0.,Source=Microsoft.DataTransfer.ClientLibrary.OdbcBulkCopy,''Type=System.ArgumentException,Message=Unknown SQL type 0.,Source=,'

Did you got the error msg like 'Unknown SQL type' or did you fix your problem and copy data to ck successfully? With data factory odbc connection, i can copy data to local pg or sqlserver,but bad for ck.

Look forward to your reply,thanks a lot .

[Sam--Shan]

hi@filimonov ,i didnt get any trace log,but the error from integration runtime of azure data factory in windows event viewer. it looks like the Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector is not support ck-odbc.