DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 4

changes.mady.by.user Anil Bhimineni

Saved on

compared with

New Version 5

changes.mady.by.user Anil Bhimineni

Saved on

Key

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

Panel
Introduction
Many of the business user want to integrate QuickBooks reports with the Database object , I always come across with the one very question from a standard business user of the QuickBooks  that Can QuickBooks reports be integrated to Database ? The short answer is yes if a user wants a specific report to be sent to Database, DBSync can handle it . In this tutorial we would be learning how a data from QuickBooks P&L report is read and exported to Database using DBSync Platform. 

Panel
DataBase Setup

For this very tutorial purpose , I have chosen MYSQL as the database for writing the data which has been read from the QuickBooks Profit and Loss Report. The below is the script for you to generate the database with table and relevant columns .

Code Block


CREATE DATABASE /*!32312 IF NOT EXISTS*/`qbtodb` /*!40100 DEFAULT CHARACTER SET utf8 */;CREATE DATABASE /*!32312 IF NOT EXISTS*/`qbtodb` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `qbtodb`;

DROP TABLE IF EXISTS `profitandloss`;

CREATE TABLE `profitandloss` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `COA` varchar(255) DEFAULT NULL,
  `Amount` varchar(255) DEFAULT NULL,
  `ReportTitle` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `profitandloss` */

btodb`;/*Table structure for table `customdetailreport` */DROP TABLE IF EXISTS `customdetailreport`;
REATE TABLE `customdetailreport` (  `COA` varchar(255) DEFAULT NULL,  `Amount` varchar(255) DEFAULT NULL,  `Class` varchar(255) DEFAULT NULL,  `DueDate` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Address` varchar(255) DEFAULT NULL,  `OpenBalance` varchar(255) DEFAULT NULL,  `ReportTitle` varchar(255) DEFAULT NULL,  `Memo` varchar(255) DEFAULT NULL,  `TransactionType` varchar(255) DEFAULT NULL,  `RefNumber` varchar(255) DEFAULT NULL,  `TransactionNumber` varchar(255) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Panel
QuickBooks P&L Report To Database Import

...

  1. Add a rule with name of user choice, select the DB connector and operation as insert. 
  2. Choose an object as customdetail report.
  3. Now user has to do the mapping as per the need.
Panel
Running The Sync