# SData Installation

SData Setup & Communication Ports:

Sage 100 SData, a standard Web Service API provided by Sage itself, is essential to configure your Salesforce Org. The GUMU™ Integration uses a Sage 100 SData URL to fetch records from Sage 100 and synchronize them to Salesforce. The SData Web Service URL must be mapped to a domain or subdomain accessible over the web. Salesforce is a cloud-based system and cannot connect to an on-premise system, i.e. Sage 100, without the data port exposed through a static IP. The domain or subdomain will be connected/mapped using Secure Sockets Layer (SSL). This ensures a secure connection to the port of a system that connects to the Sage 100 ERP SData Web Service.

For installing SData, you need the following components:&#x20;

* Pre-installed Sage 100 application&#x20;
* IIS application
* SSL certificate&#x20;

**Note:** The minimum requirement for installation of SData is the installation of the Sage 100 Application server. The data server and Sage 100 Application server can also be on different servers if it allows us to connect the Sage 100 ERP System with the GUMU™ Integration.&#x20;

\*SData installation is typically done by your Sage consultant or IT team, however if you prefer that we do the SData install for you let us know and we can build it in to your package.&#x20;

Once you have pre-installed the Sage 100 SData application, the IIS application and SSL certificate you can follow the steps below to install SData on your system:

1. Navigate to the Sage 100 ERP folder located on your system.
2. Click on autorun and select your Sage 100 option (Standard, Advance & Premium) to proceed.

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2FVD5UjfknentdhOsTCNh2%2F1.%20Autorun.png?alt=media&#x26;token=404ead68-6376-4bd9-b9f6-828bddd54d43" alt=""><figcaption></figcaption></figure>

3. Next, select Productivity Applications.

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2FanZ2Qjl7sc9v1BJDgOUV%2F2.%20Productivity%20App.png?alt=media&#x26;token=6e445a3a-f485-4981-b40f-d84f9987d071" alt=""><figcaption></figcaption></figure>

4. Select **Install the Native SData Provider Adapter** from the Sage 100 installation setup.

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2FwbP97Cx4xHa0ff7InNYk%2F3.png?alt=media&#x26;token=fae1fa01-cde1-40b5-9dd7-cb245ea48988" alt=""><figcaption></figcaption></figure>

5. Navigate to IIS Manager, expand the Site folder, and then SData Folder.

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2F4ppUJTcAC2L4CNLchKzc%2F4.png?alt=media&#x26;token=cc6a2661-cf9f-4e12-9099-8a44a24161fa" alt=""><figcaption></figcaption></figure>

6. Click on **MasApp** in the Connections Pane.
7. Click on **Basic Settings** in the Actions Pane on the right side of the screen.
8. Click on **Connect as**, select **Specific user** and click **Set** (it will ask for credentials and Windows domain), fill in User name and Password and then click **OK.**

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2FssMDgH5G7o5BKvULh5iC%2F5.png?alt=media&#x26;token=c2ba4a03-6acb-41a2-bec5-2271de4b0fc6" alt=""><figcaption></figcaption></figure>

9. Click on **Advanced Settings** in the Actions pane on the right side of the screen.
10. Check Application Pool Name, Virtual Path & Physical Path Credentials (it should be defined as Windows Domain\Username entered in the Basic Settings).
11. If the SSL certificate is installed the Enabled Protocols should be set to **https** (or **http** if no SSL certificate is installed) and click **OK.**

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2F8ry4XwbRoAY4dhmKWI7T%2F6.png?alt=media&#x26;token=370683a8-1e8f-428d-8785-cf10ad744322" alt=""><figcaption></figcaption></figure>

12. Click on **Application Pools** in the Connections pane.
13. Select SData App Pool, set Enable 32-Bit Applications to **TRUE.**

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2F6NHidG9qJX7LK3N6UkPG%2F7.png?alt=media&#x26;token=6d5d5e45-0f9e-41be-8b80-3186d0b388db" alt=""><figcaption></figcaption></figure>

14. Once the SData provider is installed, login to Sage 100.
15. Navigate to the Library Master > Setup > System Configuration and check the **Enable Native SData Provider and Access within Role Maintenance** checkbox.

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2FJoQYT59RbrvXnVsJCNdv%2F8.png?alt=media&#x26;token=da60b28f-f3cc-48ed-8e53-9d41d32652f0" alt=""><figcaption></figcaption></figure>

16. Once the above checkbox is checked, the **Security** tab gets enabled in Sage’s **Role Maintenance,** provide rights to the corresponding resources you wish to access through SData.

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2F7xgsP7LE6YQAYHwYDNXm%2F9.png?alt=media&#x26;token=bec2e4bc-3812-4cad-8529-69268ec84ca1" alt=""><figcaption></figcaption></figure>

17. To access Sage 100 data externally through SData, navigate to Library Master > Main > Company Maintenance > **Preferences** tab and check the **Allow External Access** checkbox (these settings will allow the GUMU™ to access the Sage 100 data).

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2FyHZLH8TodgmEKYlVnl6N%2F10.png?alt=media&#x26;token=1b498b10-2807-48f2-8e39-df65b7933360" alt=""><figcaption></figcaption></figure>

18. To check whether the SData URL is working, navigate back to IIS Manager, go to MasApp, and click on ***Browse\*:80(http).***

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2FtcSxxIvK8VFdwwJLmpAq%2F11.png?alt=media&#x26;token=7c9a1a89-41f4-446e-af32-8fe1866c0956" alt=""><figcaption></figcaption></figure>

19. Once everything is set up, you should be able to access the Sage data using the web service URL

[http://localhost/SData/MasApp/MasContract/ABC/AR\_Customer](http://localhost/SData/MasApp/MasContract/ABC\(yourCompanyCode\)/AR_Customer),  where ABC is your Company Code.

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2FRAXFBLSKYYQniyAb2ZVM%2F12.png?alt=media&#x26;token=90fe0803-b573-4bb3-9607-704925119e00" alt=""><figcaption></figcaption></figure>
