This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4822 IT projects that we have successfully completed with our customers.How can we support you?
Migration of a local datamart to Snowflake
Brief description
Migration of a local CRM data mart for sales and service. Existing processes and structures are analyzed and transferred to a new global environment. The data from various source systems (SalesForce.com, SAP BW, local data sources…) is implemented in a new global solution or existing data is used and adapted locally.
Supplement
Data from various source systems such as SalesForce.com, SAP BW, global data products and also locally maintained data sources are converted from a load to MSSql Server to Snowflake. All procedures, tables and views used in the old environment are analyzed. All functionality, locally needed will be implemented into Snowflake.
Subject description
The previous data mart was a local solution for sales and service in Germany. This data is now being made available in a new global environment. All necessary data, source systems and logics will be analyzed and implemented in a global Snowflake environment, or existing global data will be used and adapted. The new solution should enable comprehensive reporting, which can be carried out by the user using Tableau.
IT project data
- Industries pharmaceutical industry
- Specialist tasks business intelligence, data analysis, data warehouse
- DP tasks Support
- System environments Business Intelligence, Cloud Computing
- Procedure model customer standard
- Databases MS SQL Server, Snowflake
- Development and test tool GitLab, MS Visual Studio Code
- Standard software and BI Tableau Desktop
- Middleware and frameworks Talend Data Services Platform
Project start01.06.2023
Customers who trust us
