Data Sources

Data sources are essentially structures of fields from which the user can pull the data. Examples include: a database table, a query, a stored procedure result, XML data, CSV file, or data returned by a Web service call. Custom data sources can also be created.

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

•	DAX Subdocument - the output of a previously created DAX document

new-input-formats-with-csv

Note:

•	Data Architect has the same behaviour with all data sources. As a result, the user is not required to know which type of data source is using to bind data between inputs and outputs. The data sources must only be connected with the Output as described in the Data Binding section.