Data Models

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 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 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.



Advanced Options

There a several advanced options for defining the data model.

  • Import
  • OData Services
About this Article
  • Created: 05/17/2017 1:17 am EDT
  • Last updated: 11/06/2017 3:06 am EST
In This Article