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

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

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

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

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

Identity features

The following identity functions are supported:

System Connector task features

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:

System Connector task features

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:

System Connector task features

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.