Forum Discussion

UrsulaLlaveria's avatar
UrsulaLlaveria
Qrew Assistant Captain
5 years ago

Pull in Salesforce Data Using external Azure/Sql database

We have been given 3GB of Salesforce data to create a QB app. Since there is a 500MB limit on tables, we are looking into some other ways to connect an external Azure database to QB so we can still us...
APIs and custom code
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
I would first determine what structure your application will take. This will give you an idea of how you need to break up the data. Once you've done that, I can't imagine that you would be near the 500MB per table.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    To echo what Blake said above, note that in Quick Base formula fields, look up fields, and summary fields, do not count for space.   

    What Blake is saying is that much of the data is probably repetitive. For example if it was a dump of sales data and had a bunch of fields for customer information such as their name address phone number etc., those would all be look up fields in a properly structured QuickBase app.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------