QuickBooks Online

QuickBooks Online is a cloud solution for accounting developed and marketed by Intuit. DataLakeHouse supports only QuickBooks Online, it does not support the desktop version of QuickBooks.

Import QuickBooks Online Accounts, Bills, Invoices, Customers, etc. directly to your Target. You can schedule your QuickBooks Online integration operations, via a Sync Bridge, to execute it automatically.

It allows you to create a copy of QuickBooks Online data in Snowflake and keep it up-to-date with little to no configuration efforts. You don’t even need to prepare the schema — DataLakeHouse will automatically create tables for your cloud data.

All you need is to specify the connections to QuickBooks Online and your Target and select data to replicate, and DataLakeHouse does the rest. It will copy the specified QuickBooks Online data to the Target and maintain this copy up-to-date automatically with incremental updates.

Connecting via Quickbooks Online, Requirements

• Ensure that you are an administrator or an owner of your QuickBooks Online account. If you are not, please contact your QuickBooks Online administrator.

Instructions (Basic Connection Setup)

DataLakeHouse.io securely connects to your QuickBooks Online instance by redirecting you to the QuickBooks portal for you to sign-in via QuickBooks's login. DataLakeHouse.io does not capture or store your password/credentials.Using the form please complete the following basic steps:

1. Enter a Name or Alias for this connection that is unique in the 'Name/Alias' field.
   • This name is only visible in DataLakeHouse.io and should be descriptive enough for you and other users of DataLakeHouse to understand its name.
2. Click the 'Authorize Your Account' button which will transport the page to the QuickBooks Online login, where you will enter your QuickBooks account credentials. Once your credentials are accepted you will be automatically redirected back to the DataLakeHouse.io portal and you will see a successful connection of your Source.

If any issues occur with the QuickBooks Online authorization occur, simply return to the sources page in DataLakeHouse.io, edit this source and click the 'Authorize Your Account' or 'Re-Authorize Your Account' button. If any issues persist please contact our support team via the DataLakeHouse Support Portal.

Replicated Entities

The following QuickBooks Online entities are available for replication to Snowflake. With DataLakeHouse.io you select which ones you'd like replicated and you're always free to add additional ones at a later time. These are the table names you will see in Snowflake:

• ACCOUNT
• ADDRESS
• BILL
• BILL_LINE
• BILL_LINKED_TXN
• BILL_PAYMENT
• BILL_PAYMENT_LINE
• BUDGET
• BUDGET_DETAIL
• BUNDLE
• BUNDLE_ITEM
• CLASS
• COMPANY_CURRENCY
• CREDIT_MEMO
• CREDIT_MEMO_LINE
• CREDIT_MEMO_LINE_BUNDLE
• CURRENCY
• CUSTOMER
• DEPARTMENT
• DEPOSIT
• DEPOSIT_LINE
• EMPLOYEE
• ESTIMATE
• ESTIMATE_LINE
• ESTIMATE_LINE_BUNDLE
• ESTIMATE_LINKED_TXN
• ESTIMATE_TAX_LINE
• INVOICE
• INVOICE_LINE
• INVOICE_LINE_BUNDLE
• INVOICE_LINKED_TXN
• INVOICE_TAX_LINE
• ITEM
• JOURNAL_ENTRY
• JOURNAL_ENTRY_LINE
• PAYMENT
• PAYMENT_LINE
• PAYMENT_METHOD
• PURCHASE
• PURCHASE_LINE
• PURCHASE_ORDER
• PURCHASE_ORDER_LINE
• PURCHASE_ORDER_LINKED_TXN
• PURCHASE_ORDER_TAX_LINE
• PURCHASE_TAX_LINE
• REFUND_RECEIPT
• REFUND_RECEIPT_LINE
• REFUND_RECEIPT_LINE_BUNDLE
• REFUND_RECEIPT_TAX_LINE
• SALES_RECEIPT
• SALES_RECEIPT_LINE
• SALES_RECEIPT_LINE_BUNDLE
• SALES_RECEIPT_TAX_LINE
• TAX_AGENCY
• TAX_CLASSIFICATION
• TAX_CODE
• TAX_RATE
• TERM
• TIME_ACTIVITY
• TRANSFER
• VENDOR
• VENDOR_CREDIT
• VENDOR_CREDIT_LINE