Sage 100

I have a 2017 Sage 100 Advance install on Server 2016. They have a need for sData for a Zoho CRM integration. I have this link for information but at this point am tired of dancing around it and looking to partner with another reseller with experience on setup, configuration and testing of sData. Anyone have an estimate of cost, desire to work and time to complete?

https://90minds-com.socialcast.com/messages/36837112

I don't think the SDATA reputation was good

Good thing is I didn't recommend it. They are already committed to a Zoho Consultant and implementation.

A few years ago a developer wrote a plug-in for WooCommerce that imported orders into Sage 100. The plug-in was based on PHP and used SData. The plug-in can work, but the developer has abandoned it. sData is not something I would use in a solution.

Anyone know how it is setup?

This is from memory. First need to purchase from Sage the license. Install software on server where Sage 100 is install. Need to go through configuration settings. A TCP/IP port is required, so the router needs a rule to route traffic to the server where sData resides. An SSL certificate may have been required. A manual does exist, but it will only frustrate a developer. This is nothing like Zapier integrations. Zapier is to 3rd grade math as sData is to Diffrential Equations taught by someone whose first language is Chinese.

I would not use sdata. It is a dead end path. There are some significant bugs that will never be fixed. In addition, sdata is no longer being maintained by Sage. This is per my conversations with Steve Malmgren. There is a bug that doesn't allow the code to select by date range. The date formats are messed up... A slight problema with certain applications, for example, accounting software.

Instead of SData, can it support a web services integration? If the Zoho developer can send a JSON or XML file then that is a better way to go. The client would have IIS installed on a server which would have a web service configured. It would listen for the Zoho request to create customers or sales orders in Sage 100. On that IIS box will be a custom dot NET program that will use the BOI to create the actual sales orders and/or customers in Sage 100. Send me a chat if interested. Even if it was SData it would take a fair amount of discovery, homework, and delivery time to get it done just right , regardless of what client may have heard or been told by anyone.

As Alnoor mentioned, a web service is the way to go. Use a REST, WSDL, or SOAP API and pass data using JSON, HTML or XML.

Just in case this is an option - I have a user with a similar (no Zoho though) situation with CRM. They do NOT want/need to send orders back and forth. So our quick and dirty solution was to export out all orders during the day to CSV and they pull them into their CRM. We use Visual Cut to generate the Crystal Report each night to a folder on the server from which the CRM people pick up the data and import.