Data360 Analyze

 View Only

  • 1.  Integrated Authentication (or Security)

    Employee
    Posted 11-11-2020 13:49

    Good afternoon,

    I thought I would share a solution that Support helped with using a JDBC Query node along with integrated authentication. After upgrading to v3.6.5 the node stopped working.

    Placing the "sqljdbc42.jar" file from Microsoft (which can be found here: https://www.microsoft.com/en-us/download/details.aspx?id=11774 and is also attached) anywhere on the computer/server it then updating the DbDriverClasspath in the node properties (see attached) solved the problem.

    I hope you find this helpful if you have encountered the same issue. 

    Thanks,
    Josh

     

    Attached files

    DbDriverClasspath.png
    sqljdbc42.jar

     



  • 2.  RE: Integrated Authentication (or Security)

    Employee
    Posted 11-11-2020 14:58

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    There's also an article that goes over the steps for this, located here: https://support.infogix.com/hc/en-us/articles/360057136274