Mapping source data configuration

Overview

The source data can be selected from RDB, CSV and Execel.
* Before mapping configuration,, complete the connection configuration first.

Configuration

For RDB

No	Item	Description
1	Source Connection	Select the connection that was configured on the connection configuration form.
2	Type	If you select an RDB connection, you can choose the source type from table and query.
3	Table	If you select a table as the type, a list of RDB tables and views will be displayed, select the object in the list.
4	Filter	If there is a condition for data extraction, describe the WHERE condition. e.g.: WHERE UPDATE_TIME> = SYSDATE-1
5	View Data	Open a form that allows you to view existing data.

No	Item	Description
6	Query	Select the query if you need to write SQL to query data.
7	Query content	Write the SQL for data extraction. e.g.： SELECT EMPID , EMPNAME , DEPT_CODE FROM HR.EMP WHERE DEPT_CODE = '0003'

For CSV

No	Item	Description
8	CSV Filename	If the connection is selected as a CSV folder, the CSV file list will be displayed. Select the CSV file in the list.
9	Encoding	Enter the encoding of the CSV file.<br /e.g.：UTF-8、Shift_JIS
10	Use header columns	Whether the CSV file has a header row.
※		Delimiters, enclosing characters, etc. are automatically determined, so there is no need to specify them.

For Excel

No	Item	Description
11	Excel FileName	If the connection is selected as a Excel folder, the Excel file list will be displayed. Select the Excel file in the list.
12	Sheet	Select the sheet number to be imported. * The first sheet is 1.
13	Encoding	Enter the encoding of the Excel file.<br /e.g.：UTF-8、Shift_JIS
14	Use header columns	Whether the Excel file has a header row.

For JSON

No	Item	Description
15	JSON FileName	If the connection is selected as a JSON folder, the JSON file list will be displayed. Select the JSON file in the list.