Excel service + DCL + connect to external data

It is great to use Excel to dynamically obtain external databases from time to time, synchronize with databases, and then use Excel webpart to display the data perspective?

First, you need to create DCl and then create a common document library. For more information about how to configure trusted data, see the previous article.Article.

Then we need to read the database this time, so we need to configure the Excel services trusted Data Connection Library, or we need to go to SSP.

Add link. This link is the address of your DCL library. It is very important to configure it...

First, create an Excel file, and then data-> from other sources-> from SQL Server

Select Service start

Next step
File Name: configure the connection to your DCL connection.

Then complete

OK

Go to your DCl and check whether the configuration is successfully added ,,

Then you need to start the process approval here and change the process to be finalized.

Go to the Excel file and select data> existing connection> OK
The configuration is as follows:

Then release the file, but the document library to be released is not released to DCl during the release. This release is the same as the previous release. I will not release it here.

In fact, at this time, the Excel data has been synchronized with the SQL data!

To the end, you need to modify
Mode
Stsadm-o set-ecssecurity-accessmodel delegation-SSP sharedservices1 (the default access model is trusted subsystem)
Stsadm-O execadmsvcjobs

Add an Excel webpart and configure the webpart.