# Microsoft sql server

**URL:** <https://developer.sailpoint.com/discuss/t/microsoft-sql-server/2427>\
**Category:** SHF Discussion and Questions\
**Created:** [December 16, 2021, 6:15am UTC](https://developer.sailpoint.com/discuss/t/microsoft-sql-server/2427 "2021-12-16T06:15:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![seemarani](https://avatars.discourse-cdn.com/v4/letter/s/ed655f/32.png) [@seemarani](https://developer.sailpoint.com/discuss/u/seemarani)\
**Post date:** [December 16, 2021, 6:15am UTC](https://developer.sailpoint.com/discuss/t/microsoft-sql-server/2427/1 "2021-12-16T06:15:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![OlivierJacques](https://avatars.discourse-cdn.com/v4/letter/o/85f322/32.png) [@OlivierJacques](https://developer.sailpoint.com/discuss/u/OlivierJacques)\
**Post date:** [December 16, 2021, 7:28am UTC](https://developer.sailpoint.com/discuss/t/microsoft-sql-server/2427/2 "2021-12-16T07:28:53Z")

</div>

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](https://community.sailpoint.com/t5/IdentityNow-Connectors/Microsoft-SQL-Server-Source-Configuration-Reference-Guide/ta-p/73778).  
The [SQLLoader connector](https://community.sailpoint.com/t5/IdentityNow-Connectors/SQL-Loader-Source-Configuration-Reference-Guide/ta-p/148994) 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

---

<div class="post-metadata">

**Author:** ![seemarani](https://avatars.discourse-cdn.com/v4/letter/s/ed655f/32.png) [@seemarani](https://developer.sailpoint.com/discuss/u/seemarani)\
**Post date:** [December 16, 2021, 10:51am UTC](https://developer.sailpoint.com/discuss/t/microsoft-sql-server/2427/3 "2021-12-16T10:51:56Z")

</div>

@OlivierJacques thanks

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [July 19, 2023, 2:22pm UTC](https://developer.sailpoint.com/discuss/t/microsoft-sql-server/2427/4 "2023-07-19T14:22:23Z")

</div>

Closed on July 19, 2023, 2:22pm UTC