| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
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.
...
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 |
...
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 | |
createCreate / delete identities | ✅ |
provisioning Provisioning identities | ✅ |
update Update identities | ✅ |
provisioning Provisioning identity updates | ✅ |
deprovision Deprovision identities | ✅ |
cleanup Cleanup of inactive identities activeactive | - |
check Check password changed active | ✅ |
Resources
...
features
The following resource functions are supported:
Supported | |
createCreate/delete resources | - |
provision Provision resources | - |
update Update resources | - |
provisioning Provisioning resource changes | - |
deprovisioning Deprovisioning resources | - |
provisioning Provisioning resource allocations | ✅ |
deprovisioning Deprovisioning resource allocations | ✅ |
provisioning 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 | - |
...