Supported RDBMS brands and features for Corticon EDC

Corticon EDC can connect a Vocabulary to an instance of a supported data source. All data sources support Import/Clear Database Metadata and Validate Mappings. Some Corticon EDC features are not supported in certain supported data sources. Data manipulations and data source startup functions that might be required to ensure error-free interaction between Corticon EDC and a data source are noted.

Note: The mapping of database columns to a Corticon Vocabulary through SQL might experience problems when database columns have hyphens, spaces or other special characters (even though some databases and SQL parsers allow them). The generally accepted valid values are all alphanumeric characters and the underscore character. It is a plus to use all-lowercase names to avoid platform case inconsistencies. For more information on Corticon's accepted names, see the topic Vocabulary node naming restrictions

The following table summarizes the features:

Data Source

Import Vocabulary

Create Schema

DB Rows: Read/Update

DB Rows: Read-only

Import Metadata

Import Enumerations

Extend to database

DataDirect Cloud: Rollbase

-

-

Yes

-

Yes

Yes

Yes

DataDirect Cloud: Salesforce

-

-

Yes

-

Yes

Yes

Yes

IBM DB2

-

Yes

Yes

Yes

Yes

Yes

Yes

Microsoft SQL Server

-

Yes

Yes

Yes

Yes

Yes

Yes

MySQL

-

Yes

Yes

Yes

Yes

Yes

Yes

Oracle Database

-

Yes

Yes

Yes

Yes

Yes

Yes

Postgres

-

Yes

Yes

Yes

Yes

Yes

Yes

Progress OpenEdge

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Progress OpenAccess

Yes

-

Yes

Yes

Yes

Yes

Yes

Note: The feature of importing database metadata will infer associations when the information (foreign keys) is available in the data source's metadata.