Hello team,
We’ve to integrate Microsoft SQL server with identityNow. I’ve seen JDBC connector as well as SQL Loader connector. Which connector we should prefer. JDBC also supports SQL type
Hello,
I would advise you to use the Microsoft SQL Server if your database complies with the prerequisite (see for reference Microsoft SQL Server Source Configuration Reference Guide.
The SQLLoader connector is generally used to read and write to flat file using an hxtt driver.
With the Microsoft SQL connector you will be able to use procedure and other database specifics features that the SQLLoader does not allow.
Have a good day
@OlivierJacques thanks