I need to connect to an MSSQL database as an HR data source, but I’m currently confused about which connector to use: Microsoft SQL Server Connector or JDBC Connector.
Does anyone have experience with the Microsoft SQL Server Connector? Is it working well?
A view will be created by the team, and we will pull the data from there.
@baoussounda -
You should use generic JDBC Connector rather than using Microsoft SQL Server Connector.
Microsoft SQL Server Connector should be used when you want to manage the database user management rather than database application tables.
Key Difference
Microsoft SQL Server Connector:
Primarily designed for managing SQL Server accounts (i.e., provisioning/deprovisioning login accounts, resetting passwords at the database level, assigning roles/permissions).
If your use case involves controlling SQL Server user management (the “logins” you see under Security > Logins in SQL Server Management Studio), then this connector is the right choice.
Generic JDBC Connector:
Designed for a more general or flexible approach to accessing database content, typically tables or views for authoritative data feeds, application data, or custom schemas.
If your use case is simply reading from (or writing to) application tables/views—for example, importing employee data from an HR system running on MSSQL—then this is the recommended approach.
@officialamitguptaa thanks for your response.
Can you please give me the reference of description about this two connectors ? is that exist into any Sailpoint documentation ?