Adding data sources
Add and define data sources and its variables to be used in rule procedures.
Within a rule procedure, users may need to read data from or write data to existing data sources other than the primary data source, or pass values as parameters. Or, they may need to create new data sources. For instance, within a reconciling rule procedure, users may wish to dynamically create a new data source file from the list of items that did not match. Or, they may wish to write the list of results that matched to a database already on the system.
To use a data source in a rule procedure, first define a data source variable that describes the type of data source (temporary file, ASCII file, XML file, database, and so on) and its format, including the names and order of fields in the data source.
|
Data Source Type |
Description |
|---|---|
|
ASCII |
Used to Read from or Write data to an ASCII file. |
| Database | Used to Read from or Write data to a Relational Database table. |
| Excel | Used to Read from or Write date to an Excel file. |
| Text Report | Used to create a Text Report. |
| Mobius View Data Miner | Used to create a Rule Procedure based on the data extracted from a Mobius View report using the Data Miner policy. |
| Mobius Report | Used to download a Report from Mobius View. |
| Mobius Archive | Used in Archiving data to Mobius. Processes data that is being archived to Mobius. The Mobius Archive data source works in conjunction with only the Archiving Procedure. |
| XML | Used to write data to an XML file. |
| Unstructured File | Used when data need to be stored without formal organization. For example, when the user intends to save a Mobius Report or the extracted results. |
| Temporary File | Used to store data temporarily within a rule procedure. The stored data can be used for interim operations, and at the end of the rule procedure execution, this Data Source is not available. |
Data Sources page layout
- Data Sources—This section lists the data sources that are used in the rule procedure. The data source is added when the data source is selected from the Add Data Sources section, enter the Data Source Details and Field Information, and click Save.
- Add Data Sources—Enter the Data Source Name and select the Data Source Type. The data source name is case sensitive. Supported characters are alphanumeric, dollar($), and underscore( _ ).
- Select the Enable Results Download check box to download the results.
- Data Source Details—This section allows users to enter the selected Data Source Type details.
- Field Information—Most A&AS Data Sources define a set of fields
which A&AS reads or writes to. This section displays the fields that are
available in the above-selected file or allows users to create new fields
based on the selected data source.
