ReportMiner enables users to build and run dataflows. A dataflow is a graphical representation for sources, destinations, transformations, and maps. Report models can be used as sources in dataflows in order to leverage the advanced transformation features in ReportMiner. Let’s add the report model to a dataflow so we can read the entire source report and feed it to a destination object.
Go to File -> New -> Dataflow. This creates a new dataflow.
Using the Toolbox pane, expand the Sources category, and select Report Source. Drag and drop Report Source onto the Designer.
Double click the ReportModel1 object that we just added (or right click it and select Properties) to open the Properties dialog.
Using the Properties dialog, enter the path to the report source file and the report model. The report model location should point to the report model we created and saved earlier (Figure 21).
Figure 21Click OK to close the dialog. The Report_Source object shows the report structure according to the report model we created (Figure 22).
Figure 22You may need to expand the tree nodes to see all the child nodes under the root node. Our new report source is ready to feed data to t he downstream objects in our dataflow.
Creating Dataflows from Export Settings
There is a way to create dataflows directly from the Export Setting Browser. Look for the button in the Export Settings Browser toolbar. Select an existing export setting and click on this button. A new dataflow will be created and opened in a new window as shown in Figure 23. Please refer to the Astera Centerprise Data Integrator user manual to learn more about dataflows.