A cache connection definition defines the connection properties for the cache database. Information Object Designer creates a subfolder in the project’s Cache Sources folder to contain a cache connection definition file. A cache connection definition file name has a .dcd extension. Cache connection definition file names are not case-sensitive.
For example, if you create a cache connection definition for the database MyCacheDatabase, Information Object Designer creates the folders Cache Sources and MyCacheDatabase and the cache connection definition file _MyCacheDatabase.dcd. As shown in Figure 4-1, the file _MyCacheDatabase.dcd resides in MyCacheDatabase.
|
Figure 4-1
|
The procedure for creating a cache connection definition is the same as the procedure for creating a data connection definition, except that you must also provide the names of the database catalog and schema in which you want to create the cache table. The database user you specify for the cache connection definition must have permissions to create, modify, and delete tables in the schema.
