Managing custom database objects within the database
To create transport packages with the Database Transporter program and to create reports about the system configuration, information about database objects such as customized database tables and database columns, database procedures, features, triggers, indexes, or view definitions is stored in the database. The DBQueue Processor checks and updates this data.
NOTE: It is not usually necessary to edit the data manually although you might edit the comment for use in reports.
To customize database objects
-
In the Designer, select the Base Data > Advanced > Modified SQL category.
-
Select the database object.
-
Modify Remarks.
Table 179: Database object properties
Processing status |
The processing status is used for creating custom configuration packages. |
Remarks |
Additional comments, for example, for using in system configuration reports. |
Name |
Database object name. |
Modified |
Specifies whether the database object has been changed. |
Sort order |
Order in which the data is presented. |
Type |
Type of database object, for example, procedure, function, trigger, index, view, custom table, custom column. |
For more information about creating transport packages, see the One Identity Manager Operational Guide.
Web service integration
One Identity Manager offers you the option to integrate web services. For example, you can use web services to write data to applications, which cannot be connection to One Identity Manager as a default target system.
Data for external applications can be originate from any of the One Identity Manager schema's tables. They can, for example, be mapped as custom target systems.
Example:
You want to find the main data for a telephone system from identity main data in One Identity Manager. The telephone system is mapped in One Identity Manager as a custom target system. One extension in the telephone corresponds a user account in One Identity Manager.
Once a new employee has been added in One Identity Manager, a new extension should become available in the telephone system. A new user account is added for each account definition. A web service passes the user account's main data onto the telephone system, where a new participant and telephone number is added. The web service passes this telephone number to One Identity Manager as the return value. The telephone number should be transferred to the identity's main data.
Proceed as follows
-
Set up a custom target system in One Identity Manager.
-
Set up the server for provisioning the data.
-
Set up an account definition for automatic administration of user accounts in this target system.
-
Enter the required IT operating data.
-
Bind the web service to One Identity Manager. Use the generic web service call for this.
The web service integration wizard helps you to create scripts for provisioning data for the Insert, Update, and Delete default events. The provisioning processes are supplied by default through One Identity Manager.
-
Create additional scripts and processes for handling the web service return value.
TIP: When you insert, change, or delete containers, user accounts, and groups in a custom target system, the return values are saved by default as GUID objects in the database.
Create a process to add the telephone number from the object GUID to the identity's main data.
For more information about setting up a custom target system, about account definitions, IT operating data and setting up a server, see the One Identity Manager Administration Guide for Connecting to Custom Target Systems.
Detailed information about this topic
Binding a web service
Create a custom script for integrating a web service into One Identity Manager. There is a wizard available to assist you. The Web Service Integration Wizard finds all the methods used by the web service and creates scripts to call the required methods. The data from One Identity Manager is passed as parameters to the method. Which operations in the external application can be run, is determined by the methods defined in the web service. The wizard created new entries in the DialogWebService and DialogScript tables.
The Web Service Integration Wizard supports different types of method calls. Each type supports the method call definition and, therefore, script creation to different degrees.
Generic web service call
You use the generic web service call to publish data from a custom target system to an external application through a web service. The Web Service Integration Wizard queries all the required parameters and generates scrips from them.
Prerequisites
The external application data is mapped in One Identity Manager as a custom target system.
-
A custom target system is set up (UNSRootB table). The Synchronized by property has the value Scripted synchronization.
-
A server for provisioning data is set up and stored as synchronization server in the custom target system.
For more information about setting up scripted provisioning, see the One Identity Manager Target System Base Module Administration Guide.
Default processes
One Identity Manager supplies default processes for provisioning data from custom target system to a web service.
To use these processes, the scripts you generated with the Web Service Integration Wizard must follow the naming convention:
<Customer prefix>_<table>_<Ident_UNSRoot>_<event>.
IMPORTANT: If your target system contains a hyphen (-) in its name, you must remove it from the script function in the <Ident_UNSRoot> part. Otherwise, error may occur during script processing.
Some of these processes handle the web service return values.
Table 180: Default processes for synchronizing by script
Container (UNSContainerB) |
VI_UnsContainer_Generic |
UNSContainerB.ObjectGUID |
User accounts (UNSAccountB) |
VI_UnsAccountB_Generic |
UNSAccountB.ObjectGUID |
|
VI_UnsAccountInGroup_Generic_Del |
- |
|
VI_UnsAccountInGroup_Generic_Add |
- |
Groups (UNSGroupB) |
VI_UnsGroup_Generic |
UNSGroupB.ObjectGUID |
|
VI_UNSGroupBInUNSGroupB_Generic_Del |
- |
|
VI_UnsGroupBInUNSGroupB_Generic_Add |
- |
Permissions controls (UNSItemB) |
VI_UnsItem_Generic |
- |
|
VI_UnsGroupHasItem_Generic_Del |
- |
|
VI_UnsGroupHasItem_Generic_Add |
- |
|
VI_UnsAccountHasItem_Generic_Del |
- |
|
VI_UnsAccountHasItem_Generic_Add |
- |