• Article

Example Connections (Report Builder 2.0)

A data source connection specifies the source of data that you want to use in your report. In Report Builder 2.0, when you are connected to a report server, you can use shared data source definitions that specify the connection information for you.. These data sources are stored on the server and managed by your report server administrator. You do not need to provide any other information to use a shared data source.

If you create an embedded data source within your report, you must specify the connection information. The connection information stored in a report varies depending on the data source type. You can provide connection information in the Data Source Properties dialog box, which you can open from the Report Data pane by selecting New, and then Data Source. For more information, see How to: Create a Data Source Reference (Report Builder 2.0).

Common Connection String Examples

The following table lists examples of connections strings for various data sources.

Data source

Example

Description

SQL Server database on the local server

data source="(local)";initial catalog=AdventureWorks2008

Set data source type to SQL Server. For more information, see How to: Retrieve Data from a SQL Server Data Source (Report Builder 2.0).

SQL Server Instance

database

Data Source=localhost\MSSQL10.InstanceName; Initial Catalog= AdventureWorks2008

Set data source type to SQL Server.

SQL Server Express database

Data Source=localhost\MSSQL10.SQLEXPRESS; Initial Catalog= AdventureWorks2008

Set data source type to SQL Server.

Analysis Services database on the local server

data source=localhost;initial catalog=Adventure Works DW 2008

Set data source type to SQL Server Analysis Services. For more information, see How to: Retrieve Data from an Analysis Services Cube (MDX) (Report Builder 2.0).

SQL Server 2000 Analysis Services server

provider=MSOLAP.2;data source=<remote server name>;initial catalog=FoodMart 2000

Set the data source type to OLE DB Provider for OLAP Services 8.0.

You can achieve a faster connection to SQL Server 2000 Analysis Services data sources if you set the ConnectTo property to 8.0. To set this property, use the Connection Properties dialog box, Advanced Properties tab.

Oracle server

data source=myserver

Set the data source type to Oracle. The Oracle client tools must be installed on the Report Builder 2.0 computer and on the report server. For more information, see How to: Retrieve Data from an Oracle Data Source (Report Builder 2.0).

SAP NetWeaver BI data source

DataSource=http://mySAPNetWeaverBIServer:8000/sap/bw/xml/soap/xmla

Set the data source type to SAP NetWeaver BI. For more information, see How to: Retrieve Data from a SAP NetWeaver BI Data Source (Report Builder 2.0).

Hyperion Essbase data source

Data Source=https://localhost:13080/aps/XMLA; Initial Catalog=Sample

Set the data source type to Hyperion Essbase. For more information, see How to: Retrieve Data from a Hyperion Essbase Data Source (Report Builder 2.0).

Teradata data source

data source=<NN>.<NNN>.<NNN>.<N>;

Set the data source type to Teradata. The connection string is an Internet Protocol (IP) address in the form of four fields, where each field can be from one to three digits. For more information, see How to: Retrieve Data from a Teradata Data Source (Report Builder 2.0).

Teradata data source

Database=<database name>; data source=<NN>.<NNN>.<NNN>.<N>;Use X Views=False;Restrict to Default Database=True

Set the data source type to Teradata, similar to the previous example. Only use the default database that is specified in the Database tag, and do not automatically discover data relationships.

XML data source, Web service

data source=http://adventure-works.com/results.aspx

Set the data source type to XML. The connection string is a URL for a web service that supports Web Services Definition Language (WSDL). For more information, see Creating Report Datasets from XML Data (Report Builder 2.0).

XML data source, XML document

https://localhost/XML/Customers.xml

Set the data source type to XML. The connection string is a URL to the XML document.

XML data source, embedded XML document

Empty

Set the data source type to XML. The XML data is embedded in the report definition.