Data Lake / Data Warehouse Implementation
on Microsoft Synapse
Data Lake / Data Warehouse Implementation on Microsoft Synapse
OVERVIEW
- Weyerhaeuser is one of the world's largest private owners of timberlands. It owns and controls more than 6 million acres of timberlands, primarily in the U.S., and manages another 14 million acres under long-term licenses in Canada. The company also manufactures wood and cellulose fiber products. Weyerhaeuser is a real estate investment trust (REIT).
- Weyerhaeuser uses an on-premises database solution. Its data assets include 4TB Data, 50+ databases, 150 SSIS jobs.
The company was facing issues with on-premises solution such as
- Attunity: Need to spend and maintain a 3rd party tool.
- Not easily scalable, need for user intervention to scale infrastructure.
- Support for only structured data.
- No out-of-the-box ML or AI solutions.
SOLUTION PROVIDED BY PEOPLE TECH GROUP
- People Tech has rich relationships with Weyerhaeuser being the first customer to provide our services.
- To tackle the issues faced by Weyerhaeuser, People Tech moved the on-premises resources to cloud before migrating to Synapse.
Synapse Assessment:
- Integration with external data sources.
- ETL Orchestration.
- Scheduling.
- Disaster Recovery.
- Operational support.
- Machine Learning.
- Security.
- API Support.
BENEFITS
People Tech’s solution helped in providing the client with the following benefits:
- Reduced cost.
- Re-Platform from IaaS to PaaS.
- SAP Downgrade.
- Power BI.
- Quick and easy access to common Data Lake.
- Data Scientist, Analyst, Operations and Business Teams.
- Quick On Demand scaling.
- Kick started ML initiatives.
- Ingested unstructured data.
