Quickbooks Database....ETL...into SQL Server 2005 for reporting..???

Posted on 2007-08-01
Last Modified: 2008-03-17
I wanted to check with you SQL experts regarding the following....any comments are welcome in regard to Quickbooks data being ....ETL'd .... into SQL SERVER 2005 for reporting. goes..the dreaded QB question....again.

So has any light been shed on whether or not Crystal Reports XI can access Quickbooks Databases? I did a quick search and only found "old" questions from a few years ago...

What are some of you doing out there to extract data from Quickbooks Databases? Are you EXPORTING DATA into EXCEL...and ETLing the data from there...and reporting .....?

I currently in a SQL SERVER 2005...and... Crystal Reports XI Developer Edition scenario here.

Question by:MIKE
    LVL 27

    Accepted Solution

    LVL 17

    Author Comment

    Are you using this it working any other driver..?

    LVL 42

    Expert Comment

    try XML format + .NET

    --also review 3rd party tools
    also  check:
    Crystal Reports® and QuickBooks® Custom Reports

    --this one looks good too:

    Crystal Reports and QODBC:
    LVL 17

    Author Comment

    thanks for the extra info...Eugene...pretty awesome..


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now