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