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 163: 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.
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 originate from any of the One Identity Manager schema's tables.
The web service client assembles must be deployed as NuGet packages. Use the Software Loader to import the NuGet packages into the One Identity Manager database. The web service can then be used in scripts in the or the System Debugger.
If a web service provider has already provided NuGet packages, you can use these. Otherwise, create the web service client assemblies and NuGet packages in your development environment.
The following example explains how to create the NuGet packages using Visual Studio.
The following software and configuration are prerequisites:
-
.NET 8.0 SDK with the current service pack
-
Visual Studio with the current service pack or Visual Studio Code
-
Access to the internet to be able to download the necessary basic assemblies.
To create Visual Studio web service client assemblies
-
In Visual Studio, create a new project with the following settings:
-
Select the C# Class Library project type.
-
Enter a project name and set the project directory.
-
Select the .Net 8.0 framework as the target framework.
-
Visual Studio creates an empty project with an empty Class1.cs file. This file is not required and be deleted.
-
Establish the connection between the Visual Studio project and the web service. Select the newly created project in the Solution Editor and select the Project > Add service reference menu item.
This starts a wizard that will guide you through the rest of the setup. Follow the instructions in the wizard. Note the following:
-
Select the WCF Web Service service reference.
-
Enter the URL to the WSDL file or select the file directly.
-
Set the access level for generated classes to Public.
The next step generates the files for working with the web service automatically.
-
In the project properties, in the Package section, enable the Generate NuGet package on build option.
-
Compile the project as Debug and as Release.
After successful compilation, you will find the NuGet files in the following directories.
<project path>\<project name>\bin\Release\<project name>1.0.0.nupkg
<project path>\<project name>\bin\Debug\<project name>1.0.0.nupkg
