Can't replicate QB to SQL Server

  • 17Views
  • Last Post 18 August 2021
0
votes
Brad Haas posted this 14 August 2021

I'm doing my first run on my QBO connection. I'm replicating all the tables to a MS SQL database. I'm getting the following error:

The source object 'BillLineItem' has neither 'MetaData_CreateTime' nor 'MetaData_LastUpdatedTime' column and cannot be used when the 'Incremental Updates' check box is selected.

Please help.

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 16 August 2021

Hello Brad,

 

In some sources, Incremental Updates are not supported for some of the objects. For Incremental Updates, an object must have fields, storing record creation and modification timestamps. If the object allows updating data, at least one of the fields with the creation and modification time must be present.

The solution for such cases is two have two separate packages: one with the "Incremental Updates" option and one without this option.

 

We recommend you to check the "Incremental Replication" section here: https://docs.skyvia.com/data-integration/replication/#incremental-replication

 

Best regards,

Mariia

0
votes
Brad Haas posted this 16 August 2021

Mariia. The problem is that there are tables like invoice line items that have tens of thousands of records that would need to be dropped and recreated every day. The table is a relational table, dependent on the invoice table which has the creation/modification timestamps. I'm not sure there is anything that can be done about this, but I'm hoping there is some kind of best practice to deal with this issue.

0
votes
Mariia Zaharova posted this 18 August 2021

Hello Brad,

 

The LineItem objects were added specially for user convenience. These objects store Lines values from parent objects as separate records. They allow you to view these lines in a tabular form, with Query, export them to CSV with Export, import them from QuickBooks to a cloud application or database, where these lines should be stored in a separate table, etc. See https://docs.skyvia.com/connectors/cloud-sources/quickbooks_connections.html

 

These objects store the same information as the Lines field in the corresponding main table - Invoice, Bill, etc.

 

Thus, you can remove foreign key constraints between these objects and use them in different packages. The package with incremental updates and main objects will be updated often. However, you can run package without incremental updates more rarely to refresh the data in these tables completely from time to time (e.g. once per week, every 3 days, etc.).

 

Unfortunately, at the moment, there is no other option to overcome this limitation.

 

Best regards,

Mariia

Close