QuickBooks to SQL Server

  • Adam Campbell

    SSC Eights!

    Points: 982

    Does anyone have any ideas of ways to communicate between SQL Server and Quickbooks?  I have found a couple of products out there, but does anyone have any recommendations?

    Thanks,

    Adam

  • Jeff Gray

    SSChampion

    Points: 10637

    Try

    http://www.qodbc.com

    jg

  • Jeff Gray

    SSChampion

    Points: 10637

    I suppose that I should mention:  I've used the QODBC driver and it did what I needed.

    jg

  • jsmith-979014

    SSC Enthusiast

    Points: 121

    Is that the version that comes with Quickbooks Enterprise or a purchased version?

  • Russ Riopelle

    Right there with Babe

    Points: 778

    We just purchased the Server version of QODBC. If we try to extract data from QB using an OPENQUERY statement in a stored procedure using a linked server it runs just one time. It leaves an open SPID which cannot be killed(have to restart the server to kill!!). Just wondering if you have had this experience. I have researched this on line and what I have found is that it is a SQL problem. Any help would be appreciated.

  • tomc 99431

    SSC Enthusiast

    Points: 131

    Synergration offers a product that replicates QuickBooks to a SQL Server database. There web site is http://www.synergration.com

  • minu.mukkada

    SSC Enthusiast

    Points: 134

    Can you please tell us the steps you have used to connect QB to SQL server using QODBC. We have been working on this especially other solutions like OpenSync, but we are not having success. Any help would be great.

  • Lowell

    SSC Guru

    Points: 323331

    i had used the quickbooks driver from http://www.rssbus.com/ado/quickbooks/ so i could connect via a .NET application;

    They had a decent amount of examples, and it was pretty easy to connect and view the data; from there, i could put the data in a datatable in .NET, and do what i want with it after that, for example copy all the tables to SQL server for example.

    When i did that is was the version 1.0 driver, and it did work well, but one specific thing that i was looking for, which was the Relations/ Foreign key equivilent for Payments Received-to-Invoices-Paid was not exposed; That was a critical piece for the process I was building, so I stopped investigating that.

    Their driver is now labeled 2.0, but it was definteily straight forward if you are a programmer.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • rookpsu

    SSC Enthusiast

    Points: 109

    minu.mukkada (6/27/2012)


    Can you please tell us the steps you have used to connect QB to SQL server using QODBC. We have been working on this especially other solutions like OpenSync, but we are not having success. Any help would be great.

    Minu,

    I work closely with the development team at Synergration. I'm curious, what issues did you experience with OpenSync that inhibited your success? I'm happy to assist and curious to know so we can enhance the product moving forward.

  • dh9226542

    SSC Enthusiast

    Points: 129

    I dont Know But I suggest you Quickbooks technical Support expert[/url]. They Solve your problem

  • Eirikur Eiriksson

    SSC Guru

    Points: 182321

    He he, funny seeing this popping up on the latest entries, only a 12 year old thingy, MDM would classify this as a "blast from the past"
    😎

  • sgmunson

    SSC Guru

    Points: 110418

    Eirikur Eiriksson - Sunday, April 1, 2018 8:45 AM

    He he, funny seeing this popping up on the latest entries, only a 12 year old thingy, MDM would classify this as a "blast from the past"
    😎

    This just brings back to mind the time when I posted somewhere in one of this site's forums, a question to see if anyone had ever figured out how to connect a Quicken database to SQL Server, and then on another occasion, if anyone had written something to process a QFX file.   Still curious, as it appears Quicken has departed the scene in terms of writing a desktop application that leaves your data on your computer, and appears to be going in the direction of holding that data in their cloud.   I'll be darned if I'm ever going to let them have that much of my data.   Their Quicken Bill Pay service is already $10 a month, and paying on top of that for the desktop app is already ridiculous, and with their 2018 version, they now want $59/year to boot.  It's really only a matter of time before I'll just have to buckle down and figure that all out, 'cause I'm not willing to place my financial data in their cloud any more than what they've already got.   Anyone ever figure out how to read the Quicken database file, or how to process a QFX file into a SQL Server table?

    Steve
    ‌(aka sgmunson)
    ‌:) 🙂 🙂
    Health & Nutrition

  • Sue_H

    SSC Guru

    Points: 89728

    sgmunson - Tuesday, April 3, 2018 12:40 PM

    This just brings back to mind the time when I posted somewhere in one of this site's forums, a question to see if anyone had ever figured out how to connect a Quicken database to SQL Server, and then on another occasion, if anyone had written something to process a QFX file.   Still curious, as it appears Quicken has departed the scene in terms of writing a desktop application that leaves your data on your computer, and appears to be going in the direction of holding that data in their cloud.   I'll be darned if I'm ever going to let them have that much of my data.   Their Quicken Bill Pay service is already $10 a month, and paying on top of that for the desktop app is already ridiculous, and with their 2018 version, they now want $59/year to boot.  It's really only a matter of time before I'll just have to buckle down and figure that all out, 'cause I'm not willing to place my financial data in their cloud any more than what they've already got.   Anyone ever figure out how to read the Quicken database file, or how to process a QFX file into a SQL Server table?

    This post?:
    https://www.sqlservercentral.com/Forums/FindPost626377.aspx

    🙂
    I had to do it I don't know how many years ago. Whatever it was I used was for opening the file in Excel as that was/is the way most utilities I found worked.
    I just tried to find what I used - no luck but found your post. There are still various options with Excel so you may want to try going that way., then Excel to SQL Server.  This one I was curious about - he lists the manual steps in the article and has a utility as well. Free is often worth checking:
    Import Quicken QFX files into Excel

    Sue

  • tytareka

    Grasshopper

    Points: 11

    QFX files come from online banking - Quicken does not create QFX files or export in the QFX format. Quicken for Windows exports QIF format, and you can use QIF2CSV converter to convert QIF files to CSV or Excel format.

    Sergiy Tytarenko
    Software developer
    ProperSoft - simple software for accountants and bookkeepers
    https://www.propersoft.net/

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply