ClickHouse / ClickHouse/clickhouse-odbc
Driver not working with Azure data factory
- Dominant language
- C
- Stars
- 285
- Forks
- 105
- Avg merge
- 3h 56m
- Merged PRs (30d)
- 3
Description
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=;PORT=;USER=;PWD=;`
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.
Contributor guide
Assessment
This issue has not been assessed yet.