IBM Optim

IBM Optim

Enable Data Operations with Optim for AI and Cloud - accelerating innovation, reducing costs, ensuring data sovereignty


#Dataintegration
#Databases
#InfoSphereOptim
#Analyticstools
 View Only
Back to discussions
Expand all | Collapse all

How can i create a SQL Server data store alias with NTLM authentication?

  • 1.  How can i create a SQL Server data store alias with NTLM authentication?

    Posted 05/02/24 03:00 AM
    Edited by Anthony García 05/02/24 03:02 AM

    Hello everyone,

    I'm trying to create a SQL Server data store Alias in Optim Designer. Apparently, the database uses NTLM authentication.

    By default, Optim uses system DSNs, but since it's NTLM, I need to start the application with the user I'm going to connect to the database, which is not possible.

    I added a connection URL:

    jdbc:sqlserver://HOST:1433;databaseName=db;Encrypt=false;integratedSecurity=true;authenticationScheme=NTLM;user=optimuser;password=password;

    This URL works if I execute it directly with the JDBC libraries, but in Optim Designer, I get the error "The authenticationScheme NTLM is not valid."

    Has anyone made a similar connection?

    I would appreciate your help,

    Thank you



    ------------------------------
    Anthony García
    ------------------------------



  • 2.  RE: How can i create a SQL Server data store alias with NTLM authentication?

    Posted 05/02/24 07:50 PM

    Hello,

    I solved the error. If anyone else encounters the same issue, they should add the JDBC in the driver definitions within the preferences of Optim Designer. With that, the connection works.

    Right now, I'm facing another issue. When I finish configuring the data store alias, I get the following error: "Optim Configuration could not create the DB Alias. Please edit the DB Alias information and try again." Does anyone know how to resolve this?



    ------------------------------
    Anthony García
    ------------------------------



Related Content