Connector API for Sage 100 Makes Custom Solutions Possible
You don’t have a cookie-cutter business (unless you sell baking supplies), so why settle for a cookie-cutter integration solution? Most companies would benefit from at least one integration between their Sage 100 ERP and another platform, whether that’s an e-commerce store, a CRM, or a client portal. Often, a solution like IN-SYNCH can provide that integration interface, but in unique situations, a more custom approach may be needed using an API for Sage 100.
If your company has its own developer team, you may be wondering whether you should partner with an integration expert or give your team the integration project. There are pros and cons to each choice—an expert partner may accomplish the integration more quickly, but the project will likely cost more. However, your developer team may not have the specialized knowledge necessary to create a smooth integration with a particular software without using an API.
In fact, in some cases, the decision might be made for you. Sage 100 ERP actually doesn’t have any built-in APIs. Instead, it relies on its Business Object Interface for data access. This is because Sage 100 doesn’t have a cloud-native architecture, so it cannot connect to modern web-based APIs.
The Third Option for a Sage 100 Custom Integrations
So, does that mean that your developers can’t ever create Sage 100 integrations? Thankfully, there’s a third option besides outsourcing the integration and using native APIs: our Sage 100 Connector API.
DSD’s Connector API (created by the IN-SYNCH team) allows your company’s developers to create their own custom Sage 100 integrations. We have created a series of endpoints that we establish ahead of time to allow companies to interact with our connector and the database without needing to host a database themselves. Unlike standard file-drop methods or manual imports, our Connector API provides a RESTful API interface, allowing developers to push and pull data using standard JSON calls without needing to be experts in Sage 100’s complex internal table structures.
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.
Our team provides background knowledge and technical support, while your developers create the actual integration—saving you money and allowing you more control over the final integration.
Connector API in Practice
One of our recent success stories profiles a Salesforce implementor, SETGO, who needed to create a complex Salesforce/Sage 100 integration for their client. They already had a strong development team, so they chose to use Connector API for their integration needs.
Tom Lemirand, president of SETGO, commented, “we were able to meet as needed to get our problems solved. The IN-SYNCH team was responsive, which greatly assisted the learning curve and project timeline.”
Another software development company, Motivate, uses the middleware to turn emails into Sage 100 purchase orders for one of their clients.
For yet another example, Yooz chose the Connector API to integrate Sage 100 with its financial operations automation solution.
What’s New with Connector API?
The Connector API team is always working to expand and improve the software’s capabilities. We’re committed to making sure every Sage 100 integration you can think of can be created with IN-SYNCH or Connector API. If you don’t see the API endpoint you need, we can create it.
To that end, our team has recently added these new endpoints to the Connector API (in addition to the ones already available for SO, IM, and AR):
- Post Purchase Order Header and Detail
- Post PO Receipt of Goods Entry Header and Detail
- Post Physical Count
- Post Inventory adjustments as Inventory Transaction Entries
- Post/Get Job Cost Master
- Get Job Cost Code
- Get Job Cost Type
- Post AP Invoices
- Get Open AP Invoices
- Get/Post AP Vendors
- Post AP Payments
- Get GL Chart of Accounts
The team has also recently developed custom API endpoints for Sage 100 UDTs (user-defined tables).
Looking for Sage 100 Custom Integration? You’re In the Right Place!
We’d love to talk to you about how our team can support your integration goals through Connector API. Contact us today to start the conversation!
