Supported RDBMS brands and features for Corticon EDC
Corticon EDC can connect a Vocabulary to an instance of a supported database. All data sources support Import/Clear Database Metadata and Validate Mappings. Some Corticon EDC features are not supported in certain supported databases. Data manipulations and database startup functions that might be required to ensure error-free interaction between Corticon EDC and a database 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:
Database
Import Vocabulary
Create Schema
DB Rows: Read/Update
DB Rows: Read-only
Import Metadata
Import Enumerations
Extend to database
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.
