Microsoft SQL Server
Database integration
Read Microsoft SQL Server records into NIM as a source system, or use them to supplement data collected from other systems.
- Organization name:
- Microsoft
- Organization type:
- Technology company
- Areas of focus:
- Business productivity, cloud computing, enterprise applications, infrastructure, and security.
- Product website:
- Microsoft SQL Server
- Organization website:
- Microsoft
Use SQL Server as an identity data sourceDirect link to Use SQL Server as an identity data source
Collect a table, view, or configured query containing the person identifiers and attributes your identity process needs. Use a stable key to relate those records to existing accounts, then select the approved population in a filter before running target-system mappings.
For a learner-provisioning example, follow Use SQL Server records to provision Litmos users. That pattern uses database reads and the Litmos connector's user-create and user-update operations. Validate database collection and the Litmos target changes separately.
Solutions This Integration SolvesDirect link to Solutions This Integration Solves
Source or supplemental data
Read SQL Server tables or query results into NIM as a source system, or combine them with other collected data to supply additional fields.
Configure SQL Server data collectionGuidesDirect link to Guides
Connector repositories
Browse the NIM connector variants for Microsoft SQL Server on GitHub:
- Microsoft SQL (PowerShell) connector repository on GitHub
- Microsoft SQL Queries (PowerShell) connector repository on GitHub
Supported operationsDirect link to Supported operations
Find supported tables
Showing 1 of 1 tables✓ Supported · × Not supported. These indicators describe connector capabilities; they do not run operations.
Scroll horizontally to compare all operation columns.
| Table | Read | Create | Update | Delete |
|---|---|---|---|---|
| <Table/Query> |