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 7 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 "account" and "invoice" in Database with following script.
Database Script
USE [DBSyncDB]

CREATE TABLE [dbo].[account](
	[id] [varchar](20) NULL,
	[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] [varchar](50) NULL,
	[company] [nchar](100) NULL
) ON [PRIMARY]

GO

USE [DBSyncDB]

CREATE TABLE [dbo].[invoice](
	[invoice_no] [nchar](10) NULL,
	[customerid] [nchar](100) NULL,
	[item] [nchar](100) NULL,
	[itemdesc] [nchar](100) NULL,
	[quantity] [nchar](10) NULL,
	[uom] [nchar](50) NULL,
	[salesprice] [nchar](10) NULL,
	[total] [nchar](10) NULL,
	[billaddress] [nchar](100) NULL,
	[billingcity] [nchar](100) NULL,
	[billingstate] [nchar](100) NULL,
	[billingpostalcode] [nchar](10) NULL,
	[billingcountry] [nchar](100) NULL,
	[date] [nchar](50) NULL
) ON [PRIMARY]

GO

* Make sure both the tables have sample data in them.

  • Open www.mydbsync.com in your browser and click on Customer Login.
  • Enter in your DBSync username and password to login.
  • Once logged in, click on My Home from the menu and click on Launch button in the following page as shown.
  • No labels