search

open-metadata / OpenMetadata

OpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
https://open-metadata.org
Apache License 2.0
5.5k stars 1.04k forks source link

DB2 Service can't load plugin #14390

Open elguero6 opened 10 months ago

elguero6 commented 10 months ago

Affected module Db2 Service Connection

Describe the bug Cannot create a DB2 Connection

To Reproduce

1.) Create a Db2 Service 2.) Enter all information and Test Connection

Expected behavior Airflow logs show : Can't load plugin: sqlalchemy.dialects:db2.ibm_db

Version:

Additional context

image
harshach commented 10 months ago

@ulixius9 can we update the docs for this. Also it would be good with-in the connector check if the lib available if not throw a meaningful exception to install it

elguero6 commented 10 months ago

This helped create a successful db2 connection, 1.) Exec into the airflow pod Run: pip install ibm-db-sa 2.) Setup the DB2 connector on the openmetadata UI settings, make sure to add these properties if SSL is enabled : SECURITY=SSL SslServerCertificate=/path/ca-certificate.crt