高頓網(wǎng)校友情提示，*7那曲會計繼續(xù)教育網(wǎng)上總結信息Excel2007新知-數(shù)據(jù)連接庫，更簡單、更易管理、更安全的數(shù)據(jù)連接等內(nèi)容公布如下：
　　Excel Services part 10: Data Connection Libraries, or connecting to databases made easy, manageable, and secure
　　Excel 服務第十部分：數(shù)據(jù)連接庫，更簡單，更易管理，更安全的數(shù)據(jù)連接
　　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).
　　過去幾篇文章里我們已經(jīng)討論過所有使用SharePoint和Excel服務以實現(xiàn)對Excel工作簿更好的管理、共享以及安全的方法。今天，我將要介紹一個可以對數(shù)據(jù)連接實現(xiàn)管理、共享和安全性的新功能－－數(shù)據(jù)連接庫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.
　　什么是數(shù)據(jù)連接庫？
　　數(shù)據(jù)連接庫（DCL）是一種新的SharePoint庫，很像一個文檔庫，它提供了一個存儲、共享以及管理連接文件的空間。連接文件，這里是指一個包含了用于構建一個完整數(shù)據(jù)連接的信息和字段（例如：服務器名，OLAP CUBE,表和查詢等）的ODC（Office Data Connection）連接文件（注：ODC文件是在Excel 2002中被引入的）。鑒于DCL是一個SharePoint的庫，正如你所期望的一樣，它也帶來了SharePoint的所有強大功能，像工作流的支持，文檔的簽入簽出，庫或項目級的安全性，基于元數(shù)據(jù)的歸類和過濾。你可以像創(chuàng)建任何庫一樣的創(chuàng)建一個DCL文件，此外，DCL可以創(chuàng)建在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.
　　更簡單的數(shù)據(jù)庫連接...
　　在Excel中建立數(shù)據(jù)庫連接，是很多用戶的努力要完成的任務－－例如：如果你想連接一個ODBC數(shù)據(jù)源或者一個SQL Server Analysis Services cube，用戶必須知道服務器名稱，cube名稱，表名稱，想要創(chuàng)建的連接類型，用戶憑證等等。這需要太多的步驟和相關的知識。
　　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讓數(shù)據(jù)庫連接變得更加簡單和快速。用戶需要知道的全部內(nèi)容就僅僅是他要處理什么樣的數(shù)據(jù)。讓我們來看一個在Excel 12中以數(shù)據(jù)透視表連接到數(shù)據(jù)庫的例子。
　　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中連接到一個數(shù)據(jù)庫（或者其它像web查詢一樣的外部數(shù)據(jù)源），用戶要使用Data標簽。下面是一個beta版中數(shù)據(jù)（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.
　　數(shù)據(jù)標簽中有一個已有連接（Existing Connections）的按鈕。如果要連接到用于該透視表的數(shù)據(jù)庫，點擊該按鈕。之后，就可以看見一個新的對話框（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.
　　接著，用戶只要簡單的選中要使用的連接，然后單擊打開。這時，就可以看見另一個對話框詢問將要如何使用該數(shù)據(jù)。
　　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會查看用戶選定數(shù)據(jù)庫并且僅提供特定數(shù)據(jù)庫的可用選項（例如：數(shù)據(jù)源是一個SQL Server Analysis Server數(shù)據(jù)庫，不能在Excel 12中像表一樣顯示出來，這種情況下，這個選項就不可用了）。這樣，用戶只需要輕松的點一下OK就可以在Excel 12中得到一個連接到數(shù)據(jù)源的透視表了。所有的操作只需要點擊3到4次鼠標。
 　　　　
　　掃一掃微信，學習實務技巧
　　　
　　高頓網(wǎng)校特別提醒：已經(jīng)報名2014年財會考試的考生可按照復習計劃有效進行！另外，高頓網(wǎng)校2014年財會考試高清課程已經(jīng)開通，通過針對性地講解、訓練、答疑、模考，對學習過程進行全程跟蹤、分析、指導，可以幫助考生全面提升備考效果。