SData installation and configuration

Summary

This article explains how to install and configure SData for Sage 100 ERP. It covers Windows Server, IIS, SQL Server, Sage 100 ERP, and SData Adapter configuration

Resolution

CAUTION: The following procedure requires in-depth knowledge of database engines for your Sage product, such as Microsoft SQL Server, Pervasive SQL, and MySQL. Sage can't assist with database administration and isn't responsible for errors resulting from database changes. Back up your system and application databases required for a complete restore. Consider contacting a certified consultant or your database administrator for assistance.
CAUTION: This solution needs advanced Operating System knowledge. Consult your system administrator for help. Sage isn't liable for issues caused by improper changes to the Windows Registry. Always back up your data before applying advanced solutions.

Caution: These steps require IIS and SQL Server administration experience. Sage can’t assist with IIS website configuration or SQL Server administration. 

Configure Windows Server

  1. Create a Windows user account with rights to read, write, and delete Sage data.
  2. Grant the account Read and Execute rights to the SData folder.
  3. Verify access to the default SData path:
    C:\Program Files (x86)\Common Files\Sage\SData\

Configure IIS

  1. Create a website in IIS.
  2. Add the ASP.NET 4.5 role to IIS.
    • Use ASP.NET 3.5 for older IIS versions.
  3. Add an SSL binding and a server certificate to the website.
    • You can use a self-signed certificate.
  4. Confirm that users can access the website through SSL.

Configure SQL Server (Sage 100 ERP Premium only)

  1. Create a SQL user that matches the Windows user account.
  2. Map the SQL user to the required MAS_xxx company databases.
  3. Assign db_datareader rights to the company databases.
  4. Assign db_datawriter rights if users need to write data to Sage 100 ERP Premium.

Example SQL script

   EXEC sp_addrolemember N'db_datareader', N'SdataUser'
Note: This script assumes that you selected the appropriate MAS_xxx database before running it. 

Configure Sage 100 ERP

  1. Open Modules, Library Master, Setup, System Configuration.
  2. Select the Security tab.
  3. Enable Enable Native SData Provider and Access within Role Maintenance.
  4. Select Accept.
  5. Open Modules, Library Master, Main, Role Maintenance.
  6. Create a role with access to the required modules.
    • Examples include Sales Order Entry and Sales Order Invoice Data Entry.
  7. Select the SData tab.
  8. Enable the required tables.
    • Sales Entry uses tables such as SO_SalesOrderHeader and SO_SalesOrderDetail.
  9. Select Accept, and exit Role Maintenance.
  10. Open Modules, Library Master, Main, User Maintenance.
  11. Create a user that matches the Windows and SQL credentials.
  12. Assign the role created earlier to the user.
  13. Select Accept.

Install the SData Adapter

  1. Run the SData Adapter installation from the root of the installation image.
  2. When prompted, enter the Windows user account created earlier.

Test the SData website

  1. Open the following URL, replacing the values with your environment details:
    https://cai100sdataiv/SData/MasApp/MasContract/ABX/AR_Customer
  2. Enter the SData user name and password.
  3. Confirm that a list of records appears.
Note: The system doesn’t prompt you when the Windows account lacks the required permissions. Verify the account rights if data doesn’t appear.

Need more help?

Chat now

 

Solution Properties

Solution ID
224924550063176
Last Modified Date
Thu Aug 27 14:45:30 UTC 2026
Views
0