Sensia JV Data Extraction

[Audio] The purpose of this presentation is to introduce the Sensia JV Historical Data Extraction project, outlining its main goals and scope..

Introduction.

Project Overview. [image]. 01.

[Audio] The primary objective of this project is to ensure the seamless transfer of historical data from Optimus BI/BW to Sensia's Blob Storage. This transfer is critical for facilitating Sensia's operational transition following its migration from Optimus SAP systems..

[Audio] A data flow has been established between Optimus SAP and Sensia's Blob Storage, which was approved by the Business Data Service in December of the previous year. This existing infrastructure serves as a solid foundation for our current project..

[Audio] A one-time historical data extraction is required to guarantee that all pertinent data is accessible within the new Sensia system. This extraction will concentrate specifically on the recognized datasets and their corresponding filters..

[image]. Requirements. 02.

[Audio] To extract the historical data accurately, we need to apply specific filters to ensure that only relevant data is transferred. These filters include plant codes ranging from J004 to J013, company codes such as US28, CA28, GB28, and AE28, and specific profit centers like 711 and 719. By applying these filters, we can guarantee that the extracted data meets our requirements and is ready for use in Sensia's new system..

[Audio] The data flow from Optimus BW/BI to Sensia's Blob Storage will utilize the SIMS ETL tool, which has been chosen to ensure efficient data management and retrieval. By leveraging this established route, we can streamline the process and guarantee seamless data transfer..

[Audio] The dataset essentials emphasize the significance of adhering to defined filters during the data extraction process. These filters guarantee that the transferred datasets meet Sensia's operational needs, ensuring seamless integration into their new system. By focusing on specific tables containing relevant data, we can extract the necessary information with confidence, thereby streamlining the transition process..

Implementation Proposal. [image]. 03.

[Audio] To facilitate secure access and data management, we will establish a SharePoint site for restricted external access. This solution enhances security controls and provides tracking capabilities for data access. We will configure the site to allow specific user permissions, ensuring that sensitive data remains protected while remaining accessible to authorized personnel..

[Audio] Files transferred to SharePoint will undergo encryption to protect data integrity and confidentiality during the upload process. The encryption strategy ensures that all files placed in the Sensia designated folder are secured, requiring decryption by authorized Sensia personnel before access. This added layer of security is crucial given the sensitive nature of the historical data being transferred. Our encryption strategy is designed to prevent unauthorized access. With this measure in place, we can confidently transfer the files to SharePoint, knowing that they will remain secure until accessed by authorized personnel..

[Audio] Files uploaded to SharePoint will be handled according to specific guidelines due to storage limitations. Large files exceeding 15 gigabytes will be segmented into smaller parts to simplify management and reduce potential system stress. Sensia's team will be responsible for decrypting, retrieving, and unzipping these files before loading them into SQL..

[image]. Timeline and Costs. 04.

[Audio] The project is on track to meet its completion deadline, with a scheduled finish date between December 2024 and February 2025. We have made significant progress towards achieving our objectives, including the successful extraction of 115 HANA views, which meets Sensia's requirements. Additionally, we will ensure that all operational workflows remain uninterrupted throughout the transition process..

[Audio] The project's cost breakdown shows that the overall expenditure comprises multiple components. The SIMS team contributed twenty thousand dollars, whereas SAP BW/BI efforts accounted for twenty-six thousand five hundred dollars. Security measures added one thousand eight hundred dollars, and FS document considerations brought the total to four thousand dollars, resulting in a total project cost of approximately fifty-two thousand three hundred dollars..

[Audio] The comparison between projected and actual estimates shows that although our initial calculations were accurate, unforeseen circumstances during implementation led to necessary adjustments to our original plans. Consequently, we encountered variances in specific areas, including SAP BW/BI efforts and document management. These changes directly affected our overall budget, prompting us to reevaluate our financial projections. Nevertheless, we are dedicated to completing this crucial project on schedule and within budget..

Challenges. [image]. 05.

[Audio] Several challenges have arisen during the data extraction process, specifically related to the integrity and functionality of HANA views. When extracting data from SAP tables, we've encountered issues that have resulted in complications with full loads, impacting our efficiency and reliability..

[Audio] The presence of special characters within the extracted data has significantly impacted our ability to successfully complete the data transfer process. The SIMS team has struggled to identify and address these issues, particularly when attempting to extract records from HANA views. The limitations of the system's record checks have made it challenging to pinpoint problematic entries, leading to frequent load failures. We will continue to work diligently to resolve this issue and ensure the successful transfer of historical data from Optimus to Sensia's Blob Storage..

[Audio] The high volume of user accesses to the Optimus system has raised concerns about system performance. As we move forward with the historical data transfer from Optimus to Sensia's Blob Storage, it's crucial that we consider the potential impact on system performance. With multiple Sensia employees accessing the data, there's a risk of straining the existing infrastructure and degrading service quality. We need to ensure that our solution minimizes any negative effects on system performance..

[Audio] The Sensia JV Historical Data Extraction project is a critical initiative that ensures a smooth transition from Optimus to Sensia's data management systems. By addressing the identified challenges and implementing the proposed strategies, we can significantly improve data accessibility and operational efficiency, all while maintaining robust security practices..

[Audio] We appreciate your attention throughout this presentation, which has covered the essential elements of our proposal for extracting historical data from Optimus to Sensia's Blob Storage. We have outlined the implementation plan, discussed the advantages, and addressed potential issues. Now, it's time to open the floor for any questions you may have. Please feel free to ask anything that is unclear or requires further explanation. Your input will assist us in refining our approach and guarantee a successful data transfer..