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 4843 IT projects that we have successfully completed with our customers.How can we support you?
Further development of a company database into a local data warehouse
Project duration: 1 year, 3 months
Brief description
Further development of a company database into a local data warehouse.
Supplement
In addition to the evaluations carried out with MS Access on the basis of the SQL server database, the Analysis Services data warehouse functions are used.
Subject description
Further development involves various subprojects, such as migrating a pricing application from Oracle RDBMS to the SQL server, developing a tool for maintaining prices in the future, developing a reconciliation tool for aligning SAP R/3 invoice data with the invoice data from an invoice system used to manage the invoice data, and developing a tool for credit management.
IT project data
- Industries pharmaceutical industry
- Specialist tasks Controlling, financials
- DP tasks Data Warehouse
- System environments Client/Server
- Procedure model Summit-D (PwC)
- Programming languages VBA
- Databases MS Access, MS SQL Server
- Development and test tool MS Query Analyzer, MS SQL Server DTS
- Middleware and frameworks MS SQL Server Analysis Services (SSAS)
Project period01.05.2004 - 31.07.2005
Customers who trust us
