PDF Export
Print Print
Expand All
  • Stemmons Central User Manual
    • Overview
    • Cases
    • Departments
    • Entities
      • Entities System Overview
      • Entities Stemmons Application Architecture
      • Entities System Data Architecture
      • Entities System Configuration
        • Overview
        • Entities Currency Types Configuration
        • Entity Activity Types Configuration
        • Entity Field Type Cascades Configuration
        • Entity Type Category Configuration
        • Entity Type Configuration
        • Entity Fields Configuration
        • Entity Field Types
        • Entities External Datasources Configuration
        • Entities Note Types Configuration
        • Entities Relationships Configuration
        • Entities System and Reporting Codes Configuration
        • Entities System Configuration - Table Configuration
        • System Configuration - Security Configuration
        • Entities - Entity Super Admin
        • Entities - Configuration
        • Entities Extensible Grid Configuration
        • Entities External Entities Source
        • Entities Screen Items Configuration
        • Entities External XML Configuration
        • Entities External XML Fields Configuration
      • Entities System Best Practices
      • HTML Template for Entities
      • HTML Tag Body Template for Entities
      • Tag Control for view control in Entities
      • Entities Calculation Field
      • Entities - Departments Relationship (Available in GM 1.2)
      • Entities Cases Relationship (Available in GM 1.2)
      • Entities Quest Relationship (Available in GM 1.2)
      • Extensible Grid in Entities (Available in GM 1.2)
      • Subscription to Hopper-Entities (Available in GM 1.2)
      • System Code for Entities Publishing Purpose (Available in GM 1.5)
      • Kanban View for Entities (Available in GM 1.5)
      • Entity to Entity Role Relationship (Available in GM 1.5.2)
      • Recipe Builder
      • External Entities
      • Security Scenarios for Diffrent Users in Entities Application
      • Field Level Security for Entities (Available in GM 1.2)
      • Entities Job Aid
      • Entities Dynamic Template (Available in GM 1.5.4)
      • Entities Portal (Available in GM 2.0)
      • Email to Entities (Available in GM 2.0)
      • Entity Overlay (Available in GM 2.1)
      • Entity Merging (Available in GM 2.1.5)
      • Entity Copy (Available in GM 2.1)
      • Entities Hopper (Available in GM 2.1)
      • Unassign Item button in Entities (Available in GM 2.1)
      • Entity Conversion (Available in 2.1.5)
    • Facts
    • Standards
    • Quest
    • Home
    • CAST (Central Automation System)
    • Common Language Gateway (CLG) /Common Data Resource
    • External User
    • Import Tools
    • Stemmons Web API
    • Migration Tool
    • ULS (Unified Logging System) Log Viewer
    • BlockChain-Trigger
    • Blockchain Trigger API Matrix Table
    • Custom Branding
    • Stemmons Search
    • Appendices
    • Justin's Notes
    • Updoc
    • Passive Trigger
    • Stemmons Central Mobile Application Login Process
    • How to Configure SSO with a SAML 2.0 in Stemmons Cloud Authentication Handler
    • Stemmons Cloud Authentication Handler
Entities External Datasources Configuration

An External Datasource refers to constrained data obtained from outside the specific Field that is consuming it. The alternative, for constrained data, is a Select Field Type with configured Values.

External Datasources most commonly originate from the Stemmons Common Language Gateway (CLG) or from the Stemmons Core Systems (Entities, Quest, Cases, etc), and should not come directly from other external systems.

Using an External Datasource provides a significant benefit in the Entity Detail screen by making the field linkable, so a user can navigate back to a list of other similar Entities that use that External Datasource.

Configuring External Datasources requires a knowledge of SQL and an understanding of the format and layout of the underlying data. Consult a technical resource for more information on this topic.

Following are the list of columns in the External Datasources configuration screen:

  • ID: ID of External Datasource. Primary ID.

  • Name: Name of the External Datasource

  • Description: A short description that to be used as Tool Tips.

  • Connection String: Database Connection String connects to the database. The Connection Strings are maintained in Entity Connection String table.

  • Internal Entity Type: Entity Type that makes up the dropdown values for the Data source.

  • Query: SQL Query to select the data for the External Datasource. The returned dataset should contain 3 data fields: ID, Name, and Description. Note: If the External Datasource is from an Entities’ Entity Type, the system will generate the SQL Query once an Entity Type is selected in the Internal Entity Type column.

  • Validator: !Execute command allows validation of the SQL Query Syntax and provides preview of data return from the SQL Query.

  • Object ID: ID field to bind/store the data from the External Datasource with the Entity field.

  • Object Display: Value field that will display in the dropdown.

  • Object Description: Description of the dropdown value.

  • URL: Provides syntax to create a URL to view the returned value. (Future use.)

  • Field System Code: Associates an Entity-Level System Code with External Datasource.

  • Value System Code: Associates a Field-Level System Code with External Datasource.

  • Filter: Provides an additional Filter to apply against the Query.

  • Active: Check to activate this item and to make it live.