Solved

QuickBooks Enterprise to SQL

Posted on 2011-09-14
10
609 Views
Last Modified: 2012-05-12
How can I automatically retrieve information from QuickBooks and export it to MS SQL?

I have a multiple store report that I run every week.  I now need to do make this report dynamically viewable. That is if anything is updated then automatically update query the database so I can display the updated report.
0
Comment
Question by:usky1
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 9

Expert Comment

by:edlunad
Comment Utility
0
 
LVL 3

Expert Comment

by:ZillionTech
Comment Utility
SDK, Quickbooks connector
0
 

Author Comment

by:usky1
Comment Utility
I looked at teh SDK's but I do not have the time or resources to program the interface.
I'm looking for an application with the functions built in.
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
I've requested that this question be deleted for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:usky1
Comment Utility
I have not received the proper help on this question and wish to ask the moderator  to escalate it to a senior level person who might be able to help.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
Comment Utility
I hadn't seen the question until the clean up.

We use a tool from Synergration to do that with an Access database.  I just looked and they supprt MySQL and MS SQL also.

http://www.synergration.com/AccessBooksRT/default.aspx

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
I think my comment is a possible answer.  

usky1 - Please review the Synergration site and software.

I know it works quite well when exporting to MS Access.  It does provide the ability to select the fields and even allows some data manipulation

mlmcc
0
 
LVL 3

Assisted Solution

by:ZillionTech
ZillionTech earned 250 total points
Comment Utility
www.Quickbooksconnector.com is also a possible answer.
0
 

Author Closing Comment

by:usky1
Comment Utility
I looked at both of your solutions; mlmcc & ZillionTech.  I need to test with the Quickbooks connector becasue it does not show support for Enterprise 11.

Thanks for your recommendations.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 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

10 Experts available now in Live!

Get 1:1 Help Now