Project details are below: This project focuses on transitioning the financial and reporting systems from Oracle Business Intelligence (OBIEE) to Microsoft Power BI. Additionally, the data architecture will be modernized to align with cloud - first strategies, leveraging cloud technologies such as Snowflake, Microsoft Synapse, or Microsoft Fabric. The project also includes migrating Extract, Load, and Transform (ELT) workflows from Oracle Data Integrator (ODI) to Azure Data Factory (ADF).
Key Project Deliverables:
Transition to Power BI Convert enterprise reporting and interactive dashboards from OBIEE to Power BI. Data Architecture Modernization Upgrade data architecture to support cloud-based technologies. Data Model Conversion Transform Oracle Business Enterprise Edition RPD metadata models to Power BI data models. Dashboard Migration Rebuild OBIEE reports and dashboards into Power BI for enhanced interactivity. ETL Workflow Modernization Transition ETL/ELT processes from Oracle Data Integrator (ODI) to Azure Data Factory (ADF).Scope of Work:
Analyze Current Environment Assessment of the existing Oracle Data Integrator, Oracle Database, and OBIEE Rapid File Database (RPD), including:
Developing a detailed conversion plan with steps, dependencies, and validation strategies. Assessing OBIEE RPD for subject areas, data source mappings, and conversion complexity. Analyzing table relationships, fact/dimension models, and data lineage. Evaluating existing security roles, policies, and groups. Identifying performance metrics and bottlenecks in pipeline execution. Documenting data sources, integrations, and dependencies of ETL/ELT pipelines.Data Migration from Oracle to Cloud Data Warehouse:
Extract historical and incremental data from Oracle. Transform data using Azure Data Factory (ADF) or equivalent tools. Load data into the cloud data warehouse using bulk data movement strategies. Validate migrated data to ensure accuracy and completeness. Optimize partitioning, indexing, and clustering for performance.Data Warehouse Design:
Implement staging, raw, and transformed layers for optimized storage. Design and transition Oracle schemas and tables to the cloud environment. Convert PL/SQL transformation logic for cloud-based automation.Migration from ODI to Azure Data Factory (ADF):
Document physical and logical architecture for data transformation workflows. Convert ODI workflows to ADF pipelines with enhanced functionality. Rebuild parameterized pipelines for reusable ETL logic. Configure linked services to integrate data sources with cloud data warehouses. Develop logging, error handling, and monitoring mechanisms using Azure Monitor. Optimize workflows for cost-efficiency and scalability. Implement Change Data Capture (CDC) for incremental data updates.OBIEE RPD to Power BI Data Model Migration:
Extract and document RPD metadata, including logical models and subject areas. Map OBIEE RPD relationships to Power BI datasets and dataflows. Convert logical models to physical models for optimized performance. Ensure accurate role-based access security mappings. Validate Power BI data models against OBIEE reports.OBIEE Dashboards to Power BI Migration:
Recreate OBIEE dashboards and reports in Power BI. Implement row-level security (RLS) and access control policies. Enhance report performance using Power BI Direct Query and Import modes. Optimize layouts, interactivity, and navigation for an improved user experience. Train business users on self-service analytics and report customization.Knowledge Transfer and Support:
Conduct comprehensive training sessions on developing Power BI dashboards and reports. Provide guidance on system management and post-deployment support. Ensure a seamless transition with issue resolution and continuous system enhancements.