MSSQL Database
Introduction
This article describes the CoreOne system connector MSSQL Database, how the target system has to be configured in the CoreOne Suite and what requirements are there for the MSSQL source system.
Configurations parameter
The configuration parameters from the Target system.
The following configuration parameters are available in the MSSQL Database system connector:
Parameter | Mandatory field | Values | Description |
---|---|---|---|
ConnectionString | - | ||
CreateIdentity * | |||
GetResourcesFromIdentity * | |||
AddIdentityToResource * | |||
RemoveIdentityFromResource * | |||
GetIdentityMembersByResourceIdentifier * | |||
AddResourceToIdentity * | |||
RemoveResourceFromIdentity * | |||
GetIdentities * | |||
GetIdentityParameters * | |||
IsPropertyValueUnique * | |||
SetIdentityPassword * | |||
DeactivateIdentity * | |||
ActivateIdentity * | |||
IsIdentityActivate * | |||
ValidateCredentitals * | |||
CheckIdentityExists * | |||
DeleteIdentity * | |||
UpdateIdentity * | |||
CheckResourceExists * | |||
GetResources * | |||
MSSQL Import user name | - |
| Username used when running import with target system credentials |
MSSQL Import password | - |
| Password used when running import with target system credentials |
Source system MSSQL database requirements
The MSSQL source system has to provide this input and return values for the data provider to work. This can be done in stored procedures on the MSSQL system.
Identity methods
System connector method | Input parameters | Excepted return value | Description |
---|---|---|---|
CreateIdentity |
|
| Creates the user in the target system |
GetIdentityParameters |
|
| Returns all the user parameters of a user |
CheckIdentityExists |
|
| Returns if the user in the target system exists → return no row if the user doesn’t exist |
FindObjectIdentifiersByAttributes | Not implemented |
|
|
UpdateIdentity |
|
| Updates a user with the specified parameter values and returns the unique user object id |
DeleteIdentity |
| - | Deletes a user with specified user object id |
ValidateCredentials |
|
| Checks if the username and password are valid credentials and returns a row if valid or nothing if they’re invalid |
IsIdentityActivate |
|
| Checks if the identity is active in the target system and returns a row if it’s active or nothing if it’s not active |
ActivateIdentity |
| - | Activates an identity in the target system |
DeactivateIdentity |
| - | Deactivates an identity in the target system |
SetIdentityPassword |
| - | Sets the password to the identity in the target system |
IsPropertyValueUnique |
|
| Checks if a property value is unique in the target system. There are 3 cases that needs to be checked depending on the given user object id:
If “Is unique” is true, don’t return a row, otherwise return a row with a value, for example “1” |
GetIdentities |
|
| Gets all the identities. Search value can be used for filtering the identities but this is optional. Max results represents a number of how many results should be returned. Also optional. |
Resource methods
System connector method | Input parameters | Excepted return value | Description |
---|---|---|---|
CreateResource | Not implemented |
|
|
GetResourceParameters | Not implemented |
|
|
CheckResourceExists |
|
| Checks if the resource exists. Return nothing if it doesn’t. |
UpdateResource | Not implemented |
|
|
DeleteResource | Not implemented |
|
|
GetResources | Not implemented |
|
|
IsPropertyValueUnique | Not implemented |
|
|
GetResourceMembersByResource | Not implemented |
|
|
AddResourceToResource | Not implemented |
|
|
RemoveResourceFromResource | Not implemented |
|
|
FindObjectIdentifiersByAttributes | Not implemented |
|
|
Identity-resource membership methods
System connector method | Input parameters | Excepted return value | Description |
---|---|---|---|
AddIdentityToResource |
| - | Adds the user to the resource |
RemoveIdentityFromResource |
| - | Removes the user identity from the resource |
AddResourceToIdentity |
| - | Adds the resource to the user |
RemoveResourceFromIdentity |
| - | Removes the user from the resource |
GetResourcesFromIdentity |
|
| Adds the user identity to the resource |
GetIdentityMembersByResourceIdentifier |
|
| Gets all the user identities from the resource |
Identity features
The following identity functions are supported:
Supported | |
Create / delete identities | |
Provisioning identities | |
Update identities | |
Provisioning identity updates | |
Deprovision identities | |
Cleanup of inactive identities active | - |
Check password changed active |
Resources features
The following resource functions are supported:
Supported | |
Create/delete resources | - |
Provision resources | - |
Update resources | - |
Provisioning resource changes | - |
Deprovisioning resources | - |
Provisioning resource allocations | |
Deprovisioning resource allocations | |
Provisioning resources-resource allocations | - |
Deprovisioning resource resource allocations | - |
Cleanup features
The following cleanup functions are supported:
Supported | |
In the should-actual Log available | - |
Should be - Actually is - cleanup | - |
Read back account properties | - |
Resource identity member target system clean up | - |
Resource resource member target system clean up | - |
How-to articles
Related articles
© ITSENSE AG. Alle Rechte vorbehalten. ITSENSE und CoreOne sind eingetragene Marken der ITSENSE AG.