The following procedure describes how to create and configure synchronization projects for database-level projects in Microsoft SQL.
Open the Synchronization Editor.
The schema loading window is displayed.
Follow on-screen instructions until the Provisioning Capability window is displayed.
The synchronization project is created successfully.
After the creation of the synchronization project, set the variables value in the DefaultUserPassword field.
Database Systems Integration (DSI) provides an additional template for the Microsoft SQL database that allows it to connect to multiple databases through a single synchronization project in Microsoft SQL at database-level.
The ability to connect to multiple databases through a single synchronization project simplifies the process of maintaining multiple database connections, as the databases share a single set of configurations including mappings, workflows, and data operations.
To create connections to multiple databases through a single synchronization project
In the Synchronization Editor, open the synchronization project for MS SQL database-level connection.
Follow the steps specified in the Synchronization project for database level section to add base objects.
A new startup configuration gets created for the base object connection.
The Microsoft SQL template is classified into a server-level template and a database-level template. The mapping sets and the corresponding object types are different for server-level and database-level templates.
The Microsoft SQL server-level template has the following mapping sets:
NOTE: Before updating the default mapping sets, you should save the backup of the One Identity Manager database.
The following table describes here briefs about the mapping of server object types in MS SQL Server to the corresponding UNS tables of One Identity Manager.
MS SQL server-level object types
|Mapping set name||MS SQL objects||One Identity Manager table|