Generating a RAPCache or RAPStore Model from a RAP Messages Model

Generate either a RAPCache or a RAPStore physical data model from a RAP Messages logical data model.

1. Open the RAP Messages model.
2. From the PowerDesigner main menu, choose Tools > Generate Physical Data Model.
3. In the General tab of the PDM Generation Options dialog, choose either:
   • Generate new Physical Data Model
   • Update existing Physical Data Model
4. For a new model, choose the target DBMS and the appropriate Name and Code.
   • For RAPCache, choose:

     Field	Value
     DBMS	Sybase AS Enterprise 15.5
     Name	Keep the default, RAP Cache, or enter another name.
     Code	Auto-generated from Name. For example, when Name is RAP Cache, Code is RAP_CACHE.

   • For RAPStore, choose:

     Field	Value
     DBMS	Sybase IQ 15.2
     Name	Keep the default, RAP Store, or enter another name.
     Code	Auto-generated from Name. For example, when Name is RAP Store, Code is RAP_STORE.

5. To update an existing model, select the model and leave Preserve Modifications selected.
6. Click the Detail tab.
7. (Optional) Choose Check model and Save generation dependencies.
8. Ensure that Enable transformations is selected.
9. For a new model, click the Extensions tab and ensure that the appropriate extension is selected:
   • RAPCache when generating a new Adaptive Server Enterprise
   • RAPStore when generating a new Sybase IQ
10. On the Pre-generation and Post-generation tabs, ensure that all transformation rules are selected.
    Post-generation tab appears only for new models.
11. On the Selection tab, select RAP messages to create tables for in the RAPCache or RAPStore, and choose OK.
12. When updating an existing model, in the Merge Models dialog, confirm the updates you want and choose OK.

After generation, check indexes, set physical options, and add foreign keys as needed.

• Checking Indexes
  PowerDesigner creates default indexes. Add, edit, or remove as needed.
• Setting Physical Options
  Set physical options for each table as needed for your RAPCache or RAPStore database.
• Adding Foreign Keys
  Add foreign-key relationships to physical data models.
• Setting Datatypes for Lookup Columns
  Ensure that lookup columns for a generated physical data model have the correct datatype.