I'm new to the CRM/Sage 100 Standard (MAS) integration and I need to pull some specific fields from 100 into CRM and store them in CRM for searching/sorting. For example, I want to pull the LastxxxDate fields from the AR/Customer record into the CRM Company record to be able to sort companies in CRM by these dates. I'm thinking a nightly query to 100 to get the data is ideal.

Is sData the best way to do this? What are the pieces needed (.dll with the sData query and CRM update code)?? How would the process be triggered from CRM?

Are there any examples out there?

CRM 7.3, Sage 100 2016 Standard