DataFlux Data Management Studio 2.5: User Guide

Data Source Node

You can use a Data Source node to specify an input table in a data job. The properties dialog for this node includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the data source.

Input table - Opens the Select Table dialog when you click Browse. The Select Table dialog lists the data sources identified on your computer.

Sort - Displays the Sort dialog. You can use the dialog to re-order the fields in the Output fields list. Items displayed in this list are determined by your input table. To select a field, click the field name in the Available fields list and click Add to move the field to the Sort fields list. To move all fields, click Add All.

The Output fields section of the properties dialog contains the following elements:

Available - Contains the fields you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.

Selected - Contains the fields that will be made available to the next node in your data job.

Export - Enables the import functionality available in the External Data Provider step. You can store the file format of a data source in a .dfl file to be used later to restore the same file format. The .dfl file has the same structure and type as the .dfl file that is provided when you export file layouts with fixed width text file and delimited text file data inputs. The .dfl file can restore the file format in the EDP step as easily as importing the file itself.

Override - Enables you to override the default field lengths. The Reset button enables you to return to the default settings.

You can access the following advanced properties by right-clicking the Data Source node:

• CATALOG_NAME
• DSN
• FIELDS
• MAX_OUTPUT_ROWS
• SCHEMA_NAME
• SORT_FIELDS
• TABLE_NAME