jetlounge

SQL Server OLTP database

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

Set data source type to SQL Server.

Analysis Services database

data source=localhost;initial catalog=Adventure Works DW

Set data source type to SQL Server Analysis Services.

Report model data source

Server=http://myreportservername/reportserver; datasource=/models/Adventure Works

Specify the report server or document library URL and the path to the published model in the report server folder or document library folder namespace.

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 Designer computer and on the report server. For more information, see Defining Report Datasets for Relational Data from an Oracle Database.

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 Defining Report Datasets for Multidimensional Data from an SAP NetWeaver BI System.

Hyperion Essbase data source

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

Set the data source type to Hyperion Essbase. For more information, see Defining Report Datasets for Multidimensional Data from a Hyperion Essbase Database.

XML data source

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

Set the data source type to XML. The connection string is a URL to the XML document. For more information, see Defining Report Datasets for XML Data.