Skip to content

Operations

SYNCATT

Function that allows you to retrieve the value of an attribute based on a sub-operation. It returns empty if the attribute is not found.

Keyword syntax:

<SYNCATT:[Attribute_Name]:[Source]:[Operation]>

  • Attribute_Name: name of the attribute whose value you want to retrieve.
  • Source: SRC or DST to define the repository to be used. The parameter is optional unless an operation is specified. If the parameter is not specified, the SRC value is applied by default.
  • Operation: ADD or DEL to define the desired action. The parameter is optional.

Use mode:

  • The keyword can only be used in import rules in the Modify operation of an SQL connector. Delta mode is only active on Modify operations.

Example of configuration:

  • Query using the keyword SYNCATT:
1
2
3
4
5
6
INSERT INTO WikiApp 
(Login, Password, Nom, 
Prenom, Matricule, Profil) 
VALUES 
('<SyncAttSrc:login>', '<SyncAttSrc:password>', '<SyncAttSrc:nom>', 
'<SyncAttSrc:prenom>','<SyncAttSrc:matricule>','<SyncAtt:wiki_profil:SRC:ADD>')

SYNCATTSRC

Function that allows you to retrieve the value of an attribute in a repository (source, destination, or delta).

Keyword syntax:

<SYNCATTSRC:[Attribute_Name]>

  • Attribute_Name: name of the attribute whose value you want to retrieve

Use mode:

  • The SYNCATTSRC keyword can be used in all “expression” type fields such as COPY, MODVALUE, etc.
  • If the SYNCATTSRC keyword is used in filter or conversion rules, then the attributes are searched for in the source specified in the rules.
  • If the SYNCATTSRC keyword is used in “Match” rules, then the attributes are searched for in the authoritative source export

SYNCATTDST

Function that allows you to retrieve the value of an attribute in the target source export.

Keyword syntax:

<SYNCATTDST:[Attribute_Name]>

  • Attribute_Name: name of the attribute whose value you want to retrieve.

Use mode:

  • The SYNCATTDST keyword can be used in all “expression” type fields such as COPY, MODVALUE, etc. operations.
  • The SYNCATTDST keyword can only be used in “Match” rules, in which case the attributes are searched for in the target source export.

SYNCATTSRCOPERATION

Function that allows you to retrieve the operation type in the DELTA file. The possible values are as follows: CREATE, DELETE and MODIFY.

Keyword syntax:

<SYNCATTSRCOPERATION>

Use mode:

  • The SYNCATTSRCOPERATION keyword can be used in all “expression” type fields such as COPY, MODVALUE, etc. operations.
  • The SYNCATTSRCOPERATION keyword can only be used in filter or conversion rules on the DELTA source.

SYNCSRCMATCHRNB

Function that returns the number of the matching rule that enabled two objects to be paired.

Keyword syntax:

<SYNCSRCMATCHRNB>

Use mode:

  • The SYNCSRCMATCHRNB keyword can be used in all “expression” type fields such as COPY, MODVALUE, etc. operations.
  • The SYNCATTSRCOPERATION keyword can only be used in “Match” rules.