Share:

Share on facebook
Share on twitter
Share on linkedin

How to Back Up Data For Xero, HubSpot, QuickBooks, MYOB, Salesforce, Dear Inventory

With cloud-based systems like Xero, QuickBooks, HubSpot, MYOB, Salesforce it is important to have a backup of all data. Not just as a safety precaution when the system is down but also for an easy migration to a new system. In the following step by step instructions, we demonstrate how you can achieve a backup in SQL Server with Acterys. The SQL Server relational format is database standard that is supported by nearly any client tool (e.g. Excel, Power BI, Tableau, etc.).

Here is how to backup Xero, QuickBooks, HubSpot, MYOB and Salesforce Data, a simple step-by-step process.

Backup Xero, QuickBooks, HubSpot, MYOB and Salesforce Data

1. Start a subscription at https://www.acterys.com/start-your-trial/
2. Once your tenant is ready (shouldn’t take more than 3 minutes (there is a  free, assisted onboarding with a specialist available)
3. Go to the “integration” menu and choose the the system of choice: Xero, HubSpot, QuickBooks, Salesforce, Dear Inventory and MYOB

Acterys Connectors Xero QuickBooks MYOB HubSpot, Salesforce
Acterys Connectors Xero QuickBooks MYOB HubSpot, Salesforce

4. Login to your account(s) – you can add as many companies as you like to one backup database

Create Backup for Xero, Quickbooks, HubSpot, Salesforce, MYOB
Create Backup for Xero, Quickbooks, HubSpot, Salesforce, MYOB

5. This will now automatically load all data in the optimal format, that caters for multi company handling. Among others adding unique keys so that data is clearly associated with the specific company in a multi-company environment. The format also automatically caters for consolidation requirements when a holistic picture across multiple companies is required.

6. The data is stored in relational tables that reflect the particular subject area e.g. journals, invoices, contacts, deals, etc And can be access with a variety of options:

  1. Free SQL Server Management Tool
SQL Table Sample
SQL Table Sample

2. Excel

SQL Connect From Excel
SQL Connect From Excel

After that you can add the necessary table(s) to Excel and have “live link” from there. When for example the data in one of the source systems (Xero, HubSpot, QuickBooks, Salesforce, Dear Inventory and MYOB) changes, it will automatically update in Excel:

Xero Backup from Excel

Xero Backup from Excel

This is the complete step-by-step process to backup Xero, QuickBooks, HubSpot, MYOB and Salesforce data to any SQL server using Acterys PowerApps tool.

Recent Posts

Top 5 Tips & Tricks For Planning, Budgeting and Forecasting in Power BI & Excel In this blog I am

Planning and Analytics [Infographic]

It is not uncommon for companies to have separate planning and analytics processes or legacy solutions that result in more

Materialize and Synchronize Power BI with a Data Warehouse “Materialize” is a database concept that refers to storing the result

I can’t help smiling when I see legacy BI/Planning application vendors -that were not so long ago laughing away Power BI- coming out with their own “Power BI Integration” after Microsoft has turned around the industry. These are more often than not nothing but “a marketing spiel” to build on Power BI’s awareness and of very limited use in real life application scenarios.

Across many mid-sized and large companies, finance and operations teams are at crossroads. This was one of the findings from the recent BPM Pulse 2021 survey which revealed that only a third of companies had truly harmonized strategic, financial, and operational plans.