Carousel Industries' Custom Connectors into Snowflake

Carousel Industries Custom Connectors into Snowflake

Custom Connectors for Paycom and Zimit Data into Snowflake

Analytic Insights

Carousel Industries, a leading Cloud Communications Service Provider (CCSP), was looking for a way to ingest data from two of their key sales and operations system – Paycom and Zimit. This project was key component of Carousel's broader analytics program by unlocking data that was previously hard to access.

Get the Details

Problem

As part of Carousel's analytics strategy, they wanted to ingest data from two of their key sales and operations systems - Paycom and Zimit. They were already using Fivetran for Salesforce and other systems, but there was not built-in connector for Paycom and Zimit. At the end of the project they also asked us for assistance getting Power BI usage data.

Solution

As part of this solution, we built custom connectors using Azure Functions written in Node.js. Fivetran calls these functions to request and process new data from Paycom and Zimit into Snowflake. We also turned one of their existing Powershell scripts into an Azure function to retrieve Power BI usage data.

Result

They were able to unlock key personnel and operational data as well as data from their sales quoting system. They now had better visibility into Power BI usage to support their analytics program. The personnel data allowed them to better manage some onboarding processes within IT. The quoting data could be integrated with Salesforce data and used to manage their sales processes more effectively.  This project was key component of Carousel's broader analytics program by unlocking data that was previously hard to access.