Note: Using the sample: The EDC database connection is defined in the Vocabulary. Enter your username and password, and then test the connection.

To connect a Vocabulary to a database:

  1. On the Vocabulary menu, choose Add Datasource > Add EDC Datasource as shown:


  2. The EDC tab is added to the root level of the Vocabulary, as illustrated:

    where:

    • Description: An informative description of the intended use for the database you are accessing.
    • Database Server: The database product. Click the dropdown menu on the right side of the entry area to list the available database brands. Corticon embeds Progress DataDirect JDBC Drivers for each database. These drivers provide robust, configurable, high-availability functionality to RDBMS brands. The drivers are pre-configured and do not require performance tuning.
    • URL: The preconfigured URL for the selected database server. You must edit the default entry to replace (1) <server> with the machine's DNS-resolvable hostname or IP address and port , and (2) <database name> with the database name that was set up (typically case-sensitive).
    • Authentication: The authentication technique required for the Datasource. Most drivers default to Basic where the Username and Password fields are available, and offer Keberos as the alternative. Some drivers have other options. See Authentication on EDC and ADC connections for more information.
    • Catalog Filter and Schema Filter: Patterns that refine the metadata that is imported during Import Database Metadata and Create/Update Database Schema.
      Note: Filters are a good idea for production databases that might have hundreds or even thousands of schemas. As the Catalog filter value does not support wildcards, distinguishing two metadata import filters enables the use of wildcards in the Schema filter value: Underscore (_) provides a pattern match for a single character. Percent sign (%) provides a pattern match for multiple characters (similar to the SQL LIKE clause). For example, you could restrict the filter to only schemas that start with DATA by specifying: DATA%. The ability to specify patterns is especially valuable when testing performance on RDBMS brands with applications that use multiple schemas.
    • Additional properties: Extended properties are not typically needed on an EDC connection. For more about these properties, see Set additional EDC Datasource connection properties.
  3. Click the CONNECTION Test button. An alert indicates success.

Importing Datasource and Database Access configurations

You might be given a Datasource XML configuration file that defines the EDC connection as well as its security credentials. In that case, do the following:
  1. On the project's Vocabulary menu, select Datasource Configuration File > Import .
  2. Browse to locate and select the .xml configuration file to apply.
  3. When you click OK, the EDC Datasource definition is added to your Vocabulary. If you already have an EDC Datasource defined, the EDC definition will not be overwritten.
If you have an older Database Access Properties file, you can import it as follows:
  1. On the project's Vocabulary menu, select Datasource Configuration File > Import Database Access Properties.
  2. Browse to locate and select the .properties configuration file to apply.
  3. When you click OK, the EDC Datasource definition is added to your Vocabulary. If you already have an EDC Datasource defined, the EDC definition will not be overwritten.