OBIEE Reporting re-pointing from Teradata to Snowflake

Problem

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