Data Transformation node

If you plan preparing integration between Synerise and external system or series of imports to Synerise, you can use the Automation module for these purposes.

Before importing data to Synerise, the data may need to be modified. For this purpose, you can use Data Transformation node which allows you to include a data tranformation diagram into a workflow.

You can select a transformation diagram which you have prepared before. After the selection, the system gives hints which columns are required for a given transformation.

Requirements

You must build a data transformation.

Node configuration

1. Click Data Transformation.
2. From the dropdown list, select the transformation diagram.
   Result: The pop-up window displays the column a file contains.

Example of use

You can prepare a single import of transactional data to Synerise.

1. Learn about the requirements for import of transactional data here.
2. Prepare a data transformation according to the requirements.
3. Create the new workflow and start it with the Scheduled Run node.
4. In the configuration of the node, set it to be scheduled immediately.
5. Add the Local File node. In the configuration of the node, upload the file with transactions.
   
   Note: If you store the file on a server, select HTTP or SFTP node and follow the instructions on the interface.
6. Add the Data Transformation node.
7. In the configuration of the node, select the transformation you prepared in step 2.
8. Add the Import transactions node. In the settings of the node, you can check the list of the required columns.
9. Add the End node.