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. |