Home > SharePoint 2007 > Registry file to point to SharePoint Data Connection Library

Registry file to point to SharePoint Data Connection Library

We use SharePoint 2007 to host the centralized Data
Connection Library (DCL) to help the end users easily connect to SSAS cubes. From
the end users’ point of view, they don’t have to type server name, select cube
etc every time they are trying to query against SSAS. Instead, they will click
the “Existing Connection” to browse the specific folder and select the specific
Pre-defined DCL.

To do so, we need to create a registry file (.reg) and
publish onto the SharePoint. End users need to click the link and press “OK” to
import the .reg file. The below code is what you should have in the registry
file. The "http://MOSS2007/Reports/BI/Data
Connections”
is the actual URL to the DCL we setup in SharePoint. You
can write multiple entries here if you do have more than one DCL.

Once you copy the code into a notepad and modify the URL
path, you can save it as a .reg file. Now it is ready to distribute.

/* Start of the code –don’t put this line in the .reg file. This is comment
only!
Windows Registry Editor Version 5.00



[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Server
Links\Published]


"Data Connection Library"="http://MOSS2007/Reports/BI/Data
Connections"

Advertisements
Categories: SharePoint 2007
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: