Forum Discussion

Chand's avatar
Chand
New Contributor II
3 years ago

How to join application database and Framework databases tables in same data adapter query

Hello  I have a requirement where i need to join the framework database and application database in the same dashboard . We have created data adapter individually one for framework and one for Ap...
Reports
ChrisLoran's avatar
ChrisLoran
Valued Contributor
3 years ago

If going down the route of cross-joining tables in a single query, then bear in mind that on SAAS / Cloud the Framework database and Application database use different connection strings .  Although this approach may well work on somebody's laptop or local installation, or on-premise server, do ensure it's properly tested if moving to the cloud.