A data model consists of queries that connect to various data sources. There are several query types.
Query Types
| Query Type | Description |
|---|---|
| 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 default Cora SeQuence database or through a connection string, 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. |
Advanced Options
There a several advanced options for defining the data model.
- Import
- OData Services
