DataExchangeSqlQueryConfiguration Fields |
The DataExchangeSqlQueryConfiguration type exposes the following members.
Fields| Name | Description | |
|---|---|---|
 | ConnectionString |
Connection string to database in which the query are to be executed.
|
 | m_changedBy |
ID user user whi performed the last change of the configuration
(Inherited from DataExchangeConfigurationBase.) |
| m_changeTime |
Date of last change of the configuration
(Inherited from DataExchangeConfigurationBase.) |
| m_createdBy |
ID of User who created the configuration
(Inherited from DataExchangeConfigurationBase.) |
| m_createTime |
Date when configuration
(Inherited from DataExchangeConfigurationBase.) |
| m_dataObjectTypeId |
Provides the DataObjectType of the objects being imported/exported
(Inherited from DataExchangeConfigurationBase.) |
| m_dataVersion |
Entity data version for static cache synchonization
(Inherited from DataExchangeConfigurationBase.) |
| m_disregardGroupMembership |
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.
(Inherited from DataExchangeConfigurationBase.) |
| m_id |
ID of the configuration
(Inherited from DataExchangeConfigurationBase.) |
| m_importMode |
ImportMode is only used if Direction=In.
(Inherited from DataExchangeConfigurationBase.) |
| m_keyField |
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.
(Inherited from DataExchangeConfigurationBase.) |
| m_missingObjectAction |
Determines whether objects are deleted when they are not found in the data source.
Only used when Direction=In
(Inherited from DataExchangeConfigurationBase.) |
| m_missingReferenceAction |
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.
(Inherited from DataExchangeConfigurationBase.) |
| m_name |
The name of the DataExchange configuration
(Inherited from DataExchangeConfigurationBase.) |
| m_number |
Number of the configuration taken from a sequence
(Inherited from DataExchangeConfigurationBase.) |
| m_performOnOriginObjects |
Determines whether the MissingObjectAction can be performed on all object or only those
object which are created the this configuration
(Inherited from DataExchangeConfigurationBase.) |
| m_testMode |
In test mode, the data exchange is run normally, but data is not
committed to the database.
(Inherited from DataExchangeConfigurationBase.) |
| m_timerId |
If defined, the DataExchange is executed on this timer.
(Inherited from DataExchangeConfigurationBase.) |
| m_type |
Type of source/target system
(Inherited from DataExchangeConfigurationBase.) |
| m_uid |
UID of the configuration
(Inherited from DataExchangeConfigurationBase.) |
| m_userGroupIds |
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.
(Inherited from DataExchangeConfigurationBase.) |
| m_userImport |
Determines whether its a User import.
Only used when Direction=In
(Inherited from DataExchangeConfigurationBase.) |
| Query |
Sql-query to be executed.
Must be a select-statement.
|
See Also