3 Replies Latest reply on Apr 18, 2017 6:17 PM by jonigirardi

    Sage 100 - OBDC - Tableau Connection

    KEVIN PRIOR

      We use Sage 100 and Tableau 9.3

       

      We have yet to find a way to directly connect Sage to Tableau

       

      Currently, we had a SQL server do a nightly query on Sage and then, from that extract, we run our Tableau Reports.

       

      We have tried everything and the DNS connection ("SOTAMAS90") can see the tables but when we try to link a table we either get a timeout warning or it sits on "loading metadata"

       

      In looking around we have seen some suggestions that Sage doesn't like Metadata and/or Sage is 32 bit so it will not work in some server applications.

       

      If anyone has had any good experience with this please share.

       

      Kevin Prior

      Catholic Health Association