Importing Objects from the HANA Repository

PowerDesigner provides a wizard to allow you to import analytic and attribute views from the HANA repository, along with their supporting catalog tables.

Note: This feature requires a 32-Bit Java installation.
  1. To import into an existing PDM, select Database > Update Model from HANA Repository.

    or

    To import and create a new PDM, select File > Reverse Engineer > SAP HANA Repository.

  2. Select Database > Update Model from HANA Repository to open the wizard, and .
  3. Click Next on the Welcome page, enter your HANA repository host name and instance number along with your user name and password, and then click Next to connect.
    Note: The account with which you connect must have at least the CONTENT_ADMIN, MODELING, and PUBLIC roles.
  4. Select packages in the repository in the left pane to make their contents available to import. Select the analytic views to import in the right pane, and then click Next.
    When you select an analytic view to import, its supporting attribute views are automatically selected for import.
    Note: The archive model retains a snapshot of the structure of your objects at import time to help in determining model changes when re-exporting to HANA (see Archive PDMs).
  5. Select catalog tables to import from the list, and then click Next.
    PowerDesigner automatically selects any catalog tables required by the selected analytic and attribute views. Select additional schemas to make their tables available for selection.
    HANA Import - Tables
  6. Review the objects that will be imported and then click Finish.
  7. If objects are already present in the model, a merge dialog will open (see Core Features Guide > Modeling with PowerDesigner > Comparing and Merging Models) to allow you to review the specific changes that will be make. Approve or reject the proposed changes, and then click OK to perfom the import.
    PowerDesigner will import schemas, users, and tables to the root of the model and analytic and attribute views to their appropriate HANA packages. When the import is complete, click Close to exit the wizard.