This is really good, @Todd Martin - especially the bit about SDE. The others you mentioned, I'm familiar with, but it isn't clear how to implement (mind you that's from a CRM specialist's perspective). I would have liked to have seen how to configure the eBusiness Manager's web services, but like so many other things with Sage there didn't seem to be any good documentation on where to start.
So far, my observation on the Microsoft 365 Connector is that it gets you a relatively "MVP"-level place to start. However, if the customer is a heavy UDF user on their objects, you're going to be limited on what you can return. The connector only returns a specific subset of columns with no direct method on how to either include or exclude columns. It is pretty fast though - < 1 second to get and return a large amount of data.
What is the cost around SDE? I see $2,500 - but can't tell if that's yearly (seems to be).
What are the technical requirements to perform on the server? i.e., do you have to expose the Sage 100 server or the server SDE is installed on to the internet?
------------------------------
Basil Malik
e:
basil@ss-adv.comp: (918)600-8700
"Whatever you are, try to be a good one."
------------------------------
Original Message:
Sent: 02-09-2023 12:06
From: Todd Martin
Subject: Microsoft 365 Connector for Sage 100
If you are looking for an API for Sage, you have Web Services (which is not being updated and can only get a small set of data), SData (which is still 1.0 and not being updated), and o365 (which is being updated, at least when Steve M was there, not sure what is going to happen to it now). Those are the built in API or API like functions in Sage 100. Then there are 3rd Party which are actively supported and developed but have a cost associated with them. We have SDE which is a JSON and XML api interface that is configurable by the user or we can customize it for what is needed. You have ROI which says they have an API now to their system. I think Cim Cloud has an API if you are on their system. There may be others but those are the ones I know about.
Phil is right that during the presentation that Steve did, he said that they were exploring having it available to Developers to add or make changes but didn't say when or if it was going to happen. They were developing actively for it the past few years but with Steve gone, I am not sure how Active it will be. I do not think it had a huge adoption rate. Although, based on what I saw, it had a lot of potential.
------------------------------
Todd Martin
MBA Business Software
https://www.mbabsi.com
------------------------------