|
|
| BI (Business Intelligence) & DW (Data Warehouse) |
UK Interface
|
Customers
|
- Otis-UK, London
|
The challenge |
| Providing an efficient, flexible and secure method of retrieving data from ESS and generating Interface files which will be used to load data into their local systems.
|
The solution |
|
The scope for project consists design, development, deployment and support for ETL of eDirect Sales system related required data for generating Interface files for OTIS UK.
UK Interface is an ETL project developed in Data Integrator and Microsoft .Net. The UKInterface gets input text files from eDirect Sales System database and generates output Interface files.
UKInterface is divided into 3 modules viz. PreProcessing, ETL and PostProcessing. The PreProcessing and PostProcessing modules are developed in Microsoft .Net while the ETL module is developed in DataIntegrator.
UK Interface project is currently in User Acceptance Testing phase.
|
The platform |
| Windows 2000, MS .NET, MS SQL Server 2000, Data Integrator 6.5 |
|
