https://communities.sas.com/t5/SAS-Viya/Connectivity-Between-SAS-Viya-and-ClickHouse/m-p/968805#M2880 <P>Hello everyone, I’m currently using SAS Viya and able to successfully connect to Hive using the following libname statement:</P><P><EM>libname var hadoop user='user' pwd='{SAS002}xxxxxxxxxxxxxxxxxx' server='10.10.10.10' port=10000 schema=schema_name;</EM></P><P>&nbsp;</P><P>I would like to know if it’s possible to establish a similar connection between SAS Viya and ClickHouse.</P><P>&nbsp;</P><P>Any guidance or shared experience would be appreciated!</P> Thu, 12 Jun 2025 07:18:48 GMT yf_nf 2025-06-12T07:18:48Z https://communities.sas.com/t5/SAS-Viya/Connectivity-Between-SAS-Viya-and-ClickHouse/m-p/968805#M2880 <P>Hello everyone, I’m currently using SAS Viya and able to successfully connect to Hive using the following libname statement:</P><P><EM>libname var hadoop user='user' pwd='{SAS002}xxxxxxxxxxxxxxxxxx' server='10.10.10.10' port=10000 schema=schema_name;</EM></P><P>&nbsp;</P><P>I would like to know if it’s possible to establish a similar connection between SAS Viya and ClickHouse.</P><P>&nbsp;</P><P>Any guidance or shared experience would be appreciated!</P> Thu, 12 Jun 2025 07:18:48 GMT https://communities.sas.com/t5/SAS-Viya/Connectivity-Between-SAS-Viya-and-ClickHouse/m-p/968805#M2880 yf_nf 2025-06-12T07:18:48Z https://communities.sas.com/t5/SAS-Viya/Connectivity-Between-SAS-Viya-and-ClickHouse/m-p/968807#M2881 <P>Given the information on their web page, ODBC seems like the option to use for you:</P> <P><A href="https://clickhouse.com/docs/interfaces/overview" target="_blank">Drivers and Interfaces | ClickHouse Docs</A></P> Thu, 12 Jun 2025 08:06:42 GMT https://communities.sas.com/t5/SAS-Viya/Connectivity-Between-SAS-Viya-and-ClickHouse/m-p/968807#M2881 LinusH 2025-06-12T08:06:42Z