• Power BI

    We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.
  • Sage 300 Construction PO's

    I use a lot of queries to grab data out of Sage. I have and use the PO/Commitments application. Can someone tell me what table or where the table is to look at data there? I can only find data in the Job after the PO has been committed and sent to Job…
  • Database Schema for Sage 300 CRE?

    FormerMember
    FormerMember
    Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…
  • Accessing Sage 100 Contractor 2016 Database with Microsoft Access 2010

    How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…
  • Slow ODBC Queries

    Hello All, I have a problem I have been researching lately regarding slow queries over ODBC to our sage server. I have seen people with similar issues on other sites, but no real solutions.... We have a web server that uses PHP to query several database…