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

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.

Ok..here 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.

Thanks
MikeV
LVL 17
MIKESoftware Solutions ConsultantAsked:
Who is Participating?
 
MIKESoftware Solutions ConsultantAuthor Commented:
Are you using this driver..is it working good...like any other driver..?

MIkeV
0
 
Eugene ZCommented:
try XML format + .NET
check
http://www.quickbooksgroup.com/webx/forums/importexport/3937

--also review 3rd party tools
http://www.bigredconsulting.com/tools_for_quickbooks.htm
---
also  check:
Crystal Reports® and QuickBooks® Custom Reports
http://www.accountigrate.com/QuickBooks_crystal_reports.html

--this one looks good too:

Crystal Reports and QODBC:
http://www.qodbc.com/qodbccrystal.htm
0
 
MIKESoftware Solutions ConsultantAuthor Commented:
thanks for the extra info...Eugene...pretty awesome..

MikeV
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.