SYNCHUB
Articles and insights for data driven businesses
Introducing…the SyncHub Client Portal
SyncHub helps you scale your business by securely distributing reports across your client base, while letting you manage everything from a single centralized location
Using parameters to build advanced Insights
The simplicity of our Insights platform belies its power. In this section I’m going to walk you through one of the most powerful features of Insights - parameters.
The Flexi Table
Our new Flexi Table lets you create & populate your own ad-hoc data tables, right within your SyncHub data store.
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.
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.
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.
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.
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
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
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
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.
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.
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.
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
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.
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…
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.
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.
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.