Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
maxLevel2
minLevel2
typeflat


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

...

The following identity functions are supported:

Function (task feature)

Supported

create/delete identities

provisioning identities 

update identities          

provisioning identity updates   

deprovision identities  

cleanup of inactive identities active

-

check password changed active

...

The following resource functions are supported:

Function (task feature)

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   

-

...

The following cleanup functions are supported:

Function (task feature)

Supported

Is available in the expected/actual comparison log          

-

Clean up expected/actualIn the should-actual Log available    

-

Should be - Actually is - cleanup

-

Read back user account properties

-

Resource identity assignments Target system cleanup  member target system clean up

-

Resource - resource assignments Target system cleanup member target system clean up

-

How-to articles

Filter by label (Content by label)
cqllabel in ( "systemkonnektor" , "how-to" ) and type = "page" and space = "IKB"

...