SYNCHUB

Articles and insights for data driven businesses

Building meaningful charts using Xero’s Reporting API
Ben Liebert Ben Liebert

Building meaningful charts using Xero’s Reporting API

Xero’s Reporting API is an extremely powerful endpoint which provides us with the data required to assemble their most common reports, such as Balance Sheets or Profit & Loss. Unfortunately, with this power comes a level of abstraction that makes it quite tough to wrangle the data into a meaningful chart or report.

Read More
Introducing…SyncHub Insights
Ben Liebert Ben Liebert

Introducing…SyncHub Insights

SYNCHUB Insights is the next step in building powerful reports from your cloud data. With Insights, you can begin transforming your raw data into a reportable format, and then sharing that data with others using our flexible reporting and notification systems.

Read More
Getting started with the Query Editor
Ben Liebert Ben Liebert

Getting started with the Query Editor

SyncHub’s Query Editor is a simple and powerful mechanism for querying your cloud data using regular SQL statements. Think of SSMS or PGAdmin, but with a few surprises you won’t find anywhere else.

Read More
White-labelling SyncHub
Ben Liebert Ben Liebert

White-labelling SyncHub

Imagine SyncHub. Our customers visit our site, then create their account and connect their data sources. They start with a trial, and if they like what they see, then they move to a paid plan.

Now, imagine it again, but this time with your own branding. Under your own URL. And with custom pricing tiers, backed by your own Stripe account. This, my friend, is SyncHub’s white-labelled offering, and it just might be the missing piece of your BI or consultancy business.

Read More
How to query your Xero data from Looker Studio
Ben Liebert Ben Liebert

How to query your Xero data from Looker Studio

For many, the built-in reports and analysis that Xero offers is enough for our day-to-day needs. However, if you need something a little more customized, then you’re going to have to have to build it yourself. And what better way than using the tool you’re already familiar with - Looker Studio

Read More
How to query your Xero data from Google Sheets
Ben Liebert Ben Liebert

How to query your Xero data from Google Sheets

For many, the built-in reports and analysis that Xero offers is enough for our day-to-day needs. However, if you need something a little more customized, then you’re going to have to have to build it yourself. And what better way than using the tool you’re already familiar with - Google Sheets

Read More
An interview with Ben
Serena Benson Serena Benson

An interview with Ben

With our recent high-profile customers and appearance in the Xero Awards, we thought it was about time you got to know SyncHub’s founder, Ben Liebert

Read More
SyncHub for Consultants
Ben Liebert Ben Liebert

SyncHub for Consultants

SyncHub for Consultants is a new suite of pricing tiers that address the unique requirements of consultants and accountants operating in bulk.

Read More
From SaaS to DaaS
Ben Liebert Ben Liebert

From SaaS to DaaS

This article is aimed at owners or managers of other SaaS platforms. I’m going to describe SyncHub’s white-labelled Data-as-a-Service offering, and how you can easily clip it onto your own SaaS offerings - increasing your MRR and making your customers happier.

Read More
Keeping your data secure
Ben Liebert Ben Liebert

Keeping your data secure

At SyncHub, we have a big responsibility...you trust us with your data. So, I thought I’d take some time out and explain various modules and architecture decisions in our system, and how they impact security.

Read More
Bring your own database
Ben Liebert Ben Liebert

Bring your own database

One of the best things about SyncHub is that we provide customers with their own managed data warehouse - our users don’t need to be server/database admins in order to test our service.

For most of our users, this managed database is all they need. But others - particularly enterprise - want more, and this is where our BYOD service comes in

Read More
Managing Your Data Using Common Sense
Bryan Rockoff Bryan Rockoff

Managing Your Data Using Common Sense

Guest contributor, Bryan Rockoff, draws on his 20 years of industry experience to speak about the importance of practical data management across large organizations.

Read More
An exploration of our API Explorer
Tom Clayton Tom Clayton

An exploration of our API Explorer

We don’t like black boxes at SyncHub - they obfuscate the service that we are offering, and make it harder for people to understand exactly what is happening to their data. We figure most of our customers are like us, and like to know how things work - not just trust the black box and take the output for granted.

Introducing… our API Explorer…

Read More
How to query your Xero data from Power BI
Tom Clayton Tom Clayton

How to query your Xero data from Power BI

For many, the built-in reports and analysis that Xero offers is enough for our day-to-day needs. However, if you need something a little more customized, then you’re going to have to have to build it yourself. And what better way than using the tool you’re already familiar with - Power BI.

Read More
How to query your Xero data from Microsoft Excel
Ben Liebert Ben Liebert

How to query your Xero data from Microsoft Excel

For many, the built-in reports and analysis that Xero offers is enough for our day-to-day needs. However, if you need something a little more customized, then you’re going to have to have to build it yourself. And what better way than using the tool you’re already familiar with - Microsoft Excel.

Read More
Compounding API calls
Tom Clayton Tom Clayton

Compounding API calls

Hitting your API throttling limit can be extremely frustrating, read on to find out most the likely cause and what you can do about it.

Read More
The Data Accessibility Checklist
Ben Liebert Ben Liebert

The Data Accessibility Checklist

Data accessibility concentrates only on one’s ability to retrieve data from a certain platform. It is not concerned with what is done to that data later. Store it in CSV, dump it in a data lake, or feed it to your cat - I don’t care. I’m simply interested in your ability to get the data in the first place…

Read More
Introducing…Nerd Mode
Ben Liebert Ben Liebert

Introducing…Nerd Mode

It sounds easy, right? All that SyncHub essentially does is simply sync data from your cloud platforms. However there are a lot of moving parts behind-the-scenes and it is knowledge of these moving parts that helps customers understand how and when their data is coming down…

Read More