Cin7 Core (Dear Inventory) data. Straight to Power Automate. Easy.

Our Power Automate data connector makes querying your Cin7 Core data a breeze

How SYNCHUB works

Get your Cin7 Core data into Power Automate in just two minutes and three easy steps.

1 2 3 Connect Cin7 Core to SyncHub

Securely connect Cin7 Core, as well as over 70+ cloud services that your business runs on.

1 2 3 We sync your data automatically

SyncHub incrementally syncs your data and stages it in a managed data warehouse (yours, or we'll provide one for free). We check for changes so you don't have to.

1 2 3 Integrate your Cin7 Core data from your Power Automate applications

Now, query your Cin7 Core data within Power Automate, using the SQL skills you already have. Easy.

Features

AI, meet Cin7 Core

All our connectors include access to our Universal MCP Connector in addition to APIContracts.Entities.APITypeSummary.

BYO database

All our plans include your own secure, managed database - hosted in SQL Azure. No need to bring in your network or admin team - just get straight into your reports.

You can also bring your own database.

Highly secure

Whether its data-separation, IP-whitelisting, encryption or multi-factor authentication - we consider security first & foremost in every decision we make. Your Cin7 Core data is safe with us.

Read our security overview to find out how.

Ingest other ad-hoc or custom data

Is your company still running on spreadsheets? Our Flexi Tables let you import and arbitrary data you like and use it right alongside your Cin7 Core models.

Sync all your historical data

SYNCHUB doesn’t just sync your latest data from Cin7 Core. It also goes back and collects all your historical data too. In fact, from your dashboard you can select exactly how far back SYNCHUB will go for each data table.

Flexible pricing model

Our Flexible Pricing Model lets you start small and scale as you need to, paying only for the features you're actually using.

More than just Power Automate

Stop managing multiple data connectors. SYNCHUB's flexible architecture provides access to your Cin7 Core data from multiple data tools.

Frequently asked questions

We've documented the Cin7 Core Data Model here. Use this to browse the tables, columns and foreign keys we create in your data warehouse.

We strive to centralize all the data that your business runs on, because with data consolidation comes additional benefits like reduced costs, ease-of-management, a central security model and - of course - data queries across your entire business.

If you have data outside of our supported services, please let us know here. And of course, you can always fall back on our Flexi Tables for arbitrary or ad-hoc datasets.

Grab your data warehouse credentials from your SyncHub Dashboard, then simply use the standard Database Connector in Power Automate to connect to SyncHub and begin building your reports.
SyncHub specializes in providing raw data, so we don't have pre-built reports for you. However, our Services Store lists professionals with Cin7 Core domain knowledge, and our AI Assistant understands your data model and can often build what you need with just a few prompts.
Yes! That's exactly what SyncHub was designed for. Just use the standard Database Connector in Power Automate to connect to SyncHub and start integrating your Cin7 Core into your existing reports & dashboards.

Extracting and structuring data from Cin7 Core is hard, and consumes valuable time & ongoing effort that could be spent analyzing that data. For example, cross-entity queries involve joining across multiple endpoints - something that is poor-performing at best and impossible at worst.

That's why SyncHub stages your data in a relational database first. Now, your reports have all the power of regular SQL queries - joins, ordering, filtering, grouping, and more - leaving you free to create the reports you need without restriction.

Most customers like to use their own database, but if you don't have one - we've got you covered too. All SyncHub accounts include their own dedicated SQL Azure database, making us a true plug-n-play solution for businesses of all sizes.
SyncHub specializes in providing raw data, so we don't have pre-built reports for you. However, our Services Store lists professionals with Cin7 Core domain knowledge, and our AI Assistant understands your data model and can often build what you need with just a few prompts.

See what other SYNCHUB customers have to say on Google Business

What makes SyncHub stand out is not only the product, but the team behind it. They are responsive, knowledgeable, and genuinely focused on helping us to achieve practical business outcomes.
SyncHub has been a fantastic tool that has allowed us to unlock the power of Power Bi and other reporting tools
I love synchub, being able to pull data into one platform has allowed us to build out Business Intelligence we couldn't have done before
SyncHub has been an absolute game-changer for me. I took on a project that was well outside my comfort zone, and finding SyncHub was honestly one of the best things that could have happened
Support by the team is awesome always there to lend a hand. Thank you.
See for yourself...

About Cin7 Core (Dear Inventory)

Visit the Cin7 Core (Dear Inventory) website

Dear Inventory was designed to help small to medium businesses become more efficient at day to day operations by providing them with a platform to simplify the management of products in inventory, control supplier inventory levels, manage quotes, purchase and sales orders, issue and process invoices, manage work orders to manufacture finished goods from raw materials and create sophisticated inventory reports.

The broad categories of DEAR users include retail or wholesale companies, small personal businesses, franchise chains, manufacturing companies and ecommerce operators

About Power Automate

Visit the Power Automate website

Microsoft Power Automate is a cloud-based automation service that lets users create automated workflows between apps and services without writing code.

Use your SyncHub connectors to drive your logic and flows based on real-time business data.