2 Replies Latest reply on Sep 14, 2018 2:31 PM by Paul Rendleman

    Sage 100 Connection with Tableau

    Donny Baby

      I am trying to extract data from SAGE 100 using tableau.I have sage and tableau installed in my desktop. I select DNS as SOTOMAS90. it seems load the table names but no data is extracted.it keeps asking username/password and then it hangs up showing:- Loading Metadata. Please let me know if anybody has successfully connected sage100 with tableau

        • 1. Re: Sage 100 Connection with Tableau
          Ken Flerlage

          If I'm not mistaken, Sage 100 runs on a SQL Server platform. Is that true in your case? If so, you should be able to connect directly to the database via the Tableau SQL Server connector. You'll need the name of the database as well (and port if it's not the standard 1433) and a username and password. Do you have all of those things?

          • 2. Re: Sage 100 Connection with Tableau
            Paul Rendleman

            Have you tried setting up an access database with your sage tables...

             

            I've been trying to connect Tableau with Sage 100 for a while.

             

            quick test, add the AR_Invoice_HistoryHeader & Detail file to an access file.  trim the data tables to just the columns you need i.e. Invoice date, bill to name, extension amount etc.

             

            then connect the access file to tableau.