0

I have been using Direct Query for accessing Oracle DB data, but the thought process is I have to access multiple Oracle DB source data to show the consolidated result in my report.

As for I have gone through in official sites click on here, There are some cons for making a live connection to multiple Oracle DB approach.

Do you people have any suggestion/recommendation based on your live working experience?

Wanna Coffee
  • 2,742
  • 7
  • 40
  • 66
  • You will almost universally see better performance when importing, rather than utilizing DirectQuery. – greggyb Sep 20 '19 at 14:58
  • Correct Greggyb, But the thing is that customer don't want to store their financial data anywhere outside of their network... I don't have any option other than Direct Query, do you think of any better solution for this... – Wanna Coffee Sep 23 '19 at 06:14
  • 1
    If they want to keep data resident within their network, I'd stand up SSAS for them, rather than DirectQuery-ing relational sources. – greggyb Sep 23 '19 at 15:33

0 Answers0