Connect QuickBooks to SQL Server through SSIS

  • dataintegration

    Mr or Mrs. 500

    Points: 510

    Comments posted to this topic are about the item Connect QuickBooks to SQL Server through SSIS

  • sherifffruitfly

    Ten Centuries

    Points: 1198

    nice informercial.

  • Elizabeth Connolly

    SSC Enthusiast

    Points: 111

    What VS and SQL Server versions does this require?

    Thanks,

  • dataintegration

    Mr or Mrs. 500

    Points: 510

    It's a standard ADO.NET Data Source so you should be fine with 2005 or later

  • Elizabeth Connolly

    SSC Enthusiast

    Points: 111

    Thanks - I assume that to have that kind of "integration" project type in VS I need to have SSIS installed or configured or whatever? I've never looked at SSIS. Sounds like it could also be done (with more steps/code) just using QB as an Ado.Net data source?

  • dataintegration

    Mr or Mrs. 500

    Points: 510

    Yes - you can use the RSSBus ADO.NET provider for QuickBooks as a standard ADO.NET Data Source with full CRUD support. If you use the Visual Studio designers there wouldn't even be any coding required. It's a standard ADO.NET source so you can easily bind to it from just about anything.

  • jason.quackenbush

    SSC Enthusiast

    Points: 130

    +1 on the infomercial reference. The article is nicely written, but what's the point of being misleading, the article implies that you can do it natively, not that you'll have to spend money. If you were going to spend money, you'd already know about this company and their product, and presumably would know how to implement it as well.

  • dataintegration

    Mr or Mrs. 500

    Points: 510

    Jason, I'm not sure that I follow - the article is not in any way attempting to be misleading, nor does the fact that it is an article imply that the solution should be free. There are dozens of articles on the site that use commercial products to help solve data problems.

  • jason.quackenbush

    SSC Enthusiast

    Points: 130

    I never said attempting to be misleading, I said flat out misleading. The fact it is an article attempting to solve a solution to a community does imply the solution should be free, otherwise it should be labeled as an Ad. You're correct, dozens of articles do stump for commercial products, doesn't mean they are correct either. It's like googling for a solution to an issue and hitting experts-exchange and having to pay for an answer that is freely available in plenty of other forums.

    All that said, it was a very good explanation on how to use the product.

  • This was removed by the editor as SPAM

  • contact 25075

    Grasshopper

    Points: 11

    Very useful information for quickbooks support number.

  • Jeff Moden

    SSC Guru

    Points: 996832

    jason.quackenbush - Wednesday, June 6, 2012 2:46 PM

    I never said attempting to be misleading, I said flat out misleading. The fact it is an article attempting to solve a solution to a community does imply the solution should be free, otherwise it should be labeled as an Ad. You're correct, dozens of articles do stump for commercial products, doesn't mean they are correct either. It's like googling for a solution to an issue and hitting experts-exchange and having to pay for an answer that is freely available in plenty of other forums.All that said, it was a very good explanation on how to use the product.

    I'll add one more complaint to that observation.  If you look at the article now, none of the graphics are visible.  This is because they didn't take the time to upload them to the article (as they should) and the links to the graphics are no longer available, although the company does still appear to be in business.

    Even if the article remained useful without the graphics, I'm not likely to go searching for the squirrel that buried the acorn.  Companies really should keep track of their own stuff on other forums if they actually do want some business from their infomercial instead of leaving aging piles of poo in someone's front yard. 😉

    Of course, Microsoft does the same thing with moving their links so fast and often that even current documentation has broken links.

    And, yeah... thumbs up on the "misleading" thing.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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