8 Replies Latest reply: Dec 18, 2014 1:25 PM by Mark Wexelberg RSS

    Loading date from remote database

      Hi all!

       

      I have the QV Small Business server on premise in the USA.

      I need to pull data from other databases that reside in other countries.

      I can ODBC connect into their servers but the data pulls too slowly.  It takes me 4.5 hours to pull this one table but they can pull this same table in 3 minutes.

       

      What is the best solution where I can schedule to run their data from my local QV Small Business server but the load is actually executed on their side, and then the final QVW gets updated on my local QV server for publishing?

       

      Thanks!