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. Choose 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.
Database 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).
Use Kerberos Authentication: When selected, indicates that the user will use the Kerberos authentication protocol. The Username and Password are greyed as they are not relevant for the Kerberos protocol:
Username: The user credentials that enable connection to the database. The credentials are encrypted when the database access file is exported for deployment.
Password: The specified user's password.
Catalog Filter and Schema Filter: Patterns that refine the metadata that is imported during Import Database Metadata and Create/Update Database Schema.
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.
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.
Description: An informative description of the intended use for the database you are accessing.