DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 6

changes.mady.by.user Avinash Rao

Saved on

compared with

New Version 7

changes.mady.by.user Avinash Rao

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Setup your Database for Integration with your Quickbooks file. For this Tutorial I will be using SQL Server Database Named "DBSyncDB".
  • Create tables "qbcustomeraccount" and "qbinvoiceinvoice" in Database with following script.
Code Block
langsql
titleDatabase Script
borderStylesolid
USE [DBSyncDB]

CREATE TABLE [dbo].[qbcustomeraccount](
	[nameid] [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] [ncharvarchar](1050) NULL,
	[idcompany] [nchar](50100) NULL
) ON [PRIMARY]

GO

USE [DBSyncDB]

CREATE TABLE [dbo].[qbinvoiceinvoice](
	[invoice_no] [nchar](10) NULL,
	[customernamecustomerid] [nchar](100) NULL,
	[item] [nchar](100) NULL,
	[itemdesc] [nchar](1000100) 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.