BI Platform Migration to SAS Viya

Case Studies

BI Platform Migration to SAS Viya

Creating a scalable, modern environment that supported secure data access, flexible reporting, and compliance with strict data usage agreements.

Return to the Resource Center »

Client Challenge

The client was running a custom-built BI platform tied to legacy Oracle infrastructure that had become increasingly complex to maintain and extend. As their analytics needs evolved, they needed a scalable, modern environment that supported secure data access, flexible reporting, and compliance with strict data usage agreements.

Business Ask

“Can you convert a custom-built BI platform into SAS Viya?”

Full Tilt Data was brought in to redesign and migrate the entire BI ecosystem—modernizing data structures, workflows, and access models to fully leverage SAS Viya’s advanced analytics capabilities.

Solution

Full Tilt Data engineered a comprehensive migration plan that replaced the legacy Oracle-based BI logic with a streamlined, cloud-ready SAS Viya architecture:

Postgres was implemented as the new data layer for improved performance and flexibility.
SAS Viya became the core analytics and visualization platform.
Oracle served as the source environment for data extraction and transformation.
Airflow and Python were used to orchestrate and automate data pipelines, ensuring accuracy and repeatability.

Implementation Highlights

Logic Conversion: Translated custom Oracle BI logic into functional, reusable data sets accessible directly within SAS Viya.
Data Migration: Migrated source data from Oracle to Postgres, optimizing schema design for Viya integration.
Row-Level Security: Designed and implemented fine-grained access controls to meet all client Data Usage Agreement requirements.
Extract Recreation: Rebuilt 50+ specific data extracts, allowing users to run, share, and schedule reports natively within SAS Viya.

Impact

The migration resulted in a robust, compliant, and user-friendly analytics platform that:

Reduced maintenance overhead and dependency on custom code.
Improved accessibility and performance for end-users across departments.
Ensured secure, compliant data access aligned with contractual obligations.
Positioned the organization for future growth using SAS Viya’s machine learning and advanced analytics capabilities.

Technologies Used

Postgres
Sas Viya
Oracle
Airflow
Python

15 years of healthcare domain experience combined with extensive technical skills.

We enable customers to exchange and use data across different systems while enforcing strong data governance principles to ensure data integrity and meaning.

Case Studies