|
Data Collection, Analysis and management is important for any data warehousing
project. Our iDEA (integrated Data and Event Analyzer) service solution
platform provides the frame work to collect, validate, cleanse and manage data.
Unlike most of the ECCL tools available in the market, iDEA supports all forms
of data collection. Data can be collected using SQL methods, SNMP, FTP,
SCP, SSH, SOAP, XML, HTTP, CLI and any other propriotory method iDEA supports
multiple data bases, operating systems, event logs, system files, and data from
network elements such as network routers, switches and other network gear.
Multiple formats of data is supported. As the data is collected the system
in real time provides notification and data cleansing solutions. Data is
then stored in simple data marts that support ECCL process and any other third
party applications for data management.
iDEA Supports multiple data solutions and services including

- Data Warehousing Project Management.
- Data Warehousing Architecture and Technology Management.
- The ECCL process: Extract, Clean, Conform and Load process.
- Logical Data Mapping and Dimension Modeling.
- Development and Maintenance of User Interface.
- Data warehouse Security and Performance Management.
iDEA solutions are used for data monitoring, analysis, management, network
monitoring and other data related services.
We specialize in following technology implementation:

- Database/OLAP: MySQL, Oracle SQL
- ETL: iDEA Oracle Warehouse builder, DTS.
- Reporting/Analysis: iDEA, Business Objects, Cognos
|