DBSync Cloud Workflow (iPaaS)

2022

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

DBSync – Database to Quickbooks Integration

  • Setup your Database for Integration with your Quickbooks file. For this Tutorial I will be using SQL Server Database Named "DBSyncDB".
  • Create tables "qbcustomer" and "qbinvoice" in Database with following script.
Database Script
USE [DBSyncDB]
CREATE TABLE [dbo].[qbcustomer](
	[name] [varchar](50) NULL,
	[phone] [nchar](20) NULL,
	[fax] [nchar](20) NULL,
	[billingstreet] [varchar](200) NULL,
	[billingcity] [varchar](50) NULL,
	[billingstate] [varchar](50) NULL,
	[billingcountry] [varchar](50) NULL,
	[billingcode] [nchar](10) NULL,
	[id] [nchar](50) NULL
) ON [PRIMARY]
GO

USE [DBSyncDB]

CREATE TABLE [dbo].[qbinvoice](
	[invoice_no] [nchar](10) NULL,
	[customername] [nchar](100) NULL,
	[item] [nchar](100) NULL,
	[itemdesc] [nchar](1000) NULL,
	[quantity] [nchar](10) NULL,
	[uom] [nchar](50) NULL,
	[salesprice] [nchar](10) NULL,
	[total] [nchar](10) NULL
) ON [PRIMARY]
GO
  • No labels