Discussions

Expand all | Collapse all

How to connect external databases ?

  • 1.  How to connect external databases ?

    Posted 20 days ago
    Hi team,

    I want to know about how we can connect external database in Quickbase.
    For example I have existing app which use existing database like MySQL or MSSql.
    How we can pull or fetch data from this database in Quickbase?

    If I create an application in Quickbase then How can I connect my existing database with QB?
    Do we have any connectors available ?

    Regards,
    Kat.


    ------------------------------
    Kat Mill
    ------------------------------


  • 2.  RE: How to connect external databases ?

    Posted 20 days ago
    Edited by Mark Shnier (YQC) 20 days ago
    Most people use the third party software called  QuNect https://www.qunect.com  .

    The website is not fancy, but the owner Claude is one of the original developers of OneBase back around 1999, which was bought by Intuit and rebranded as QuickBase (then later rebranded as Quick Base - with two words).  Claude is a genius and I hear that he is responsive for questions.

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



  • 3.  RE: How to connect external databases ?

    Posted 20 days ago
    Hi Mark,

    Thanks for the reply. I will explore QuNect more.

    I can find that it is ODBC for QuickBase, so I assume using it we will be able to access our QuickBase DB in other platforms.
    However we want an opposite case. Will it also be able to connect my existing DB from other platforms to my QuickBase app?

    Thanks.

    ------------------------------
    Kat Mill
    ------------------------------



  • 4.  RE: How to connect external databases ?

    Posted 20 days ago
    Yes, it's used to get data from another data base and bring it into Quick Base.

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



  • 5.  RE: How to connect external databases ?

    Posted 20 days ago
    Thanks Mark.

    I will check more on that.

    ------------------------------
    Kat Mill
    ------------------------------



  • 6.  RE: How to connect external databases ?

    Posted 20 days ago
    There is also a new SQL connector being offered by PAASPorter. @Don Larson can tell you more about it or you can check out their website - paasporter.com​

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 7.  RE: How to connect external databases ?

    Posted 19 days ago
    Thanks Blake.

    I contacted Claude for QuNect support.

    Our main requirement is...
    "We don't want to copy our existing DB in QuickBase however we just want to know about a DB connector which can connect our Database and a Quickbase app."

    As per the reply from Claude, QuNect actually copies existing DB into Quickbase using Qunect ODBC connector. But that is not our requirement we want a connector which serves as an intermediate, which can fetch data from our DB upon request form QuickBase app and send it back to QuickBase app.

    Do you have any idea if PAASPorter will solve our requirement ?

    Thanks in advance...!


    ------------------------------
    Kat Mill
    ------------------------------



  • 8.  RE: How to connect external databases ?

    Posted 19 days ago
    Edited by Mark Shnier (YQC) 19 days ago
    Kat

    I do know that Quick Base is hard at work to create an ODBC connector using Pipelines. They realize that that will open a whole world of possibilities of connections being able to connect to any generic ODBC database.

    I do not have any timing on that but it is possible that now that they have rolled out the Pipelines connections to the Google Suites that it could be that ODBC is next.   Your best bet may be to wait until the Pipeline connection comes through.

    Quick Base will normally not Announce Timing until they are ready to Announce Timing but I suppose you could try to put in a support ticket to ask to be put in touch with someone on the Pipelines development team to see if they will reveal to you some idea of the timing. It is not a secret that this ODBC connection is a high priority for them but the question is when they expect it to come out in Beta.  Maybe you can ask nicely and offer to be an Alpha tester for them.  

    It does not hurt to ask.  :)


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



  • 9.  RE: How to connect external databases ?

    Posted 19 days ago
    Unfortunately, I don't know for certain, but my guess would be yes. I'd check out their website or contact @Don Larson, ​​one of their founders.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------