Transport data between Source and Target.

Connectors to ERP/CRM and Databases.

“Source” defines the data set used as input for the selected action on the “Target”.
  • SharePoint List or Library Items.
  • Database result set (SQL Select.)
  • CSV/TAB delimited text file.
  • Third party CRM/ERP/XML etc.
“Target” is where the actions are performed, using the source data set as variables.
(Other Components can be called for each source row.)
  • Database.
    Insert, Update, Delete SQL statements uses the source data fields as bind-variables and is executed once per. row in the data set.
  • CSV/TAB delimited text file._
    The complete source data set Creates or replaces the “Target” file.
  • Third party CRM/ERP/XML etc.
Examples.
How to copy data from database to database
How to preserve the values in [Modified] & [Modified By] during update of List Items and Document metadata.

System Parameters
When the component starts, the system Parameter [<<SessionDateTimeNow>>] is updated.
If the job completes with no errors (or within the allowed threshold) the system Parameter
[<<SessionDateTimeLast>>] is updated to the value of and [<<SessionDateTimeNow>>], otherwise it is unchanged.

These 2 timestamps can be used as arguments for incremental jobs in SQL statements, SharePoint filters and file selection filters.
Please note that the the value of the 2 parameters is local to the Component in context. All Components that are executed has their own set of values except when referenced from within a Collection.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment