那曲会计继续教育网：Excel2007新知-数据连接库，更简单、更易管理、更安全的数据连接

高顿网校友情提示，*7那曲会计继续教育网上总结信息Excel2007新知-数据连接库，更简单、更易管理、更安全的数据连接等内容公布如下：
　　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中存储的连接列表。

　　One point to note is that these connections all have friendly names and non-technical descriptions, so it is easy for users to choose the connection they want. Those names and descriptions are provided by the person(s) who set up the DCL and populate it with ODC files – more on this below.

　　有一点需要要说明的是，所有的这些连接都有一个友好的名字和一些非技术性的描述，所以你可以很容易的选择你想要的连接。那些名称和描述都是由设置DCL和存储ODC文件的人提供的，关于这一点，下面将有详细的阐述。

　　Next, the user simply needs to highlight the connection they want to use and press open. At this point, they see another dialog which allows the user to tell Excel 12 what to do with the data.

　　接着，用户只要简单的选中要使用的连接，然后单击打开。这时，就可以看见另一个对话框询问将要如何使用该数据。

　　Another point to note is that Excel 12 looks at the connection the user has selected and only offers options that are possible for a particular database (for example, in this case, the datasource was a SQL Server Analysis Server database, which cannot be represented in Excel 12 as a table, so that option is disabled). At this point, the user needs to simply press OK and they have a PivotTable connected to data in Excel 12. That’s a total of 3-4 clicks.

　　另外一点要说的是，Excel 12会查看用户选定数据库并且仅提供特定数据库的可用选项（例如：数据源是一个SQL Server Analysis Server数据库，不能在Excel 12中像表一样显示出来，这种情况下，这个选项就不可用了）。这样，用户只需要轻松的点一下OK就可以在Excel 12中得到一个连接到数据源的透视表了。所有的操作只需要点击3到4次鼠标。

 　　　　

　　扫一扫微信，学习实务技巧

　　高顿网校特别提醒：已经报名2014年财会考试的考生可按照复习计划有效进行！另外，高顿网校2014年财会考试高清课程已经开通，通过针对性地讲解、训练、答疑、模考，对学习过程进行全程跟踪、分析、指导，可以帮助考生全面提升备考效果。