Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Corticon Data Integration

Mapping and validating EDC database metadata

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Why your rules might want to access external data
  • Corticon alternatives for data integration
  • How Corticon concepts apply to Datasources
  • About the sample projects referenced in this guide
  • How Datasource information is viewed in the Vocabulary
  • Getting Started with EDC
    • Define a table namespace in the database
    • Define the database connection for EDC
    • Set the entities to store in the database
    • Load the schema and data in the database
    • Import EDC database metadata into a Vocabulary
    • Test the rules when reading from the database
    • Test the rules when writing to the database
  • Getting Started with ADC
    • Overview of the Advanced Data Connector
    • Define a table namespace in the database for ADC
    • Create and map the ADC schema and queries
    • Define a database connection for ADC
    • Define and import queries for ADC
    • Import ADC Datasource metadata into a Vocabulary
    • Use an ADC connection as a Ruleflow service callout
    • Test the rules when reading from the ADC database
    • Test the rules when writing to the ADC database
  • Getting Started with Multiple Database Connectivity
    • Define multiple table namespaces
    • Create and map the multiple database schemas
    • Define multiple database connections
    • Define and import queries for multiple databases
    • Import multiple Datasource metadata into a Vocabulary
      • A closer look at MDB metadata
    • Use multiple database connections as Ruleflow service callouts
    • Test the rules when reading from multiple databases
    • Test the rules when writing to multiple databases
  • Getting Started with REST
    • Overview of the Autonomous REST Connector
    • Define a Datasource connection for REST
    • Create and map the REST schema
    • Use REST data sources in a Ruleflow
    • Test rules when importing from the REST Datasource
    • Revise Connection and Service Call-out to retrieve data
  • Mixing REST and database access
  • Deploying projects that use data integration
    • Export the Datasource Configuration file
    • Package a project in Corticon Studio for Corticon Server
  • Getting Started with Batch
  • A closer look at how Corticon relates to Datasources
    • Supported databases
    • Add your own database driver
    • Authentication on EDC and ADC connections
    • SmartMatching of Vocabularies to databases
    • Validation of names against SQL keywords and database restrictions
    • Support for catalogs and schemas
    • How to filter catalogs and schemas
    • Fully-qualified table names
    • Support for database views
    • Associations as join expressions
  • Advanced EDC Topics
    • How to set EDC Vocabulary properties
      • Edit Entity EDC properties
      • Edit Attribute EDC properties
        • Import possible values of an attribute from database tables
        • Enumerated values
      • Edit Association EDC properties
    • Mapping and validating EDC database metadata
      • Mapping EDC database tables to Vocabulary Entities
      • Mapping EDC database fields (columns) to Vocabulary Attributes
      • Mapping EDC database relationships to Vocabulary Associations
      • Validate EDC database mappings
      • Types of mapping validation and validation errors
    • Set additional EDC Datasource connection properties
    • How data from an EDC Datasource integrates into rule output
      • When Datasource access is Read Only
      • When Datasource access is Read/Update
    • EDC data caching
      • How to specify caching on Vocabularies and Rulesheets
      • Settings for EDC caching
      • How to work with database caches
    • Metadata for Datastore Identity in XML and JSON Payloads
    • Relational database concepts in the Enterprise Data Connector
      • Identity strategies
      • Advantages of using Identity Strategy rather than Sequence Strategy
      • Key assignments
      • Conditional entities
      • Dependent tables
    • How EDC handles transactions and exceptions
  • Advanced ADC Topics
    • Mapping ADC database metadata
      • Mapping ADC database tables to Vocabulary Entities
      • Mapping ADC database fields to Vocabulary Attributes
      • Mapping ADC database relationships to Vocabulary Associations
    • How to configure ADC
      • How to configure ADC reads
      • How to configure ADC writes
      • How to configure generated Primary Key retrieval
      • How to configure batch
      • Configuration details
        • Set additional ADC Datasource connection properties
    • How Corticon is expressed in SQL
    • Tips and techniques in SQL data integration
  • Advanced REST Datasource Topics
    • Authentication on REST Service connections
    • Parameters on REST Service connections
    • Import REST Datasource metadata into a Vocabulary
    • Mapping REST Service metadata
      • Define your preferred schema
      • How to define associations in REST Service metadata
  • Data type mappings from database fields
Table of Contents

Mapping and validating EDC database metadata

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: November 14, 2017
  • 1 minute read
    • Corticon
    • Documentation

Mapping data between a Corticon Vocabulary and relational database is not always perfect. When there are issues, you need to review the mappings to resolve incomplete or conflicting mapping data.

Contents
  1. Mapping EDC database tables to Vocabulary Entities
  2. Mapping EDC database fields (columns) to Vocabulary Attributes
  3. Mapping EDC database relationships to Vocabulary Associations
  4. Validate EDC database mappings
  5. Types of mapping validation and validation errors
TitleResults for “How to create a CRG?”Also Available inAlert