SSIS Integration Toolkit for QuickBooks

QuickBooks Online connections within the KingswaySoft SSIS Integration Toolkit primarily rely on OAuth2 authentication. This secure method involves generating a token file that stores your authentication credentials. You can opt to use a KingswaySoft-provided app (convenient for quick setup) or configure "My Own App" by inputting your specific Client ID, Client Secret, and Redirect URI obtained from the QuickBooks developer portal. The process typically involves an interactive "Sign In and Authorize" step, which may open in your default web browser, allowing you to log in to QuickBooks Online and grant permissions, ultimately creating the encrypted token file that requires a specified path and optional password.

The QuickBooks Source Component is your go-to for reading QuickBooks data within your SSIS data flows. After linking it to a QuickBooks Connection Manager, you configure its General page. For QuickBooks Online, you can choose your Source Type as an Entity (selecting a standard object), a Query (using QuickBooks Query Language, similar to SOQL, for flexible data retrieval), or Change Data Capture for incremental loads. For QuickBooks Desktop, the Source Type is always Entity, with filtering capabilities via QBXML Options. You can also define the Batch Size for records per service call, set the Output Timezone, and include Inactive Records for Name list entities (Online only) to ensure comprehensive QuickBooks data extraction.

The QuickBooks Destination Component enables robust QuickBooks data loading and manipulation. After configuring it with a QuickBooks Connection Manager, you select a Destination Entity and an Action. For QuickBooks Online, actions include Create, Update, HardDelete for permanent deletion of transactions, and SoftDelete for deactivating Name list entities like Customers. For QuickBooks Desktop, supported actions are Create, Update, Delete, and Void (for transactions). You can also set a Batch Size (e.g., up to 25 batched operations for Online) and an Input Timezone to manage how your data is written, facilitating seamless QuickBooks data integration workflows.

The SSIS Integration Toolkit for QuickBooks efficiently manages parent-child relationships within QuickBooks data. When reading QuickBooks data using the Source Component, if a source entity has child entities (like an Invoice with multiple Line Items), you can select these child entities to generate additional outputs, allowing you to extract related data simultaneously. For writing data to QuickBooks with the Destination Component, you can connect inbound components containing child entity data to secondary inputs. You'll then map these child entities in the Child Settings grid, ensuring a _LinkId field in the primary (parent) input must match a _ParentLinkId field in each secondary (child) input to correctly associate the parent and child records, ensuring accurate QuickBooks data integration.

For robust QuickBooks data integration, the Destination Component provides three critical error handling options on its Error Handling page: Fail on error, which stops the package; Redirect rows to error output, which sends problematic records to a separate output with ErrorMessage details for debugging; or Ignore error, which skips errors silently. For performance optimization and reliability, the Connection Manager offers an API Throttling Rate to control the number of requests per second, preventing service limits. Additionally, the Retry on Intermittent Errors option automatically re-attempts service calls up to 4 times during temporary outages, significantly enhancing the resilience of your QuickBooks connectivity and overall data synchronization.

The QuickBooks Desktop Gateway is an essential utility for enabling QuickBooks Desktop connectivity with your SSIS packages. As QuickBooks Desktop runs locally (on-premises), this gateway acts as a crucial bridge, allowing the KingswaySoft SSIS Integration Toolkit for QuickBooks to communicate with your installed QuickBooks application. It must be installed on the same machine as QuickBooks Desktop. During configuration, you can specify its Port Number, control access via Allow IP Addresses, and manage Users who can connect, even associating them with specific company files. It also installs the necessary QBFC (QuickBooks SDK) component to function properly, ensuring secure and reliable QuickBooks data integration for desktop environments.