Data integration flow is an ETL or automation scenario which can be executed manually, scheduled or triggered by calling an API endpoint.
Read about available flows.
Creating a flow
Step 1. To create a new flow, go to the Flows page and click the
+ button. Then click the corresponding flow type in the opened box.
To quickly find the correct type, you can enter all or a part of the name in the search box. After this, only the types which include that string in their names will be displayed. To filter flows by category, you can click the corresponding flow category from the list to the left of flow types.
Step 2. After a flow type has been selected, continue by defining the flow's transformations. To add a new transformation, click the
Transformations can be modified, deleted and rearranged using drag-and-drop.
Step 3. For each transformation you will need to define the mapping and parameters.
Start defining the mapping by clicking the
MAPPING button in the grid which contains the transformation.
Continue in the opened box by creating a per-field mapping, either automatically (by clicking the
Create Mapping button), or manually, by adding fields one-by-one using the
+ button. You can modify mappings at any time. You can also rearrange fields using drag-and-drop.
Step 4. After the flow has been created, you can save it by clicking the
All saved flows are displayed in a grid on the Flows page and can be quickly filtered by name and type. Flows can be modified, duplicated or deleted directly from the grid.
Exporting and Importing Flows
In Integrator, you can export any flow to the file saved locally, and later import it from that same file. When you export the flow, Integrator also exports all related connections and formats. Export/Import is especially useful when you wish to migrate flows from one instance of Integrator to another, or copy flows between different accounts.
Export a flow
Go to the Flows page and click the
Export Flow button. Then, select the flow by name in the opened box and click the
Export button. The file with the extension .intflow will be downloaded to your local drive.
Import a flow
go to the Flows page and click the
Import Flow button. Then, click the
Choose file button and select the file with the extension .intflow that you wish to import. A new copy of the flow and all corresponding connections and formats will be created in Integrator.