Creating Link Server for integrating multiple Sage X3 folders/servers

If a client is having Multiple Sage X3 folders/servers and wants to connect that new Sage X3 folder with a single instance of Sage CRM then, in that case, the user will have to -

Configure GUMU from Sage CRM with new Sage X3 folder details as mentioned in Chapter 1.

Create a Link server manually by using a VB Script file (I.e. CreateSQLLinServerForNewFolder). This file is located in the GUMU Installation directory (I.e. C:\Program Files (x86)\Greytrix\GUMU for Sage CRM - Sage X3). Assuming GUMU is installed at C drive. For creating a Link server for a different Sage X3 folder, the user will have to double-click on that file and will have to enter the below details.

1. Sage CRM SQL server name along with SQL instance name.

2. Sage CRM SQL Database name.

3. SQL username admin level.

4. SQL user password of the above user.

5. Sage X3 SQL server name along with SQL instance name.

6. Sage X3 SQL Database name.

7. SQL username admin level.

8. SQL user password of the above user.

9. Sage X3 folder name

It will create a new Link Server in Sage CRM SQL server with GUMUCRMX3_FolderName

Note: Please note that if Sage CRM and Sage X3 SQL are on a different server then both CRM and X3 SQL should be accessible from each other’s server.