How to automatically view data result dynamically from external database without using UI/Case/Action?
Good day everyone,
I'm using both external database and internal database to integrate each other. External database is read-only, while internal database is dynamically change depends on the data in external database. (Ex: I want to sum the value property inside external, so I put it into property from internal database).
So it's like this, External is Page List and Internal is Single Page. The data inside Internal Database is change everytime the data from external database modified/manipulate(DML). We don't use any case or UI so we need to do this automatically.
I've tried using data page internal(D_Internal) to contain both table from data source using activity but when I run the data page, I got no data result.
Inside my activity that I used, I put RDB method and when I run the activity, I got the result that I want.
Can anyone help me what's wrong or missing? Thanks. (PS: The Internal Data page will be used in mobile)
Best Regards,
Jimmy
Data Page is a good approach, besides have you check the external mapping to the class mapped to external db table? you can check database class mapping landing page. Make sure you have a database rule defined to connnect to external DB.
You can source a report definition rule as a source to data page to get the results from the external DB table.
Hi Jimmy,
Can you please clarify the below statement.
"I've tried using data page internal(D_Internal) to contain both table from data source using activity but when I run the data page, I got no data result.
Inside my activity that I used, I put RDB method and when I run the activity, I got the result that I want."
In the first sentence, you said activity is not returning any result. And in the second, you said you are getting the desired result.
Thanks,
Prudhvi
Hi Prudhvi,
"using data page internal(D_Internal) to contain both table from data source using activity" means when I test it to run from the D_Page. (data source:activity)
"Inside my activity that I used, I put RDB method and when I run the activity" and this is when I test from Activity. (without D_Page)
Finally, I've discard to use activity data source and using ReportDefinition as datasource and it works. (using function, function alias, class joins and param)
Thanks,
Jimmy
Hi Jimmy,
Without using UI/Case/Action where do you want to view the results returned from the external db.
If you are using D_Page it need to be referred some where to get it called.
Hi BendeRaghunath,
The D_Page isn't called in PEGA but in another application third-party as a web service for mobile java.
It only contain list data which has been query.