A data model consists of queries that connect to various data sources. There are several query types.
|Tables||UACT tables in the Cora SeQuence database.|
|Lookup Tables||Tables with lookup values that you can use in various several controls, such as combo boxes, option groups, and grids.|
|Stored Procedures||Procedures that return data from the Cora SeQuence database, based on input parameters.|
|Services||Calls to external service methods, Web services, or WCF services to retrieve data.|
|Files||Copies data from a file, which you can use as a data model. Supported file types are CSV, Open XML, and XML.|
There a several advanced options for defining the data model.
- OData Services