O'Reilly logo

Microsoft® SharePoint® Server 2007 Bible by Simeon Cathey, Wayne Tynes, Wynne Leon

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing Data Sources, Models, and Data Connections

The Report Center is designed to store data connections and data sources so that users can access those data sources without having to know all the details about server, database, and security settings. There are three types of data connections that are supported by the Report Center:

  • Office Data Connection files (ODC): The ODC definitions enable Office applications to connect to your SQL Server, OLEDB, ODBC, or XML data sources.

  • Universal Data Connection files (UDC): Connection file format for applications such as InfoPath to store their data connections. In an InfoPath scenario, the UDC allows browser forms to work across domain boundaries. UDC files are XML files with a particular namespace and schema.

  • Reporting Services Data Sources (RSDS): The Reporting Services Data Sources is a new file format for data sources that are designed in SharePoint and are used to support models, reports, and report subscriptions.

Creating and uploading data connections

Data connections are stored in the data connection library for your Report Center site. We use Excel to create the (ODC) file and then upload that to a Data Connection library. You can configure whether you want to specify credentials for the connection or use Windows authentication so that the user’s credentials are necessary for access to the data.

To create an ODC file, follow these steps.

1.
Open Excel 2007 and select the Data tab.
2.
Select whether you would like to connect ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required