DataExchangeSqlQueryConfiguration Properties

Entity data version for static cache synchonization

Date of last change of the configuration

ID of User who created the configuration

Date when configuration was created initially

Provides the DataObjectType of the objects being imported/exported

Entity data version for static cache synchonization

Inbound or outbound

When set to true users are always imported. When set to false the user is only imported when being a member of one of the provided UserGroups (used as a filter). Attribute is only used when importing Users.

Used for command line usage, where the caller wants the dataexchange to exit with an error on errors in the message log.

Contains a collection of fields (fixed fields and properties) which should be transferred to/from the target system. The field is found on the DataObjectType provided in DataObjectTypeId.

ID of the configuration

ImportMode is only used if Direction=In.

The field (property) which is used to identify the DataObject to determine of it an update or an insert (like a primary key). Is only used when Direction=In.

Determines whether objects are deleted when they are not found in the data source. Only used when Direction=In

Determines the behaviour of an import into a Reference property if the existing values are not found in the data source. The existing values are either deleted (full sync) or the values in the data source are added to the DataObject Only used when Direction=In.

The name of the DataExchange configuration

Number of the configuration taken from a sequence

Determines whether the MissingObjectAction can be performed on all object or only those object which are created the this configuration

In test mode, the data exchange is run normally, but data is not committed to the database.

If defined, the DataExchange is executed on this timer.

Type of source/target system

UID of the configuration

The attribute is used to synchonize UserGroup memberships. It can be used as a filter so only users which are member of one of the provided groups are imported (DisregardGroupMembership=false) or only to synchronize groupmemberships (DisregardGroupMembership=true). The users will also be removed from the provided UserGroups if the data source does not indicate a membership (full synchronization) Only used when Direction=In and UserImport=true.

Determines whether its a User import. Only used when Direction=In