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.
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.
Posted: 10 months ago
Updated: 10 months ago
Posted: 11 Dec 2020 0:58 EST Updated: 11 Dec 2020 0:59 EST