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

A closer look at how Corticon relates to Datasources

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

A closer look at how Corticon relates to Datasources

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: December 27, 2021
  • 1 minute read
    • Corticon
    • Version 7.3
    • Documentation

All Corticon's data integration techniques enable sophisticated interaction with database architectures.

Contents
  • 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
Alert