Skip to main content

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.

About the organization
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 collection

GuidesDirect link to Guides

Connector repositories

Browse the NIM connector variants for Microsoft SQL Server 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.

Connector table capabilities
TableReadCreateUpdateDelete
<Table/Query>