Reading Data from SAP HANA Modelling Views Using PowerCenter

Reading Data from SAP HANA Modelling Views Using PowerCenter

Creating Sessions and Workflows

Creating Sessions and Workflows

Install the 64-bit HANA ODBC driver and use the 64-bit ODBC data source in the ODBC connection. Create an ODBC connection of the SAP HANA ODBC subtype. In the session, you must use a relational reader.
  1. In the PowerCenter Workflow Manager, click
    Tools
    Task Developer
    .
  2. Click
    Tasks
    Create
    .
  3. Select
    Session
    as the task type to create.
  4. Enter the session name and click
    Create
    .
    The
    Mappings
    dialog box appears.
  5. Select the required mapping and click
    OK
    .
  6. Click
    Done
    in the
    Create Task
    dialog box.
  7. In the workspace, double-click the session you created.
  8. On the
    Mappings
    tab, select
    Sources
    in the Transformations pane on the left.
  9. Select the source as
    Relational Reader
    .
  10. To select the source connection name in the
    Connections
    pane, click
    Edit
    .
    The
    Connection Object Definition
    page appears.
  11. Enter the source connection name.
  12. Enter the username and password.
  13. In the
    Connect String
    field, specify the 64-bit ODBC data source.
    You must install the 64-bit HANA ODBC driver to use the 64-bit ODBC data source.
  14. Select the ODBC subtype as
    SAP HANA
    .
    If you do not select the ODBC subtype as SAP HANA, the session fails.
    The following image shows the ODBC subtype selected for the connection:
    The Connection Object Definition page shows the ODBC subtype selected as SAP HANA.
  15. Click
    OK
    .
  16. In the
    Properties
    pane for the source connection, specify the
    Owner Name
    as
    _SYS_BIC
    .
    The following image shows the owner name for the source connection in the
    Properties
    pane:
    The image shows the owner name for the connection.
  17. Select a target.
  18. Click
    OK
    to save and close the session properties.
  19. Create a workflow.
  20. Run the workflow.

0 COMMENTS

We’d like to hear from you!