Can Microsoft Reporting Services retrieve data from Oracle?
secretGeek .:dot Nuts about dot Net:.
home .: about .: sign up .: sitemap .: secretGeek RSS

Can Microsoft Reporting Services retrieve data from Oracle?

The very, very short answer is: "Yes."

The fairly short answer is "Yes, Oracle and reporting services can talk to each other in two ways, both of which are efficient and robust."

The longer answer is as follows:

The first method is a fast "Native OLE" method that relies on a component in oracle and a component in reporting services. In particular, version 7.3.3 and later of Oracle include the "Oracle Client and Networking Components" Reporting Services installation is a database connectivity component named "Microsoft OLE DB for Oracle."

These two features talk together to provide very fast access to Oracle, from reporting services (or any Microsoft technology) via OLE DB.

A second method also exists, namely ODBC. In this scenario an ODBC data source is defined that connects to oracle. Reporting Services then connects to the ODBC data source. This is slightly less performant and requires more configuration effort, so it is not the preferred method. But it is a very stable fall back position.

I've previously provided a list of favourite reporting services links.





'm.e.' on Mon, 28 Feb 2005 05:03:00 GMT, sez:

I think you should also be able to use managed providers:
.NET Framework Data Provider for Oracle (http://www.microsoft.com/downloads/details.aspx?FamilyId=4F55D429-17DC-45EA-BFB3-076D1C052524&displaylang=en) or
Oracle Data Provider for .NET (http://www.oracle.com/technology/tech/windows/odpnet/index.html), but have not tested this.



'prasad' on Fri, 01 Apr 2005 03:58:26 GMT, sez:

asdasd



'kanthi' on Fri, 09 Sep 2005 05:42:46 GMT, sez:

how to retrieve data from oracle to vb



'f0vela' on Tue, 28 Mar 2006 12:46:38 GMT, sez:

It's Possible.. right now i'm in the middle of a project that uses an Oracle 9i database and i'm using reporting services to create reports.

It's possible but maybe you'll find some things you can and can't do with them and some Data Providers that don't work all the time.



'Miguel' on Wed, 04 Oct 2006 23:19:54 GMT, sez:

f0vela, can you send me a .rdl demo with the store procedure on oracle?.

Thank

(mgrandez@hotmail.com)



'Juan Manuel Z' on Fri, 09 Mar 2007 16:59:57 GMT, sez:

Hi,

http://www.developer.com/db/article.php/3524781

it works!

(juanmanuelz@gmail.com)



'freeze' on Wed, 31 Oct 2007 05:09:08 GMT, sez:

what about oracle 10g?
the error is missing expression(microsoft OLE DB provider for Oracle)



'Nilesh' on Mon, 28 Apr 2008 18:54:43 GMT, sez:

This is not be a comment but a way i found to ask a quick question

I have been working with Data Processing extension which connects to a Oracle Database. But when I try to grab the SQL created by the Report server I get nothing
just a blank "" commandtext.

But when I connect to SQL Server database I am able to get the generated SQL.

Anybody has any Idea why cant I get the SQL in the DPE when it connects to oracle database?




name


website (optional)


enter the word:
 

comment (HTML not allowed)


All viewpoints welcome. But the right to delete any post for any reason is reserved. Don't make me do it. Comments may be republished, emailed to your loved ones or printed and used as toilet paper. Who reads this legal bit anyhow?

TimeSnapper is a life analysis system that stores and plays-back your computer use. It makes timesheet recording a breeze, helps you recover lost work and shows you how to sharpen your act.

TimeSnapper won last year's Developer Competition at Larkware.com, and is used by over 10,000 people.

Articles

21 tools used in our MicroISV 21 tools used in our MicroISV
Lost Treasures of the DOS World: tree! Lost Treasures of the DOS World: tree!
The Virtual Machine Machine and the Virtual Virtual Machine The Virtual Machine Machine and the Virtual Virtual Machine
Should Linq To Sql Go Should Linq To Sql Go "Open Source"?
Redux: New Synchronisation Idea Overlooked By Microsoft Redux: New Synchronisation Idea Overlooked By Microsoft
New Synchronisation Idea Overlooked By Microsoft Live team New Synchronisation Idea Overlooked By Microsoft Live team
Visual Studio UX Taskforce, Office UX Taskforce... etc. Visual Studio UX Taskforce, Office UX Taskforce... etc.
How to be Jeff Atwood How to be Jeff Atwood
Reuse good -- Abstractions better! Reuse good -- Abstractions better!
Word of the day: Upsert Word of the day: Upsert
awesome Atli tooltip awesome Atli tooltip
Leaky Abstractions? Try Asp.Net! Leaky Abstractions? Try Asp.Net!
A truly original thought A truly original thought
Throw New VirtualMachine(); Throw New VirtualMachine();
Undo, redo, predo, preundo Undo, redo, predo, preundo
A little A little "bit" of programming therapy
Coding Koan: the power of one Coding Koan: the power of one
Behavior Driven Development: As Human As Possible Behavior Driven Development: As Human As Possible
What To (Really) Do If You Find Out Your Parents Are Using Vista (redux) What To (Really) Do If You Find Out Your Parents Are Using Vista (redux)
What To Do If You Find Out Your Parents Are Using Vista What To Do If You Find Out Your Parents Are Using Vista
Sample Code From Text-Adventure Game Platforms Sample Code From Text-Adventure Game Platforms
TimeSnapper 3.0 -- an interactive, bubbling cauldron of possibilities TimeSnapper 3.0 -- an interactive, bubbling cauldron of possibilities
The laptop compubody sock The laptop compubody sock
Everything that's bad for you is suddenly good for you! Everything that's bad for you is suddenly good for you!
Everything I know about Code Reviews I learnt from Star Wars (and JCooney) Everything I know about Code Reviews I learnt from Star Wars (and JCooney)
Syntax highlighting of strings Syntax highlighting of strings
Google AppEngine: evil virus or viral evil? Google AppEngine: evil virus or viral evil?
Workflow software: I'm calling the bluff. Workflow software: I'm calling the bluff.

Archives .: secretGeek :: Complete Archives :.
25 steps for building a Micro-ISV 25 steps for building a Micro-ISV
3 minute guides -- babysteps in new technologies: powershell, JSON, watir, F# 3 Minute Guide Series
Top 10 SecretGeek articles Top 10 SecretGeek articles

Downloads

TimeSnapper -- Automated Screenshot Journal TimeSnapper.com    
Version 2.5: with password protection

ShinyPower (help with Powershell) ShinyPower
Now at CodePlex

Next Action NextAction
Managing the top of your mind



[powered by Google] 


Thai Erawan, Brisbane Restaurant, delicious thai food in paddington Thai Erawan, Brisbane Restaurant
World's Simplest Code Generator (html edition) World's Simplest Code Generator
Gradient Maker -- a tool for making background images that blend from one colour to another. Forget photoshop, this is the bomb. Gradient Maker
How to be depressed How to be depressed
You are not inadequate.



Recommended Reading

The Best Software Writing I
The Business Of Software (Eric Sink)

Recommended blogs

Jeff Atwood
Reginald Braithwaite
Joseph Cooney
Phil Haack
Scott Hanselman
Julia Lerman
Joel Pobar
Eric Sink
Joel Spolsky
Des Traynor

Aggregated Links

programming.reddit.com
dzone
dot net kicks

Human Link Machines

interesting finds
a continuous learner's weblog
arjan's world
n links today
new and notable
morning coffee
learning .net
weekly link post
(my del.icio.us account)

LinkedIn profile
 
home .: about .: sign up .: sitemap .: secretGeek RSS .: © Leon Bambrick 2003 .: privacy

home .: about .: sign up .: sitemap .: RSS .: © Leon Bambrick 2003 .: privacy