Question
Using Dataflow, how to get data from two different data source and merge and display in one repeating grid
Hi,
Using Dataflow, how to get data from two different data source and merge and display in one repeating grid.
Assume:
Datasource 1 : pega database
Datasource 2: external database
if we have any other best design approach, suggest me
In a single report definition, we can't pull data from to different data source and merge.
only option, we need to have two different report definition for each data source and manually need to merge RDs output.
Look like dataflow provides in build option to merge have merged data under one class, looking more details from dataflow SME
Report definitions allow you to join data from different sources as long as you have a field that can be used to conciliate the data retrieval. That is also true for the data flow. For the data flow possibilities, you need to figure out whether you want to merge data or compose it.
Considering this example data model:
ClassA -> P1 (Key), P2
ClassB -> P3 (Key), P1
Merge would result in:
- P1
- P2
- P3
Compose would result:
- P1
- P2
+ ClassB [page name is e.g.]
- P1
- P3
In either case, you need a class that represents the external database table, and make sure you have a data set of database type that you can use in the data flow. Let us know which data processing route suits you better, and we can post an example that hopefully will get you started.
Is the functionality provided in report definitions not enough for what you want to achieve?