Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

Sage 100 API Offered by ROI Consulting

June 7, 2022 by Wayne Schulz

We’ve been asked numerous times about the ability to access an API for Sage 100. Until now the primary ways you would create an API-like experience with Sage 100 include:

  • Visual Integrator ( data import )
  • Scripting ( also known as Business Objects Interface or BOI )
  • Custom/Third-party synchronization tools such as In synch from ROI Consulting ( https://roi-consulting.com/ )
  • Custom programming
  • Sage 100 Office 365 Connector

Most Common Sage 100 “API”: Visual Integrator ( Importing )

The most common and easiest to upgrade is the data import ( Visual Integrator ). Importing data can be somewhat automated through batch files and task schedule. Visual Integrator is an included component of most Sage 100 subscriptions.

Office 365: Still Early Days

The Office 365 is really cool but is limited. Sage continues to demo and develop for it so I would expect it to continue to expand as time goes on. It shows very well. It does require a dive into the Microsoft ecosystem of online apps and some technical skills to setup and configure. See Sage KB 92058 for details on the configuration of Microsoft.

eBusiness Web Services: Very Limited Support

Sage eBusiness Web Services is a module that can provide some limited access through an API. I do not believe they are doing any development work on it. No changes are expected. Here is a link to a website about Web Services, All for Sage e-Business Manager – e-Business Web Services (4ebm.com). This is part of Sages eBusiness Module which is a built in eCommerce Site. (Great, out of the box, module to get up and running with eCommerce) eBusiness hasn’t been changed in many years and the eCommerce has a late 1990’s look to it. It can be customized and developers do make changes to it.

Sage SDATA: Very Limited Support

Sage also has SDATA for Sage 100. It is not really being developed and is still in version 1 for Sage 100.

ODBC: Your Best Bet for Read-Only Access

ODBC can be used to query (read only) data from Sage 100. In most cases this is your easiest way to access Sage tables provided you only need read-only access. Traditional ( Providex-based ) ODBC does not offer write-back support. A full set of file layouts for Sage 100 is available online to get you started.

ROI Consulting: API Access to Sage 100

During a conference in May 2022 ROI Consulting demonstrated a new Sage 100 API access they had created. ROI has been heavily involved with integrations between Sage 100 and various third-party applications ( primarily websites ).

Now ROI Consulting have created a Sage 100 API to provide direct access to the Sage 100 data tables with less need to learn any of the above tools.

According to the ROI Consulting website:

With our new IN-SYNCH Connector API, we have created a series of endpoints that we establish ahead of time to allow companies to interact with our connector and the database, thus allowing the developer to now push and pull data via these endpoints. They can control the access without needing to host a database and they do not need to have extensive knowledge of the Sage 100 table structure.  

The Connector API allows us to work with the end user and/or developer to choose the best option for architecture, requirements, etc. A hybrid may even be used as we have users with flat files that transfer along with an endpoint to connect with their solution. For example, suppose your online cart does not do customer-specific pricing. With the Connector API, your developer can ask for the price of 10 widgets for customer C100 and we can return the price that would appear in Sage.

For more information on the ROI Consulting API Access for Sage 100 please contact them directly at – kimz@roi-consulting.com or visit their website Sage 100 Integration Using Application PRogramming Interface ( API ).

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Error 15 CI_ eFilingCommon.pvc 247 when generating Aatrix Form
  • Sage 100 2023 e-File Payroll Tax Deadlines
  • Beware Fake Sage Support Sites
  • When Is Sage 100 Payroll 2.24 for 2023 Due?
  • Which Crystal Reports Versions Are Compatible With Sage 100 (As of October 2023)?
  • Windows Server 2012 R2 No Longer Supported with Sage 100
  • How can I see the tax tables being used for Payroll taxes?
  • Sage TLS 1.2 Change Deferred For Some Through March 2024
  • Sage 100 Updates for 2023: The Year-End Edition You Can’t Afford to Miss
  • Summit Hosting Rebrands as Summit

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

sage 100 email newsletter
Schulz Says Email NewsletterSent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.