To connect a Vocabulary to a newly defined database , the Vocabulary's Database Access tab provides essential and optional parameters, as follows:
where:
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 as well as full support for deployment with the object relational mapping (ORM) technology of Hibernate and Progress Applicaton Server. 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 (in this example, myDBhost:333), and (2) <database name> with the database name that was set up (typically case-sensitive).
Note: Avoid using the loopback identity (localhost or 127.0.0.1) as the server identity.
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.
Click Test Connection. The following alert indicates success:
The basic connection works. The optional parameters (catalogs and filters) and properties might be required in certain circumstances.
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 as well as full support for deployment with the object relational mapping (ORM) technology of Hibernate and Progress Applicaton Server. The drivers are pre-configured and do not require performance tuning.