1. DatabaseA: MSSQL 2012
2. DatabaseB: Oracle 11g
I want to add both databases as datasources in an SSRS project.
1. I want to query both databases in a single dataset.
Also, Would it be better to utilize Oracle as a linked server or incorporate it directly into my report as a datasource?