Working with a data store alias

A data store alias is a user-defined object associated with a database. When you define a data store alias, you provide parameters that Optim™ uses to communicate with that database. These parameters include the type and version of the database management system (DBMS) and the properties for both a client connection and a JDBC connection.

A data store alias name serves as a high-level qualifier that allows you to access a specific database to perform requested functions. For example, in an access definition, you must qualify the name of a table with a data store alias name. The referenced data store alias supplies the parameters needed to connect to the database in which the table resides.

A data store alias identifies a specific database and serves as a prefix in the fully qualified names of primary keys, database tables, and relationships. Data store aliases are essential elements in managing your databases. The following rules apply to data store alias names:



Feedback