Databases Reference
In-Depth Information
Data Processing Extension
Connection
Command
Data Reader
Connect to Data Source
Data Source Connection
Create Data Source Command
Create Data Source Command
Data Source Command
Create Data Reader
Create Data Reader
Data Reader
Execute Reader
Execute Reader
Read Data
Read Data
Data Source
Report Data
Report Data
Figure 3-4
Let's take a look at some of the support providers in SQL Reporting Services 2005.
Supported Providers
Reporting Services supports the .NET managed providers as well as custom extensions for returning
data. The .NET managed providers include SQL Server, OLE DB, and Oracle. Managed providers take
full advantage of the .NET Framework. Using these providers, users should be able to connect to just
about any data source. Let's take a look at some of the common Reporting Services data extensions.
SQL Server Provider
Using the SQL Server provider, users can retrieve data from SQL Server tables, stored procedures, views,
and user-defined functions. The SQL Server managed provider is optimized to connect to SQL Server.
Extra layers such as OLE DB and ODBC have been removed to improve performance.
When using the SQL Server provider, users can also take advantage of the SQL Query Designer. This
designer allows users to visually build SQL queries taking away some of the complexities of the lan-
guage. The SQL Server provider will work with both SQL Server 2000 and 2005.
Oracle Provider
Although Reporting Services uses SQL Server to store its metadata, you can use Oracle as a source for
your reports. Like the SQL Server managed provider, the Oracle provider is optimized for Oracle and
removes extra layers such as OLE DB and ODBC.
Search WWH ::
Custom Search