3 Replies Latest reply: Jul 31, 2013 3:12 AM by user9210815 RSS

    NTLM authentication in ODI topology

    user9210815

      Is it possible for the ODI agent running on Unix to connect a MS SQL 2008 server using windows authentication. I have added a property in the JDBC URL as jdbc:weblogic:sqlserver://10.2.2.163:1433;AuthenticationMethod=ntlm and the driver weblogic.jdbc.sqlserver.SQLServerDriver. When I test this topology using an ODI agent running on Unix and I get the below error : [SQLServer JDBC Driver]NTLM (type-2) Authentication was requested but the required DDJDBCAuth04.dll was not found on the path specified by the java.library.path system property.

       

      Any help on this will be highly appreciated. If you need any more information please revert.

       

      Thank you.

      Surya