x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 87 subscribers
  • Views 1783 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
Kenny98

Best option for extracting data out of Sage 100 into Third-Party software

SOLVED
Posted By

We are looking at a Third-Party software called Master Control for our QA/QC documentation processing.  With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as well as other standard modules like IM, SO, AR.

I am only experienced with using ODBC to extract data out.  So what other options would be best for information (BOI, SDATA, JSON, Other)?  I've tried looking at SData and Json and they are much more technical than I am, so I'm confused as to what they would be used with in any circumstances.

Has anyone worked with Master Control and linked it with Sage 100?

Parents
  • 0

    Will the 3rd party software be on the same network as the Sage server? 

    Or will the queries need to work over the internet (to a cloud service)?

  • 0 in reply to Kevin M

    Different servers.  We have or are in the process of moving everything to a cloud environment, with the exception of Sage 100 of course; with the potential of moving to X3 in the near future.  We are in the early stages with Master Control but Director of QA is leaning heavy that way and from demo I've seen and talked to one other consultant, it's sounds really good for what we need.

  • FormerMember
    0 FormerMember in reply to Kenny98
    SUGGESTED

    ODBC is your easiest solution to extract 100 data. You might want to look at ScriptBasic for external scripting.

  • 0 in reply to FormerMember

    Thanks for the feedback JohnS.

    From a meeting we had late in the day on Friday, we want to have importing and exporting of data in real time.  With Master Control being an electronic document piece of software, we need to extract Manufacturing, Inventory and such, but then import/"update" work tickets and inventory information in real time.  VI would not be the answer for this. 

    Any ideas or recommendations on this would be greatly appreciated.

Reply
  • 0 in reply to FormerMember

    Thanks for the feedback JohnS.

    From a meeting we had late in the day on Friday, we want to have importing and exporting of data in real time.  With Master Control being an electronic document piece of software, we need to extract Manufacturing, Inventory and such, but then import/"update" work tickets and inventory information in real time.  VI would not be the answer for this. 

    Any ideas or recommendations on this would be greatly appreciated.

Children

*Community Hub is the new name for Sage City