Excel Services part 10: Data Connection Libraries, or connecting to databases made easy, manageable, and secure
Excel 服务第十部分：数据连接库，更简单，更易管理，更安全的数据连接

In the past few posts I have talked about all the work we have done to make managing, sharing, and securing your Excel workbooks better using SharePoint and Excel Services. Today, I am going to cover a new feature that provides management, sharing, and security of data connections – the Data Connection Library (DCL).
过去几篇文章里我们已经讨论过所有使用SharePoint和Excel服务以实现对Excel工作簿更好的管理、共享以及安全的方法。今天，我将要介绍一个可以对数据连接实现管理、共享和安全性的新功能－－数据连接库DCL（Data Connection Library）。

What is a Data Connection Library?
A Data Connection Library (or DCL) is a new type of SharePoint library (much like a document library) that provides a place to store, share, and manage connection files. By connection files, I mean Office Data Connection (ODC) files which contain all the information and parameters needed to form a data connection, such as server name, OLAP cube or table name, and query (note – ODC files are not a new feature – they were introduced in Excel 2002). Since the DCL is a library in SharePoint, it comes with all the great SharePoint features you would expect – such as workflow support, file approval, library level/item level security, and sorting filtering based on metadata. You can create a DCL the same way you create any library, and DCLs can be created almost anywhere in SharePoint e.g. on a portal, team site, etc. Here is what a DCL looks like in SharePoint 12.
什么是数据连接库？
数据连接库（DCL）是一种新的SharePoint库，很像一个文档库，它提供了一个存储、共享以及管理连接文件的空间。连接文件，这里是指一个包含了用于构建一个完整数据连接的信息和字段（例如：服务器名，OLAP CUBE,表和查询等）的ODC（Office Data Connection）连接文件（注：ODC文件是在Excel 2002中被引入的）。鉴于DCL是一个SharePoint的库，正如你所期望的一样，它也带来了SharePoint的所有强大功能，像工作流的支持，文档的签入签出，库或项目级的安全性，基于元数据的归类和过滤。你可以像创建任何库一样的创建一个DCL文件，此外，DCL可以创建在SharePoint中几乎任何地方，例如：一个门户，工作组站点等等。下面是一幅SharePoint 12中DCL的样子：

Even though the DCL reuses the library concept in SharePoint, it is much more valuable than just a document library full of connection files – this is because of how Excel interacts with the DCL. Let’s take a look at that and see how the DCL and Excel 12 solve a few problems.
虽然，DCL再次使用了SharePoint库的概念，但它比一个单纯的连接文件的文件库有价值的多，这是Excel和DCL的互动机制决定的。让我们看看DCL和Excel 12如何解决一系列的问题。

Connecting to databases made easy …
Setting up a connection to a database in Excel is a task that many users struggle with – for example, if you want to connect to an ODBC datasource or SQL Server Analysis Services cube, users must know server names, cube names, table names, what type of connection to create, user credentials, etc. Lots of clicks and knowledge are required.
更简单的数据库连接…
在Excel中建立数据库连接，是很多用户的努力要完成的任务－－例如：如果你想连接一个ODBC数据源或者一个SQL Server Analysis Services cube，用户必须知道服务器名称，cube名称，表名称，想要创建的连接类型，用户凭证等等。这需要太多的步骤和相关的知识。

Excel 12 and DCLs make connecting to databases a much simpler, faster activity. Users will simply need to know what data they want to work with, and that’s pretty much it. Let’s take a look at an example of getting started with a PivotTable connected to a database in Excel 12.
Excel 12和DCL让数据库连接变得更加简单和快速。用户需要知道的全部内容就仅仅是他要处理什么样的数据。让我们来看一个在Excel 12中以数据透视表连接到数据库的例子。

To connect to a database (or other external data source like a web query) in Excel 12, users will use the Data tab. Here is a shot of the Data tab in the beta build (note, this is not the final UI we will ship).
要在Excel 12中连接到一个数据库（或者其它像web查询一样的外部数据源），用户要使用Data标签。下面是一个beta版中数据（Data）标签的截图（注：这并不是最终的界面）。

One of the buttons on the Data tab is the “Existing Connections” button. To connect to the database they want to use for their PivotTable, the user will start by pressing this button. When they do, they see a new dialog (“Existing Connections”) which lists the connections that are stored in the DCL.
数据标签中有一个已有连接（Existing Connections）的按钮。如果要连接到用于该透视表的数据库，点击该按钮。之后，就可以看见一个新的对话框（Existing Connections）显示了DCL中存储的连接列表。

上一篇：excel vba教程：列表样式（一） 下一篇：excel表格制作教程：制作Excel斜线表头

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。