|
|
| BI (Business Intelligence) & DW (Data Warehouse) |
CABS Interface
|
Customers
|
- Otis-UK, London
|
The challenge |
| Providing an efficient, flexible and secure method of transferring ESS Sales Contracts' information from ESS Reporting database to CABS and Billing information from CABS to flat files that would be utilized by the Accounts Receivables System.
|
The solution |
|
The scope of the CABS Reports project includes design, development, testing, deployment and maintenance of CABS interfaces using Data Integrator.
Following two interfaces are part of this project.
|
- 1) ESS Interface (ESS Reporting Database - CABS Master database): This interface is written to fetch Sales and Field Structure Reporting Hierarchy and Contractual Information for billing purpose.
- 2) AR Interface (CABS Master database to Text Files): This interface extracts billing transactions' information generated in CABS and stores it on server at a location from where it can be picked by a service that will send this information to AR system.
|
ETL Scripts for these two interfaces are developed using Data integrator.
This project would be deployed at OTIS UK, London.
|
The platform |
| Windows 2000, MS SQL Server 2000, Data Integrator |
|
