Fortium Partners Leverages QuickBooks Online and MySQL Data Integration

Fortium Partners provides interim, fractional and situational leadership services for all kinds of organizations across all industries. Their clients engage world-class executives in technology leadership roles (CIO, CTO, and CISO). Fortium’s Partners have more than 25 years of technology experience in a senior operating leadership role.

Fortium Partners

Technology Leadership Services

Data Integration

Companies call us when they need technology leadership to address their most pressing technology challenges and their greatest opportunities for innovation. Our clients rely on us to know the leading technology products and services that can help them succeed."

Burke Autrey

CEO at Fortium Partners

Challenge

Several times a month Fortium Partners have to run a complex billing procedure to issue and send invoices to their clients and partners using QuickBooks Online. To form the invoice in QuickBooks Online, the partners' data with their time and timekeeping needs to be loaded to QuickBooks Online from the local MySQL database. After the invoice is paid by the client, this data should move back to the MySQL database and complement the data in it.

The challenge was to execute all this work (actually sync data between MySQL and QuickBooks Online) without spending time and money on writing custom code.

We are not able to issue invoices directly within QuickBooks Online because the data which determine how the invoice will look is stored locally, and doesn’t exist in QuickBooks Online. So I download the timekeeping data, we do a lot of queries and some stored procedures, then I generate some local data based on the timekeeping data and then I update the data in QuickBooks to kind of link back to. After that, I create invoices in QuickBooks and add special fields to link back to another database."

Burke Autrey

CEO at Fortium Partners

Solution

After trying multiple tools, Fortium Partners have figured out that they needed an ETL tool, and Skyvia was the best choice in terms of pricing.

So I looked at solutions and I found that Skyvia just had a better price point for me. It had good integration with QuickBooks Online,, which is the only one at the time that mattered to me, as well as MySQL."

Burke Autrey

CEO at Fortium Partners

Skyvia Data Integration product allows to replicate and sync data from QuickBooks Online to the local MySQL database using a convenient GUI wizard. Skyvia Backup comes as a nice bonus allowing to backup the sensitive billing data on the highly secure Microsoft Azure cloud server.

Results

As a result, Fortium Partners were able to implement their custom billing scenario using Skyvia Data Integration fast and efficiently and to protect their data with the help of Skyvia Backup.

And so it was easy to set up, you know, so I was able to really accomplish two things: one - create a backup of the data that's in there, and that was bothering me at the time that there is really ino backup of any kind. And then secondly, I needed to work on that data and I didn't quite have the skills to integrate with the API and build the software to do it."

Burke Autrey

CEO at Fortium Partners