![]() If the data connection details for a data source change, an administrator only need update one ODC file. Workbook authors can use existing connections without having to create queries and connection strings. Linked connections can be centrally stored, managed, audited, shared and access to them can be controlled by using a SharePoint document library. Embedded connections require little administrative overhead to support. Choose the one that best suits your scenario.Ĭomparison of data connections for Excel Online Connection typeĪll connection information is stored in the workbook. Optionally, some metadata required to retrieve external dataĮach kind of connection has its advantages and drawbacks discussed here. odc file that is also stored in the same SharePoint Server farm as the workbook. To use a linked connection, a workbook must reference an. ![]() Linked connections are stored externally to a workbook in Office Data Connection (ODC) files. ![]() Data connections for Excel Online workbooksĮxcel Online workbooks use one of two kinds of connections:Įmbedded connections are stored as part of the Excel workbook. Other data sources use a connection string usually consisting of a user name and password. To connect to the data source, Excel Online uses a specific data provider for each data source.Ĭonnecting to a SQL Server data source can be done by using either:Ĭonnecting to an Analysis Services data source is done by using Windows authentication. The following data sources are supported in Excel but not in Excel Online:Ĭonnecting to external data with Excel OnlineĮxcel Online can connect to various external data sources, including SQL Server, Analysis Services, and custom OLE DB/ODBC data providers. Varies per data source, typically a user-name and password pair stored in the connection string. One of: Windows authentication (integrated security) using Kerberos Constrained Delegation using Secure Store SQL Server Authentication Windows authentication (integrated security) using Kerberos Constrained Delegation using Secure Store using the EffectiveUserName connection string property For data sources that support more than one authentication method, data connections must specify which one to use.ĭata sources and authentication methods for Excel Online Data source Which authentication method Excel Online can use to retrieve data depends on the type of the underlying data source, as outlined in the following table. ![]() In the case of a workbook, Excel Online authenticates to the data source on behalf of the user who is viewing it in order to refresh the data to which the workbook is connected. Retrieving data from a data source requires a user to be authenticated by the data source and then authorized to access the data that is contained therein. Summary Learn how Excel Online supports connections with SQL Server Analysis Services (SSAS), SQL Server databases, and OLE DB and ODBC data sources. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |