Show TOC

Importing Objects from the HANA RepositoryLocate this document in the navigation structure

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

Context

Note This feature requires a 32-Bit Java installation.
Note The HANA Import Wizard supports importing objects from the HANA repository, but does not support importing from an HDI environment. In both repository and HDI environments, you can reverse-engineer activated tables through the standard reverse-engineering commands (see Reverse Engineering a Database into a PDM).

Procedure

  1. To import into an existing PDM, select Start of the navigation path Database Next navigation step Update Model from HANA Repository End of the navigation path.

    or

    To import and create a new PDM, select Start of the navigation path File Next navigation step Reverse Engineer Next navigation step SAP HANA Repository End of the navigation path.

  2. Select Start of the navigation path Database Next navigation step Update Model from HANA Repository End of the navigation path to open the wizard, and click Next on the Welcome page.
  3. Enter your HANA repository connection parameters and then click Next to connect:
    Parameter Description
    Connection Name Select an existing connection from the list or use the tools to the right of the Connection field to create a new connection profile, review the properties of the existing profile, or delete it. HANA connection profiles are stored in the registry.
    Host name Specifies the network name of the HANA appliance.
    Instance number Specifies the HANA instance number.
    Mode If your HANA system is installed in multiple-container mode, you must specify the container to connect to:
    • Single container - [default] Single tenancy HANA system. Sets the port number to 3<nn>15 (where <nn> equals the instance number).
    • Multiple containers - Multitenancy HANA system. You can connect to:
      • System database container - sets the port number to 3<nn>13
      • Tenant database container - Enter the Name of your container. Sets the port number to 3<nn><xx>, where <xx> is a number greater than 40, allocated to your database by the system.
    User name/ password Specifies the credentials to connect with.
    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, attribute, and calculation views to import in the right pane, and then click Next.
    When you select an analytic view (fact) to import, its supporting attribute views (dimensions) are automatically selected too. When you select a calculation view to import, its data sources are automatically selected too.
    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. On the Catalog Objects tab, PowerDesigner automatically selects any catalog tables and views required by the selected analytic, attribute, and calculation views for import. Select additional objects to import from the lists, and then click Next.
    Note You can select additional schemas from the list to make their objects available for selection.
  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 perform the import.
    PowerDesigner will import schemas, users, tables, and views to the root of the model and analytic, attribute, and calculation views to their appropriate HANA packages. When the import is complete, click Close to exit the wizard.