KingswaySoft

SSIS Integration
Toolkit for QuickBooks

Easy-to-use data integration software for QuickBooks Online

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.
  • 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
DownloadPurchaseData Sheet

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.
  • See help manual for a highlight of the technical features.

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.

NetSuite SSIS Components

QuickBooks Connection Manager

SSIS Integration Toolkit for QuickBooks - Connection Manager

The QuickBooks Connection Manager facilitates connection to QuickBooks Online's REST API.

QuickBooks Source Component

SSIS Integration Toolkit for QuickBooks - Source Component

The source component allows you to read data from QuickBooks Online.

QuickBooks Destination Component

SSIS Integration Toolkit for QuickBooks - Destination Component

The destination component facilitates writing data to QuickBooks, using different actions.

QuickBooks Token Manager

SSIS Integration Toolkit for QuickBooks - Token Manager

The QuickBooks Token Manager gives you access to your QuickBooks tokens on your machine

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.