[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2007-08-01
4
Medium Priority
?
272 Views
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.

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
0
Comment
Question by:MIKE
  • 2
4 Comments
 
LVL 27

Accepted Solution

by:
ptjcb earned 2000 total points
ID: 19610382
0
 
LVL 17

Author Comment

by:MIKE
ID: 19610408
Are you using this driver..is it working good...like any other driver..?

MIkeV
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 19610532
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
 
LVL 17

Author Comment

by:MIKE
ID: 19610546
thanks for the extra info...Eugene...pretty awesome..

MikeV
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

830 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