HKN MZ

Sep 19, 2022

4 min read

Sql Server to Clickhouse with ODBC driver

Hi everyone; With this article, I try to explain How we can get data from Sql Server to Clickhouse using ODBC driver.

Sql Server version is Microsoft SQL Server 2019 — Enterprise Edition .Clickhouse version is 22.8.1.1440 .ODBC driver is 18 .Operating system is Ubuntu 20.04

On the Sql Server, let’s create TestDB database, create kisi table and insert two data.

--

--

More from HKN MZ

I am writing about Sql Server, Elasticsearch and Python. İ am an Database Administrator on SQL Server and Elasticsearch more than 5+ years.

AboutHelpTermsPrivacy

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
HKN MZ

HKN MZ

695 Followers

I am writing about Sql Server, Elasticsearch and Python. İ am an Database Administrator on SQL Server and Elasticsearch more than 5+ years.

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech