Setting Up BIC Sage Intelligence Reporting Using Evolution Anywhere

Introduction

This guide provides step-by-step instructions for setting up BIC Sage Intelligence Reporting using Evolution Anywhere. A shared network drive (mapped drive) must be used instead of a file path in the repository.

Creating an Online File Share Drive

One effective way to find the TCP port number is by using the SQL Server Configuration Manager. Follow these steps:

Step 1: Accessing SQL Server Configuration Manager

Open Evolution Anywhere on the server.
Hover the mouse cursor over the “New” button, select “Server,” and then choose “File Share Ver 2.”

Step 2: Configuring the New File Share

A new file share tab will appear on the right of the screen.
Click on the new file share to edit the name and start the service.
Once you click on “Start,” the following fields will populate: Network Path, Username, and Password.

Step 3: Mapping the Network Drive on the Server

Open File Explorer on the server.
Right-click on “This PC” and select “Map Network drive.”
Choose the appropriate drive letter (for this example, use drive letter Q:).
Copy the Network Path provided in Evolution Anywhere as the folder.
When prompted for a Username and Password, use the details provided in Evolution Anywhere. Select “Remember my Credentials.”
The new mapped drive will now appear in File Explorer.

Step 4: Copying EvoBicMetaData Folder

Locate the current EvoBicMetaData folder under the C: drive.
Copy this folder to the new mapped drive.

Step 5: Configuring Sage 200 Evolution

Open Sage 200 Evolution and log in.
In the Sage 200 Evolution system tree, select “Sage Evolution Administration.”
Select “System Configuration” and open “System Wizard.”
Select the “Repository” tab and enter the mapped drive address: Q:\EvoBicMetadata.
Click “Next” and then “Finish.”
Close Sage 200 Evolution and log back in for the changes to take effect.

Step 6: Mapping the Network Drive on Workstations

Map the network drive on all workstations using the same network path and drive letter (Q:) used on the server to complete the setup.

Troubleshooting Connection Issues

If you are unable to connect to the mapped drive from a workstation, it may be due to restrictions from your ISP. Vodacom is one ISP known to have such restrictions. To resolve this issue, refer to the guide on obtaining an unrestricted APN from Vodacom.