SSIS Integration Toolkit for QuickBooks is an affordable, 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.
  • The 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, Directory Services, SharePoint, and any other components available in the Ultimate Edition.
QuickBooks Data Integration

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 into the integration server.
  • Line items' support brings unique flexibility and enables the ability to read/write individual line items from a primary entity.

Technical Requirements


  • QuickBooks, either:
    • QuickBooks Online Subscription, or,
    • QuickBooks Desktop
  • Microsoft SQL Server Integration Services, either:
    • Azure-SSIS Integration Runtime,
    • Microsoft SQL Server 2022,
    • 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.

SSIS Integration Toolkit for QuickBooks - Connection Manager

QuickBooks Connection Manager

  • The QuickBooks Connection Manager facilitates connection to QuickBooks Online's REST API.
  • Provides secure and encrypted communication between SSIS and QuickBooks, ensuring data privacy during data transfer.
  • Supports multiple versions of QuickBooks, offering flexibility in integrating data from different QuickBooks editions.
  •  See this component's documentation.

QuickBooks Source Component

  • The source component allows you to read data from QuickBooks Online.
  • Supports custom queries and filters, enabling users to extract specific data based on their requirements.
  • Enables real-time data synchronization, ensuring the most up-to-date financial information is available for integration with other systems.
  •  See this component's documentation.

SSIS Integration Toolkit for QuickBooks - Source Component

SSIS Integration Toolkit for QuickBooks - Destination Component

QuickBooks Destination Component

  • The destination component facilitates writing data to QuickBooks, using different actions.
  • Supports bulk data insertion, optimizing the upload process for large datasets to QuickBooks and reducing processing time.
  • Provides comprehensive mapping capabilities, allowing users to align SSIS data accurately with corresponding fields in QuickBooks for precise data integration and management.
  •  See this component's documentation.

Mapping Line Items into QuickBooks

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.

SSIS Integration Toolkit for Dynamics Marketing - Mapping Line Items

Codeless
Integration

You don't have to write a single line of code to make data integration happen so your development can be done in a matter of minutes.

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 an extremely simple licensing model, our solution offers the best value for your investment.

Unparalleled
Performance

Our software offers many specifically designed features that help you achieve the best possible performance without having to hijack your budget.