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 *	✔

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	User parameters Password as string (optional)	Unique user object id Password (if generated)	Creates the user in the target system
GetIdentityParameters	Unique user object id	All parameters from this user object	Returns all the user parameters of a user
CheckIdentityExists	Unique user object id	Single row with single column or nothing	Returns if the user in the target system exists → return no row if the user doesn’t exist
FindObjectIdentifiersByAttributes	Not implemented
UpdateIdentity	Unique user object id Parameter update values	Unique user object id	Updates a user with the specified parameter values and returns the unique user object id
DeleteIdentity	Unique user object id	-	Deletes a user with specified user object id
ValidateCredentials	Username Password as string	Single row with single column or nothing	Checks if the username and password are valid credentials and returns a row if valid or nothing if they’re invalid
IsIdentityActivate	Unique user object id	Single row with single column or nothing	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	Unique user object id	-	Activates an identity in the target system
DeactivateIdentity	Unique user object id	-	Deactivates an identity in the target system
SetIdentityPassword	Unique user object id Password as string	-	Sets the password to the identity in the target system
IsPropertyValueUnique	Unique user object id Property name to check Property value to check	Single row with single column or nothing	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: Property value is present on the target system: If property value is on the user with the given user object id → Is unique = true If the property value is on another user → Is unique = false Propery value is not present on the target system → Is unique = true If “Is unique” is true, don’t return a row, otherwise return a row with a value, for example “1”
GetIdentities	Search value (optional) Max results (optional)	Rows with the identities with the following column names: Identifier: Unique user object id DisplayName: Display name of the user	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	Unique resource identifier	Single row with single column or nothing	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	Unique user object id Unique resource object id	-	Adds the user to the resource
RemoveIdentityFromResource	Unique user object id Unique resource object id	-	Removes the user identity from the resource
AddResourceToIdentity	Unique user object id Unique resource object id	-	Adds the resource to the user
RemoveResourceFromIdentity	Unique user object id Unique resource object id	-	Removes the user from the resource
GetResourcesFromIdentity	Unique user object id	List of resource identifiers	Adds the user identity to the resource
GetIdentityMembersByResourceIdentifier	Unique resource object id	List of user identity identifiers	Gets all the user identities from the resource

How-to articles

Page:
CoreOne Active Directory Connector (CoreOne Suite Dokumentation)
Page:
OpenLDAP (CoreOne Suite Dokumentation)
Page:
API-V2 C#_SDK Delete objects (CoreOne Suite Dokumentation)
Page:
API-V2 REST Error Handling (CoreOne Suite Dokumentation)
Page:
API-V2 C#_SDK Create objects (CoreOne Suite Dokumentation)
Page:
API-V2 C#_SDK Read additional information (CoreOne Suite Dokumentation)
Page:
API-V2 C#_SDK Update objects (CoreOne Suite Dokumentation)
Page:
API-V2 REST Read additional information (CoreOne Suite Dokumentation)
Page:
API-V2 C#_SDK Configuration (CoreOne Suite Dokumentation)
Page:
API-V2 REST Create objects (CoreOne Suite Dokumentation)
Page:
API-V2 C#_SDK Read objects (CoreOne Suite Dokumentation)
Page:
API-V2 REST Update objects (CoreOne Suite Dokumentation)
Page:
API-V2 REST Read objects (CoreOne Suite Dokumentation)
Page:
API-V2 REST Delete Objects (CoreOne Suite Dokumentation)