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