Versions Compared

Version Old Version 1 New Version Current
Changes made by

Matthew Garrett

Sam Pitts

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
FWECM RHEAD
FWECM RHEAD
nopaneltrue

Table of contents

Table of Contents
minLevel1
maxLevel6
outlinefalse
stylenone
typelist
printabletrue

Overview

Framework Cloud Connector is a stand-alone IIS service, that is deployed on-premise to connect Framework ECM to the Perspective Systems to allow use of the “SupplierConnect” application. This includes sending, receiving and updating notifications issued by the office, and updating office data with call up information made by site supervisors.

...

Expand
titleServer Installation - Server Manager

From Server Manager, select the “Add Roles and Features” from the Manage option.

image-20240517-063635.png

Press Next on the Before You Begin page.

Select the Role-based on feature-based installation option.

image-20240517-063734.png

From the server selection, choose the destination server for the installation, press Next.

image-20240517-063835.png

From the server roles list, select the Web Server (IIS) role, and when prompted, select “Include management tools (if applicable), and press Add Features.
Press next to add additional features.

image-20240517-063955.png

image-20240517-064001.png

From the features list, tick the ASP.NET 4.7 (or later) option that is available.

image-20240705-023612.png

From the list of role services, add any of the ticked services.

image-20240517-064101.png

image-20240705-041727.png

image-20240705-041454.png

Add the following from the “Application Development” section.

image-20240705-041651.png

Press Next and finalise the addition of the roles to the server.

Creating a SQL Login for the Connector

Open SQL Server Management Studio and connect to the production/test SQL Server.

Note: If you have an existing SQL Login that may already be in use from the ‘SupplierConnect’ portal, this can be used, and this step can be skipped.

Expand
titleSQL Management Studio - Creating a New Login

  1. Open the Microsoft SQL Server Management Studio application.
    Note: These steps can be performed on any computer/server that has access to Management Studio

  2. Connect to the SQL Server that hosts the ‘FworkSQLEcm’ database

    image-20250122-000250.pngImage Added

  3. From the Folder list on the sidebar, right click on the Security option and select New → Login

    image-20250122-001123.pngImage Added

  4. Enter the required details on the General tab
    Ensure to record these details, as you will need them during the setup of the Connector.

    image-20250122-000504.pngImage Added

    1. Select the SQL Server authentication option

    2. Enter a Login name

    3. Enter a Password

    4. Untick the ‘Enforce Password Policy’ option

  5. From the User Mapping tab, select the FworkSQLEcm database, and tick the db_owner option

    image-20250122-000835.pngImage Added


    The minimum database security options are available here:
    Database Security Considerations - Framework - Confluence

  6. Press OK to create the SQL Authentication account

Create Web Site Folder and Set Access Rights for IIS Users

Navigate to the C:\inetpub\wwwroot directory, and create a new folder caed called “FworkCloudConnector”

...

Add Read/Write/Modify permissions for the built-in group “IIS_IUSRS”

...