• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

What are my options in utilizing datasources from Oracle, DB2 & MSSQL in SSRS.

I need to pull data from multiple datasources - Oracle, DB2 & MSSQL.
How can I build a single dataset using all 3 datasources?
What connectors should I use?
0
rhservan
Asked:
rhservan
1 Solution
 
HuaMin ChenSystem AnalystCommented:
You can build linked server to refer to Oracle/DB2, within Sql server.
Linked Servers (Database Engine)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now