Report Source

Report Model extracts data from an unstructured file into a structured file format using an extraction logic. It can be used through the Report Source object inside dataflows in order to leverage the advanced transformation features in Astera Data Stack.

Video

Getting Report Source Object

In this section, we will cover how to get the Report Source object onto the dataflow designer from the Toolbox.

1. To get a Report Source object from the Toolbox, go to Toolbox > Sources > Report Source. If you are unable to see the Toolbox, go to View > Toolbox or press Ctrl + Alt + X.

1. Drag-and-drop the Report Source object onto the designer.

You can see that the dragged source object is empty right now. This is because we have not configured the object yet.

Configuring the Report Source Object

1. To configure the Report Source object, right-click on its header and select Properties from the context menu.

A configuration window for Report Source will open.

1. First, provide the File Path of the unstructured file (your report) for which you have created a Report Model.

1. Then, specify the File Path for the associated Report Model.

1. Click OK, and the fields added in the extraction model will appear inside the Report Source object with a sub-node, Items_Info, in our case.

1. Right-click on the Report Source object’s header and select Preview Output from the context menu.

A Data Preview window will open and shows you the data extracted through the Report Model.