User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Configuring Plans for Exporting Data from RDM Hierarchies

RDM lets you export data from a configured hierarchy. The configuration produces a plan for each hierarchy.

Step 1 Generate the plan

Expand RDM Logical Model > Hierarchies, right-click one of the existing hierarchies, and select Generate export plan.

The plan naming convention is [hierarchy_name]_export.plan.

Step 2 Configure the plan

When a plan for exporting data from a hierarchy is generated for the first time, it contains the following steps:

  • Multiplicator for making input parameters available to all Extended Readers.

  • RDM Extended Reader times the number of levels in the hierarchy for exporting data from RDM.

  • Complex XML Writer for writing data into an XML file.

Complete the plan:

  1. Right-click the hierarchy for which the plan has been generated in the previous step and select Open export plan.

  2. Add an input step (for example, a Text File Reader or JDBC Reader) containing parameters for RDM Extended Reader.

    The data source should have one row of data containing the following data (the column names are up to you: they are mapped to configuration fields in the RDM Reader steps): * username (Optional: if you are passing credentials manually) - A valid RDM user with read permissions to the table. * password (Optional: if you are passing credentials manually) - User password. * timestamp - The date as of which to export data.

    + .Example parameters file

    username;password;timestamp
    betty;5ecurePassword;2016-01-01 00:00:00

    + NOTE: Leaving the timestamp attribute empty is treated as "now".

    + IMPORTANT: The date format in the example is the recommended date format.

  3. Connect the input step with parameters to Multiplicator.

  4. For each RDM Extended Reader step, double-click the step and configure it.

    On the General tab, map the timestamp column from your parameters input to the Timestamp attribute of the step.

  5. (Optional: if you are passing credentials manually) From the step navigation tree, select Credentials and configure the credentials:

    • In the User field, enter the name of the attribute containing the username.

    • In the Password field, enter the attribute containing user password.

The plan is ready to be tested and deployed.

Export hierarchies plan

Notes

Special characters are escaped according to XML standards, for example, & is exported as &.

Was this page useful?