Cin7 Core Inventory (formerly, DEAR Inventory) and Heroku Postgres Integration

Data Sync in Any Direction

Skyvia Import allows you to create ETL pipelines to automate data loading in any direction. It supports both ETL scenarios — loading data from Cin7 Core Inventory to Heroku Postgres, and reverse ETL from Heroku Postgres to Cin7 Core Inventory tables such as Purchases, Sales, Products, etc.. For extracting data, Import has simple mode that queries data from a single object/table and advanced mode extracting data via SQL or visually built queries. It supports powerful pre-load data transformations, including data splitting, lookups, relation mapping, and custom expression language including various string, mathematical, datetime functions, etc. All ETL scenarios can be scheduled for automatic execution.

Skyvia can both load all the legacy data using bulk operations and only new and updated data. It supports all DML operation, including the UPSERT operation that allows you to load data without creating duplicates. Ability to load only new and updated data together with the UPSERT operation support makes Skyvia Import a perfect tool for data synchronization.

Bidirectional Synchronization

Import allows you to sync data in any directions, so you can configure two import integrations to load data from Cin7 Core Inventory to Heroku Postgres, and from Heroku Postgres to Cin7 Core Inventory respectfully. However, Skyvia also provides a dedicated tool to sync Cin7 Core Inventory and Heroku Postgres in both directions. Synchronization supports all the advanced mapping features of Import — lookups, expressions, etc., and it is best suited for cases when one of the data sources is empty. If the data sources are already partially synced, use Import.

Initial synchronization run loads all the data. Subsequent synchronizations load only changed data and apply the necessary changes from source to target and vice versa, reducing the number of billable records. So it's up to you whether to choose Import or Sync for your data synchronization tasks.

Cin7 Core Inventory Data Replication to Heroku Postgres

Replicate Cin7 Core Inventory Purchases, Sales, Products, etc. to Heroku Postgres and keep it up-to-date automatically! Combine raw data from Cin7 Core Inventory and other cloud app connectors in your Heroku Postgres database and turn Heroku Postgres into a single source of truth.

Data Replication is an easy-to-use ELT tool that helps you configure data ingestion from Cin7 Core Inventory in Heroku Postgres in just a few clicks. Skyvia automatically creates tables for your cloud data. All you need is to specify the connections to Cin7 Core Inventory and Heroku Postgres and select data to replicate, and Skyvia does the rest. It will import Cin7 Core Inventory data to Heroku Postgres and maintain this copy up-to-date automatically with incremental updates. Configure data pipelines once, and you'll always have fresh cloud data in Heroku Postgres, to which you can connect your BI tools, analyze your data, and do reporting.

Advanced Data Pipelines

For even more advanced scenarios and ETL pipelines, you can use Data Flow and Control Flow tools. They are designer-based solutions for creating complex data pipelines, involving not only Cin7 Core Inventory and Heroku Postgres connectors, but any number of connectors in one integration. With these tools you can automate data workflows, involving custom logic, complex multistage transformations, combine data from different sources and load them into multiple destinations at once and many more.

Workflow Automation

Automate workflows between Cin7 Core Inventory and Heroku Postgres with Skyvia Automation. Automation is a designer-based solution that allows you to perform actions in data sources when the specified trigger event happen. The trigger event can be a new record in a data source, a manual run, or a scheduled event.

Automation supports advanced data mapping. It allows you to include not only Cin7 Core Inventory and Heroku Postgres, but any number of data sources. You can perform actions in multiple data sources on one trigger or enrich data from other sources on the way.

Not only Automation allows you to automate your data-related tasks without coding, it provides such development tools as version control and debug mode. These tools surely help designing automations with no effort. Besides, there is a library of predefined examples that can help you to get started.