Define Data Source

Read(1051) Label: data source,

After data is prepared, you can use them as the data source to perform computations on the ETL file.

Import Data SourceA ETL file’s data source can be a database table, a text file, an Excel file or a bin file. Take the database table as an example. Open a new ETL file, click Edit -> Database Table or Database Table icon  on the toolbar to enter Database Table interface, as shown below:

Result Name: Define result set name.

Result Type: For specifying the result set type, which can be table sequence or cursor. There are different methods for computing different types of result sets.

Data Source: Select a data source, which is configured in Tool -> Data Source. All connected data sources are displayed in the drop-down list.

Table: A table to be selected from the Data Source.

Add quotes to table: You can choose whether to add quotes to the table name or not. When the table name contains special characters, collides with the keyword, is case-sensitive, has the cross-database compatibility problem, you need to enclose the table name in quotes to retrieve data correctly.

Type of Quotes: Select the type of quotes – double quotes, single quotes or MYSQL.

With configurations in the above figure, click OK button and a result set is generated as follows:

Under ETL, the source table structure lists the first five fields. Click the source table structure table and you can view all its data in the result set interface on the right.

Enter the Import configuration interface to import data from a text file/Excel file/bin file source through the Edit menu or icons  on the toolbar. The configurations are similar to those for the Special Open (Refer Prepare data - Diverse data sources).

Forward

On the result set interface on the right, click Forward icon  to open the next layer of data.

Backward

On the result set interface on the right, click Backward icon  to return to the previous layer of data.

Field Contents

On the result set interface on the right, click Preview icon  to preview the detailed contents corresponding to the currently selected data.

Copy Data

On the result set interface on the right, select a field value and click Copy icon  to copy the current row of data to the clipboard. If no values are selected, copy this icon and all data will be copied to the clipboard.

Copy Column Names

On the result set interface on the right, click Copy Column Names icon  to copy all column names to the clipboard.

Browse Graphs

On the result set interface on the right, click Browse Graphs icon  to display data in the current page as a graph. For example:

The available types of graphics are column, pie and line. You can define the category field, series field and value field as needed, and make personalized configurations for the graph properties, as shown below:

Click Copy button and you can copy the graph to clipboard; or click Save as button to save the graph as a svg file.

Zoom

  On the result set interface on the right, right-click to select Zoom to display the current result set interface at a particular scale.

Format Column

To set a currency format for SALARY column, for example, right-click SALARY column on the result set interface and select Format Column:

 

Click OK and get the following result: