Skip to main content

.Net Query

The .NET Query data import (collector) allows you to develop your own customized collector for the Data Warehouse purely based on .NET code, instead of creating custom SSIS packages that require previous SSIS knowledge. The .NET Query collector supports both delta and full imports. Delta imports allow you to import individual data object types without loading a full dataset. The .NET Query collector can also use the high-water mark function. This is configurable according to the functionality of your .NET assembly and your requirements. For example, it can be used as a timestamp.

In a provisioning context, the .NET Query collector works the same way as other template connectors. The connector can retrieve identity and access data and perform provisioning in the connected system.

The .NET Query collector is also part of the Omada Software Development Kit (SDK). The Omada SDK makes it possible for external parties to develop connectors and collectors to use with the Omada Identity. The guide includes a detailed run-through of the functionality and the development of a .NET Query collector. For more information, find the Omada Identity - Connectivity SDK Guide on the Omada Help desk.

Minimum required permissions​

The minimum permissions depend on the type of .NET Query collector that you have developed or have access to. However, as an example, you will potentially require access to an account in the target system with the following permissions:

  • Read access
  • Creation of users
  • Assignment of users to groups
  • Assignment of roles to users

Supported objects and operations​

The .NET Query collector can populate all objects in the Omada Data Warehouse including identity and access data. The connector supports both identity and access rights data.

The Query collector uses the following data flow:

Query flow

Implementation notes​

None.

Network requirements​

To achieve connectivity, Omada Data Warehouse must be installed.

Prerequisites​

None.