Customer's Challenge
With data siloed in SAP, a leading private jeweler faced a significant challenge in leveraging its enterprise data for business intelligence and cost reduction. Because this data was trapped in SAP, it was difficult to marry it with the rest of their warehouse to initiate comprehensive analysis and strategic decision-making. They needed to bring their SAP data into a data warehouse solution built for analytics.
phData's Solution
phData proposed a foundational data engineering engagement where we configured and set up a Snowflake data warehouse to modernize the client’s data platform. We then created a data pipeline from SAP to Snowflake with Fivetran for ingestion, Coalesce for transformations, and Sigma Computing for data visualization.
Results
In just 6 weeks, phData successfully laid a solid foundation for the client’s data warehouse with modern tooling for their entire data pipeline. With the foundation set up, data pipelines were deployed and automated from SAP to Snowflake.Â
They immediately used this data and created insight-rich dashboards in Sigma that their regional managers utilize daily. Using this as a template, the client plans to create additional pipelines and dashboards in the future with their new modernized data platform.
The Full Story
SAP is one of the leading Enterprise Resource Planning (ERP) software providers, but it is notoriously difficult to remove data from the platform. One of the top private jewelers in the US was having this exact issue. They wanted to use their SAP data and other data in their warehouse to run deeper analytics and make more strategic decisions.Â
They had chosen to modernize their data warehouse to Snowflake and figured creating a pipeline between SAP and Snowflake would be the logical first dataset to load into Snowflake. However, without any cloud data warehousing experience, the client realized they would need a partner with the expertise to set them up for success.
Why phData?
The customer selected phData over other vendors due to the team’s deep expertise in Snowflake, Coalesce, Fivetran, and Sigma and its commitment to adhering to best practices for cost efficiency and performance. By selecting phData, they could also use the phData Toolkit, which helped automate much of the information architecture process with the Provision Tool and receive ongoing insights on their Snowflake account via the Advisor Tool.
During the ensuing data engineering engagement, phData was able to create a data engineering foundation for the client to build from by:
- Partnering with Fivetran and Coalesce to create the client’s new accounts
- Creating and implementing an information architecture utilizing phData’s automated Provision Tool that would speed up the migration and cut down on costs/resources
- Developing Role Based Access Controls (RBAC) and establishing an automation of role assignment with the client’s existing Azure Active Directory
- Partnering with Fivetran and Coalesce to create the client’s new accounts
- Utilizing the SAP connector for Fivetran to ingest data from SAP to Snowflake
- Setting up Coalesce and Sigma to connect to Snowflake
- Creating a POC data pipeline from SAP to Snowflake to be used in a Sigma dashboard
Take the next step
with phData.
Learn how phData can help solve your most challenging data analytics and machine learning problems.
