CWX
Let's talk
Financial services

Four databases, replicated into BigQuery

Client
Insight Software
Industry
Financial services
Practices
Data AI/ML
Discuss a similar project
01Client and problem

Customer data arrived from four database types, of uneven quality.

02What CWX delivered

Datastream replication to BigQuery from Oracle, MySQL, SQL Server and PostgreSQL, with validation.

03What changed

Faster, more reliable onboarding of customer data for analytics and reporting.

01

Highlights

Insight Software, a leader in financial software solutions, partnered with CWX to streamline customer onboarding and data integration for their Logi Symphony product, using Google Cloud's Datastream service to manage customer-owned data sources.

02

The challenge

Insight Software needed an efficient solution to integrate diverse customer data sources into their product, enhancing data quality and enabling seamless data replication to BigQuery for better analytics and reporting.

03

The solution

CWX implemented a Datastream Replication to BigQuery solution, ensuring data integration from Oracle, MySQL, SQL Server, and PostgreSQL, alongside comprehensive documentation, data validation scripts, and transformation scripts for quality and integrity.

04

The implementation process

The integration improved data onboarding and analytics capabilities, ensuring high data quality. Continuous monitoring and robust support provided system health checks and client assistance, ensuring smooth operations and client satisfaction.

More client work

Related stories

All case studies
Financial services

Meet BenBot, raising the bar for online capital raising

  1. 01Client and problem

    Customer conversations were spread across HubSpot, Slack and email, with inconsistent answers.

  2. 02What CWX delivered

    BenBot, a conversational hub on Vertex AI trained on a generative playbook, across every channel.

  3. 03What changed

    Faster, consistent customer communication, with real-time monitoring as the platform scales.

AI EngineeringPlatform EngineeringRead the story
Financial services

Democratizing the mortgage industry with AI solutions

  1. 01Client and problem

    Manual document review slowed every loan through underwriting.

  2. 02What CWX delivered

    A generative AI underwriting copilot on Vertex AI and Dialogflow, using directed retrieval.

  3. 03What changed

    One copilot reviews documents across every loan product, so loan officers decide faster.

Data AI/MLAI EngineeringPlatform EngineeringRead the story
Get started

Let's talk about what's next.

Bring one question or one use case. We will bring the people who can answer it.

Recommended first stepBook an AI Value Accelerator sessionYour leaders leave with a ranked heat map, a business case kit and a roadmap.Something else in mind?Talk to our teamTell us what you need. A CWX lead replies personally.

Prefer email? sales@cwx.tech