This section describes how to create or upgrade an Expere Data Model. Creating a test data model is identical to creating a production data model.
Note: No practical difference exists between a test and production data model apart from the location and usage.
The user may use one of two methods for creating an Expere data model:
- The automated process with installation wizard
- The manual process from the command line. If performing a manual install, skip to the manual install process (refer to Appendix D for alternative installation methods).
The installation should be performed from the Database Administrator (DBA) workstation.
Checklist
- Determine the location to install each data model.
Note: Expere will function correctly if more than one Data Model resides within an Oracle database instance. For security reasons, Wolters Kluwer Financial Services does not recommend co-locating test and production data models within the same database instance.
Determine a location to extract Expere Data Model scripts. The folder requires 100 MB of space. Two versions will be extracted: one for Windows and another for Linux. An Expere data model with no stores or content consumes 4MB of space in the database.
Note: .NET Users: Expere will function correctly if more than one Data Model resides within a database instance. For security reasons, Wolters Kluwer Financial Services does not recommend co-locating test and production data models within the same database instance.
.NET Users: Determine a location to extract Expere Data Model scripts. The folder requires 100 MB of space. An Expere data model with no stores or content consumes 4MB of space in the database.
- Users must have the SYSTEM user ID and password (or an equivalent user) to create the Expere owner. With this ID and password, users can complete the install procedure.