You can also create an integration directly from a workflow. See Creating a Workflow.
Choose one of the following options:
Option Action Create new Click CREATE NEW and select SFTP integration. Clone existing Select. Edit exiting Either click the data integration or select.
On the Integration details page, enter a unique Name, an optional Description, and select the direction for this data integration.
Direction Description Inbound Use to configure and import (ingest) data from an external system. Outbound Use to export (transfer) data to an external system.You can't change the Data direction after saving the data integration.
On the Connection page, select the Source and Destination connections.
These connections (Database and SFTP) must already exist. See Connections.It can take up to 10 minutes for newly created databases to become available.
Direction Source Destination Inbound Select an SFTP Connection. Select a database Connection, Database, and Table. Outbound Select a database Connection, Database, and Table. Select an SFTP Connection.
On the Choose and map attributes page, select the fields to use in the data integration.
By default, the system preselects all the fields.
Direction Description Inbound
- Select the fields to use from the the Source sample format, defined as part of the connection. See Creating or Editing an SFTP Connection.
- Map each selected source field to a Destination database field.
You must select and map at least one field.
- Select the fields to use from the Destination field.
You must select fields on this page that you intend to use as sort options in the next step.
- [Optional] Create an alias for each field.
The system uses the alias (if added) or the database column header as the column header in the generated file.
For an inbound data integration:
On the Input format page, enter the source File name.
If blank, Vantage Analyst will use all files in the SFTP location. Use ? and * as wildcards in the file name to represent single or multiple characters.
- [Optional] Select Include header row if the first row of the source file contains header information.
Use the Field and String delimiter fields to define the structure of the source file.
The formatting selections must match the delimiter formatting in the source files.
- On the Input format page, enter the source File name.
For an outbound data integration:
- On the Sort output page, specify the output order of the attributes in the output document and their sort order.
In the Attributes palette, drag-and-drop the attributes to change the order in which they will appear in the output document.
Only fields you selected on the Choose and map attributes page are available.
[Optional] In the Records palette, click + to add a field to use to sort the output document.
You can add multiple fields and drag-and-drop the fields to change the sort order.If the sort Records are empty, the output document will be sorted in the order as read from the database source.
For an outbound data integration:
- On the Output format page, specify the File name and Extension of the output document.
- [Optional] Click ISO date or ISO timestamp to add a date or timestamp, respectively, to the file name.
[Optional] To specify a maximum file size for the output file, select the Maximum file size option and enter the size (in MB or GB).
If the data transfer exceed this size, the system will generate additional files. These additional files will have a three-digit sequential number (such as 001 or 002) appended to the file name. The system will add additional digits, if needed.
- [Optional] Select Include header row if the first row of the output file should contain header information.
- Use the Field, String, Record, End of file, and End of output delimiter fields to define the structure of the output file.
- Click SAVE DATA INTEGRATION.