You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Key concepts

ConceptDescription
Import source
Import set
Import set table
Transformation
Transform Map
Field Map

Import Sources

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

  1. Navigate to the Import -> Import Sources;
  2. Click New, fill in the form and click Save.
FieldDescription
NameDisplayed import source name.
Import set table nameDisplayed 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.

Import Sets

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


Transform Maps

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

  1. Navigate to the Import → Transform Maps;
  2. Click New, fill in the form and click Save.

Transform Maps field description

FieldDescription
NameDisplayed transform map name.
ActiveSelect this checkbox to make the transform map available to use.
Source tableSelect the table containing the import set data.
Target tableSelect the table where you want imported data to be placed.
Silent loadSelect 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 fieldsSelect this checkbox to ignore mandatory fields on the target table.
Use scriptSelect this checkbox to display the Script field.


Field Sets


  • No labels