Cora Knowledge Center

Support

Data Models

A data model consists of queries that connect to various data sources. There are several query types.

Query Types

Query TypeDescription
TablesUACT tables in the Cora SeQuence database.
Lookup TablesTables with lookup values that you can use in various several controls, such as combo boxes, option groups, and grids.
Stored ProceduresProcedures that return data from the default Cora SeQuence database or through a connection string, based on input parameters.
ServicesCalls to external service methods, Web services, or WCF services to retrieve data.
FilesCopies 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