Microsoft Office Tutorials and References
In Depth Information
User-Defined Functions Allowed
Set this if user-defined functions in ECS for workbooks under the trusted file locations are allowed.
Trusted Data Providers
ECS uses data providers that are trusted to access data from external data sources for use in Excel workbooks. There
are many data providers that are trusted natively. However, when you have to retrieve external data using custom data
provider information in the connection, you need to manually define the provider as trusted. Click on Add Trusted
Data Provider, and furnish the Provider ID, Provider Type (OLE DB, ODBC, or ODBC DSN), and Description values
(Figure 5-7 ). After adding the trusted data provider, use the Provider ID in the connection string.
Figure 5-7. Trusted Data Provider settings
Trusted Data Connection Libraries
You can set a SharePoint document library as trusted. Data connection files (*.odc) hosted in this document library
will be loaded by ECS for connecting to databases. To create a Trusted Data Connection Library, click on the Add
Trusted Data Connection Library link. Type the document library address where files will be saved, and fill in the
Description field as shown in Figure 5-8 .
Figure 5-8. Trusted Data Connection Library settings
Search JabSto ::