Data Import

To create an import source, please complete the steps below:

Field	Description
Name	Displayed import source name.
Import set table name	Displayed import set table name.
Type	Type of external data source. Available choice options: File; JDBC; LDAP; Text.
File retrieval method	Choose the method of the file adding to the import source (if the relevant Type was chosen earlier). Available choice options: Attachment; HTTPS; FTP(S): SFTP; SCP.
Format	Choose the file format (if the relevant Type was chosen earlier). Available choice options: CSV; Excel; JSON; XML.

To create an import set, please complete the steps below:

To create a transform map, please complete the steps below:

Transform Maps field description

Field	Description
Name	Displayed transform map name.
Active	Select this checkbox to make the transform map available to use.
Source table	Select the table containing the import set data.
Target table	Select the table where you want imported data to be placed.
Silent load	Select this checkbox to ignore business rules, client-side scripts, and other additives while the transformation inserts or updates data in the target table.
Ignore mandatory fields	Select this checkbox to ignore mandatory fields on the target table.
Use script	Select this checkbox to display the Script field.

Page tree