Automating Master Data Loads

How to Configure BPM Connect to Process Dimensions in a Distributed Server Environment

The steps outlines how to configure BPM Connect to process dimensions in a distributed server environment. A environment is distributed if it has an Application and database Server separately.

Prerequisites
- Identify Database Sever
- Identify Application Server
- Get BPMCServices.zip file (located in BPMConnect\BPMC_IFramework\DTS folder)
- Get MbrProcess.dtsx file (located in BPMConnect\BPMC_IFramework\DTS folder)

Configuration Steps

1. DataProcessControl Web Application
a. Navigate to C:\Inetpub\wwwroot folder.
b. Backup DataProcessControl folder.
c. Open the Properties Window for the DataProcessControl website.
d. Select the Directory Security Tab
e. Edit the Authentication and access control
f. Enable anonymous access and click OK to close the Authentication Methods Window.
g. Click OK again to close the Properties Window.

2. BPMCServices.zip file
a. Unzip BPMCServices.zip file.
b. Copy unzipped BPMCServices folder to the C:\Inetpub\wwwroot folder.

3. Configure BPMCServices Web Application
a. Open Internet Information Services (IIS) Manager.
b. Navigate to the BPMCServices website.
c. Open the Properties Window for the BPMCServices website.
d. Select the Directory Tab (should be selected by default)
e. Click on the Create Button to create the web application.
f. Select BPMConnect for Application Pool.
g. Select the ASP.NET Tab
h. Change the ASP.NET Version to 2.0.XXXXX and click the OK Button.
i. Restart IIS.
j. Test BPMCServices Web App by browsing on the MbrRMtExecSrv.asmx file. You should see a Web Services Method Access Page.

4. MbrProcess.dtsx file
a. Copy MbrProcess.dtsx to the SQL Server Application store folder:
C:\Program Files\Microsoft SQL Server\90\DTS\Packages

5. MbrProcess.dtsx file
a. Copy MbrProcess.dtsx to the SQL Server Application store folder: