Skip to content

Let's talk about your next big project.

Looking for a new career?

View job openings. kpi-check-icon

By submitting, you consent to KPI Partners processing your information in accordance with our Privacy Policy. We take your privacy seriously; opt out of email updates at any time.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

    kpi-check-white-svg

    Teradata to Snowflake Migration

    Think

    About Automotive Aftermarket Parts Provider Company

    American leading automotive aftermarket parts provider that serves both professional installer and do-it-yourself customers.

    Technology

    • Oracle BI
    • Snowflake-2
    • IBM Data Stage

    OBIEE Reporting re-pointing from Teradata to Snowflake

     

    Problem

    Migration strategy and implementation expertise needed for OBIEE repointing from Teradata to Snowflake.

     

    The Before State

    • OBIEE 10.1.3.4.x pointing to Teradata with explicit limited support
    • Snowflake is identified as an enterprise database, with no connectors, strategy and implementation expertise to repoint OBIEE 10.1.3.4.x to Snowflake
    • Datastage ETL jobs loading data to Teradata

     

    The KPI Partners Solution

    • Sequelink set-up for OBIEE to Snowflake connectivity
    • Performed deep-dive analysis for all critical dashboards and reports to fix the defects raised after repointing to Snowflake from Teradata
    • Migration strategy of historical data load and Datastage ETL Jobs repointing from Teradata to Snowflake

     

    Results

    • $300K+ direct savings in Teradata support license renewal cost
    • OBIEE repointing to Snowflake with improved report performance
    • Repointing all Data stage ETL jobs to load data to Snowflake tables instead of Teradata

    Tags: OBIEE, Teradata, Snowflake, OBIEE Teradata to Snowflake Migration, Snowflake Migration

    Comments

    Comments not added yet!

    Explore how we helped our customer transform their core with advanced solutions

    Download Case Study
    kpi-top-up-button