Friday, September 10, 2010

SharePoint Connectivity using Enterprise Enabler

Enterprise Enabler allows users to read and write data to and from multiple data sources using SharePoint BCS (Business Connectivity Services).

Enterprise Enabler uses application definition tool to create schema that will be useful to connect to external data sources.

Generating EE Application Definition.

EE Application definition Tool is used to create application definition for SharePoint 2010, SharePoint 2007 and wss.

Prerequisites

1. Source template or map.

2. Source Template or Destination Template should have only one block (Data will be shown only from one block).

3. Destination template block name will be used as the entity name in application definition.

4. Created objects should be deployed to the server. (Go to deployment manager and deploy the objects)

Steps to Create Application Definition.

1. Log in to Enterprise Enabler Studio.
clip_image002
2. Create templates and maps as required.
clip_image004
3. Deploy these objects to server by Clicking Deployment Manager menu button under Server menu.
clip_image006
clip_image008
4. Go to File -> New -> EE App Def (It will open following window)
clip_image010
clip_image012


5. Give a valid name for application definition. (This will be used in the connection string as Initial Catalog)

6. Click on Add Entity to create Entity.

a. If the map is already created, you can select that map to add entity.

b. If source template is available, you can create map automatically.

c. If CRUD operations are needed, you can auto generate update maps by checking the Auto Generate Edit Maps option.

d. Entity name will be selected from the destination template block name.
clip_image014
clip_image016
7. Once everything is ready, click on Generate Xml button to generated Business Data Catalog Xml file for 2007 or 2010.
clip_image018
clip_image020
8. For SharePoint 2010, definition can be automatically deployed to server if the logged in user has administrative privileges. For auto deployment, click on Deploy button in SharePoint 2010 section. It will show the following screen.
clip_image022
9. If user has administrative privileges, it will ask for the SharePoint admin site url to which the definition should be deployed.
clip_image024
10. Give the name of the Admin site url and click on ok button to complete the auto deployment.