Apache Airflow can not connect to mssql 2008

mandychen — Wed, 19 Jul 2023 09:00:24 GMT

Hi team,

I update airflow to v2.6.3, and find I can't connect to mssql 2008 by using JDBC.

Following are my setting：

Docker Desktop：v4.19.0
airflow：v2.6.3
JAVA：openjdk-11-jdk
JDBC Driver：jtds-1.3.1.jar
Connection URL：jdbc:jtds:sqlserver://xxx.xxx.xx.xx:1433/xxxx
Driver Path：/usr/local/airflow/jars/jtds-1.3.1.jar
Driver Class：net.sourceforge.jtds.jdbc.Driver

The connection was failed.

I wonder why the message show the connection string as below：

jdbc://jdbc:jtds:sqlserver:

why not only

jdbc:jtds:sqlserver:

Any help will be appreciated, thanks!

Re: Apache Airflow can not connect to mssql 2008

smdas — Mon, 06 May 2024 13:02:35 GMT

Hello @mandychen

Thanks for using Cloudera Community. This is an Old Post, yet Wish to convey that Cloudera shall assist with Airflow Issues (Install, Upgrade, Maintenance) dealing with Airflow shipped by Cloudera. Currently, CDE (Cloudera Data Engineering) allows Airflow to be deployed on Public Cloud & Private Cloud with End-To-End Support offered by Cloudera.

Your Post deals with reviewing an Issue with Installing Standalone Airflow, which isn't Supported per-se. Henceforth, our engagement would be Limited. However, the Issue is likely linked with JDBC Parsing as discussed in [1].

If your Team is interested in CDE Airflow, Let us know & we can get in touch with your Team.

- Smarak

[1] https://github.com/apache/airflow/issues/33442

question Re: Apache Airflow can not connect to mssql 2008 in Support Questions

Apache Airflow can not connect to mssql 2008

Re: Apache Airflow can not connect to mssql 2008