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 organizationOrganization name: MicrosoftOrganization type: Technology companyAreas of focus: Business productivity, cloud computing, enterprise applications, infrastructure, and security.Product website: Microsoft SQL ServerOrganization 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.

  • Uses existing database records in NIM processes
  • Supplements source data for filters, reporting, and automation
Configure SQL Server data collection

GuidesDirect link to Guides

Configure ConnectionPrepare database access, configure the server and account, and test the connection.

Connector repositories

Browse the NIM connector variants for Microsoft SQL Server on GitHub:

Supported operationsDirect link to Supported operations

Filter tables by supported operation

Showing 1 of 1 tables
TableReadCreateUpdateDelete
<Table/Query>
Last updated on