Data Sources

Top Previous Topic Next Topic  Print this topic

Data sources are essentially structures of fields from which you can pull your data. Examples include: a database table, a query, a stored procedure result, XML data, CSV file, or data returned by a Web service call. You can also create your own custom data sources.

 

Data Architect supports the following types of data sources:

 

Table data source - data from a database table/view (relational model)
SQL data source - data from a user defined SQL query
Hierarchical data source - data from an XML file or returned by a web service call
Procedures data sources - data from a database stored procedure
Custom data sources - data sources implemented by software developers
CSV data sources - data from an CSV (Comma Separated Values) file
Text file - data from a text file.

 

new-input-formats-with-csv

 

Note that Data Architect works the same way with all data sources. You don't need to know which type of data source you are using to bind data between inputs and outputs.

Just connect the data sources with the Output as described in the Data Binding section.