How ClearCompany leverages CDC to enhance customers’ experience with real-time data

ClearCompany, a leading talent management platform, empowers businesses to enhance the employee experience with recruiting, onboarding, performance management, and learning solutions. To provide their customers with actionable insights and streamline internal reporting, ClearCompany leverages Rivery to create and maintain data pipelines as their business scales.

Challenge

ClearCompany faced significant challenges with its existing data solution. They relied on a self-hosted BI platform to store data and enable visual analytics. However, limitations such as customer data only being refreshed daily and service disruptions from the BI provider led ClearCompany to look for alternatives to their reporting and BI solutions. 

ClearCompany wasn’t just trying to solve the customer requirements for needing near real-time reporting results. Internally, they also needed a flexible data store that could handle extremely large data sets and support a wide variety of data streams, such as Salesforce and Hubspot, that could be loaded easily and regularly at short intervals. 

Moving to a modern data infrastructure seemed daunting due to the complexity and scale of the project. ClearCompany’s BI solution included thousands of reports and permissions, which made migration a multi-year endeavor. 

However, they recognized the benefits of transitioning to a Snowflake-backed architecture, which offered a lower cost of data storage and the flexibility to integrate with existing systems. Change Data Capture (CDC) and reliable connectors were key features they required to ensure seamless data replication and scalability.

Solution

ClearCompany implemented Rivery to transform their data infrastructure, addressing both customer and internal needs:

• Near Real-Time Replication with CDC: Rivery’s Change Data Capture (CDC) technology replicates ClearCompany’s MySQL application database into Snowflake in near real-time. This ensures customers have access to up-to-date data for BI tools without the delays or failures they experienced before.
• Automated Data Access for Customers: ClearCompany’s customers can now directly query their Snowflake-hosted data using their preferred BI tools or Snowflake’s Snowsight interface. This eliminates manual data exports and offers a seamless, automated reporting experience.
• Internal Reporting with Logic Rivers: Rivery’s Logic Rivers enable ClearCompany to perform SQL transformations and combine Salesforce data with application data. This provides internal teams with holistic, actionable insights into their operations.

Results

By leveraging Rivery, ClearCompany achieved remarkable outcomes:

• Increased Agility and Speed: ClearCompany gained the ability to deliver data to their customers in near real-time, empowering them to make faster, data-driven decisions.
• Enhanced Customer Value: Customers now access recruiting, onboarding, and performance data with minimal effort, allowing them to focus on strategic initiatives.
• Improved Reliability and Scalability: Rivery’s automated pipelines and Snowflake’s robust architecture ensure reliable, cost-effective data management at scale, reducing operational overhead.
• Streamlined Internal Reporting: By integrating Salesforce and application data, ClearCompany’s teams have a unified view of key metrics for strategic planning and performance evaluation.

ClearCompany’s decision to adopt Rivery’s Data Pipeline Platform—backed by Snowflake—delivered substantial business value. They transitioned from a less reliable, once-daily refresh system to a near real-time data environment with minimal setup time. As ClearCompany CTO Django Bliss put it:

“Rivery’s multitude of connectors allows us to set up new CDC connections at a rapid rate, allowing my developers to spend time developing instead of the days or weeks of setting up data pipelines.”

Moving Forward

By integrating Rivery, ClearCompany not only overcame the limitations of their previous solution but also unlocked new opportunities for their customers and internal teams. Near real-time data access, low-cost scalability, and secure infrastructure (SOC 2/GDPR compliance) enable ClearCompany to maintain their position as a leader in data-driven talent management solutions.