1 Reply Latest reply on Oct 21, 2012 3:20 PM by Russell Christopher

    I had to divide my underlying data into two access databases due to size restrictions.  Is there a way I can add these back together in tableau so I can query them as one database?

    jen green

      I am hoping someone can help me with this question.  I had to break my underlying data into two access databases due to size restrictions.  Is there a way I can combine or add these databases in tableau so I can query them as one database?  Appreciate any help! 

        • 1. Re: I had to divide my underlying data into two access databases due to size restrictions.  Is there a way I can add these back together in tableau so I can query them as one database?
          Russell Christopher

          Hey Jen --

           

          Much love to Microsoft (my first tech job was supporting Access and the JET database engine many moons ago), but...I don't think you'll be happy with performance trying to join two Access databases. Keep in mind Tableau also leverages the JET database engine, so some of the same issues you're trying to avoid could still appear when you try to "re-join" the two split databases.

           

          Instead, I'd suggest you leverage Tableau extracts - much faster.

           

          Try this:

           

          1. Create an extract from the the original Access database
          2. Right-click your extract, choose Extract from the right-click menu, and then select Add Data From File
          3. Make sure you change the file mask from All Files to Microsoft Access Database
          4. Select the other database and table(s) you need...

           

          More rows will be added to your in-memory extract database. The drawback to this technique is that you'll have a two step refresh process (import the first database, then the second), but I'd personally pay this cost for quick response the resulting extract will give me on a daily basis.

           

          Good luck!