SSIS Integration Toolkit for QuickBooks is a high performance data integration solution for QuickBooks Online.

Quickly and easily set-up a data integration project in an easy-to-use codeless environment that offers unparalleled performance.

The SSIS Integration Toolkit for QuickBooks

  • High performing data integration for QuickBooks Online and On-Premises using SSIS.
  • Take advantage of the flexibility and power of the SSIS ETL engine.
  • Intuitive user interface to manage different aspects of your integration development.
  • Integration without having to write a single line of code, allowing the development process to be done quickly and easily.
  • Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio.
  • Robust error handling and superior performance.
  • Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, OAuth2, SHA-256, etc.
  • Synchronize QuickBooks data with virtually any external data source that SSIS can read/write to including Microsoft Dynamics 365, Active Directory, SharePoint and any other components available in the Ultimate Edition.

QuickBooks Data Integration

  • fill

    Codeless Integration

    You do not have to write a single line of code
    to make data integration happen; your development
    can be done in a matter of minutes, which would
    otherwise take weeks or even months

    Unparalleled Performance

    Our software offers many specifically designed
    features that help you achieve the best possible
    data integration performance, while rescuing your
    IT budget

    Flexible and Easy to Use

    We make the most flexible integration solution
    on the market. Our software offers intuitive user
    interfaces that are flexible and easy to use

    Cost Effective

    With a streamlined development experience,
    and a simplified licensing model, our solution
    offers the best value for your investment

  • fill

    An efficient and cost effective way to perform
    data migrations and integrations using technologies
    that our customers are comfortable with.

    Chris Scott Partner, Celedon Partners

Unique Features

  • Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
  • Easy to use filtering parameters to retrieve only the data you need to work with.
  • 4 different actions for writing to Quickbooks: Create, Update, Soft Delete, or Hard Delete.
  • Automatic field mapping based on a name-match.
  • Use the QuickBooks Token Manager to export tokens from the development machine and then import them in to the integration server.
  • Line items support brings unique flexibility and enables the ability to read/write individual line items from a primary entity.

QuickBooks SSIS Components

Technical Requirements

  • QuickBooks, either:
    • QuickBooks Online Subscription, or,
    • QuickBooks Desktop
  • Microsoft SQL Server Integration Services, either:
    • Azure-SSIS Integration Runtime,
    • Microsoft SQL Server 2019,
    • Microsoft SQL Server 2017,
    • Microsoft SQL Server 2016,
    • Microsoft SQL Server 2014,
    • Microsoft SQL Server 2012,
    • Microsoft SQL Server 2008, or,
    • Microsoft SQL Server 2008 R2.

Mapping Line Items into QuickBooks

SSIS Integration Toolkit for Dynamics Marketing - Mapping Line Items

There may be cases where you would like to read or write to objects that contain line items, such as an Invoice, or a Sales Order. You may choose to manipulate line items as a JSON array in the primary input/output entity, or take advantage of the secondary line items input/output. By utilizing the line items input/output it is possible to read/write individual line items from a primary entity.