Connect Sage 50 (local) with Google Data Studio

Was wondering if anyone had any experience connecting Sage 50 US with Google Data Studio?

We love the integration with our websites (MYSQL connected)  and a Google Sheets connection and would love to connect our Sage50 Data in Google Data Studio to make dynamic charts, graphs, reports etc.

Parents Reply Children
  • in reply to aceboogie

    A work around for this is:

    1. weekly export of accounts rec (or whatever you need)

    2. Paste raw data to google sheets

    3. connect google sheets to Data studio

    Working pretty nicely for us and the export and pasting only takes about 10 mins a week.

    Now we are able to offer our sales reps beautiful reports/dashboards etc.

  • in reply to SSiegel97

    I am trying your work around, but was trying to get Sage50 to connect directly to data Studio.  If anyone else has done this would love to hear how.  thanks SSiegel97