Question
Cognizant Technology
IN
Last activity: 11 Dec 2020 0:59 EST
Fetch data from external table using Report Definition
Hi Team,
I have a requirement of fetching data from external database using RD.
I did follow the below steps: 1.Created a Database rule to map external DB table 2.Created DB table rule and class rule rule such that mapping the external table name 3.Created two sample properties and updated them in External Mapping table tab of Class rule with the Column names present in the external table name
4.Created a RD and included both the columns and ran it.
But I see that results are not displayed. I did test connection in class rule and it is success.
Could some one help me in this please.
Pegasystems Inc.
US
Check to make sure the case of the column names you are trying to retrieve is what your database is expecting. Some databases are or can be set to be case sensitive WRT column names in a query. If that's the case, the names you have in the mapping have to match case exactly.
Updated: 1 Dec 2020 3:50 EST
IT
US
Check the mapping tab on the external class and ensure the property mappings to DB columns are correct.
Try generating the DB class mappings through Class mapping wizard.