Scripted SQL Connector for Microsoft SQL Server

This topic has 1 reply, 2 voices, and was last updated 4 years, 6 months ago by gael.

  • Author
    Posts
  • #20597
     BHASKARK
    Participant

    I would like to know the integration steps of OpenIDM and Scripted SQL with Microsoft SQL Server. We see the sample for mysql – samples/scripted-sql-with-mysql. Is it just leveraging the mysql sample to connect with Microsoft SQL Server by updating the provisioner.json file and relevant groovy scripts or is there other approach to connect with Microsoft SQL Server. Please suggest.

    #20606
     gael
    Participant

    The key point is to get the Microsoft Java JDBC driver for SQL server, copy it in lib/ folder, and properly configure it in your provisioner file.
    => driverClassName
    => url
    => validationQuery

    That done and the TEST action working ok, you may have some MS SQL specific things vs MySQL to review in the scripts but technically speaking, this is it.

    scriptedSQL connector uses Tomcat JDBC connection pool on top of the JDBC driver.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

©2022 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?