A complete solution for open data platforms, enterprise data catalogs, data lakes and data management. Open source, mature, fully-featured and production ready.

DataHub

Does anyone using the mssql ingestor support integrated auth. vs. uid and pwd?  Our database environment here only allows integrated auth,

Hello Eric!
What kind of integrated auth are you using?

Is it something that can be encoded in a SQLAlchemy url?

image.png

@Hi  <@U01L2QD243Z> I am going down the SQLAlchemey route with trusted connection.  I am getting a weird error?
source:
  platform: "mssql"
  type: "sqlalchemy"
  config:
    # Coordinates
    connect_uri: "<mssql://111.11.11.11:1111/loooo?trusted_connection=yes>"

sink:
  type: "datahub-rest"
  config:
    server: "<http://localhost:8080>"

Hi <@U01L2QD243Z>, I was able to get this to work by the below recipie. Just closing this and documenting for others:

source:
  type: mssql
  config:
    # Coordinates
    host_port: &lt;yours&gt;
    database: &lt;yours&gt;
  

    # Options
    use_odbc: "True"
    uri_args:
      driver: "ODBC Driver 17 for SQL Server"
      Encrypt: "yes"
      TrustServerCertificate: "Yes"
      ssl: "True"
      autocommit: "True"
sink:
  type: "datahub-rest"
  config:
    server: "<http://localhost:8080>"

<@U02S4QT2DJ6> can you please elaborate how you got it working with integrated auth please? I am stuck with a similar error. If I use the above recipe it says "No kerberos credential available"