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.
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.
Open Excel 2007 and select the Data tab.
Select whether you would like to connect ...