How do I create an ODC file office data connection?

How do I create an ODC file office data connection?

Create an Office Data Connection (ODC) file

1. Do one of the following:
2. Save the connection information to a connection file by clicking Export Connection File on the Definition tab of the Connection Properties dialog box to display the File Save dialog box, and then save the current connection information to an ODC file.

How do I create an ODC file?

To create and publish an ODC file In Excel, on the Data tab, in the Get External Data section, click From Other Sources, and then select your data source. Complete the wizard to create a data connection to your data source.

What kind of file is ODC?

Office Data Connection File
The ODC file extension is known as Office Data Connection File which was developed by Microsoft. The file format is a connection information file that contains properties to connect to, and retrieve data from an external data source or a Reporting Services Report.

How do I use ODC files?

To upload and use an . odc file

1. Open the library into which you want to upload the connection file.
2. On the Upload menu, click Upload document.
3. Click Browse.
4. Select the .
5. Click Open to select the file, click OK to save the selection.
6. In Content Type, select Report Data Source, and then click OK.
7. Point to a report.

What is a data source in SSRS?

In SSRS, Data Source (DS) is a connection setting that is used to connect with underlying Databases or Data Warehouses. The SSRS Shared data source is a combination of Provider name, Server instance Name, Database Name, and Database credentials.

How to create data connection strings in Report Builder?

For more information about the configurations needed to connect to these data source types, see the specific data connection article under Add Data from External Data Sources (SSRS) or Data Sources Supported by Reporting Services (SSRS).

How to manage data sources in report server?

Data source connection properties are always defined with the report or model when you create it, but can be independently managed after the report or model is published to a report server.

How to use office data connection with reports?

Use an Office Data Connection (.odc) with Reports. For limited scenarios, you can use an existing Office Data Connection (.odc) file to provide connection information to a Reporting Services report. An .odc file can be used in place of an .rsds file when you create a shared data source.

What do connection strings mean in SSRS report?

For a full list of data sources and versions Reporting Services supports, see Data Sources Supported by Reporting Services (SSRS). Connection strings are the text representation of connection properties for a data provider.