Integrating Enterprise Data For e-Business

Are you ready for analyzing valuable corporate data?

Data*Informatics provides a means of efficiently creating integrated data for analyzing E-Business effects and measuring the business results.

  • Data*Informatics is the most powerful ETL(Extraction, Transformation, Loading) solution for extracting, cleansing, transforming and integrating data from different databases including DB2, Oracle, Sybase, Informix, and etc.
  • The resulting data is transported into a database for data analysis. The analysis can be processed by the data mining solution, Biz Impact from NETInformatics.

Data*Informatics provides the beneficial factors on the followings;

  • Data*Informatics supports the broad range of Web Log data sources. Moreover, augmentation in the form of custom-coded extractions can be done to make specific data formats.
  • Data*Informatics supports Web Data Warehouse integration with other solutions in the environment including business intelligence solutions.
  • Data*Informatics supports the broad range of data sources involved in the data acquisition/integration effort.
  • Data*Informatics can easily manage the transport of the required data volumes by using Meta Data control.
  • Data*Informatics is implemented by Pure JAVA which is a H/W platform independent programming language by Sun Microsystems.
  • Data*Informatics supports various cleansing and transformation functions.
  • Data*Informatics provides intuitive user-friendly interface for the entire ETL process.
  • Data*Informatics is efficiently designed for web data processing.

Data*Informatics is data integration tool that facilitates extraction/transformation/transport of data from various data sources. Data*Informatics can handle many different data sources and data formats by using built-in transformation functions. For convenience and support to the operational data transportation, scheduling, job control and error handling are provided. The data, which is integrated and transformed, is loaded to a target data warehouse, data mart or other application database.

Data*Informatics provides Wizard based functionalities such as project management, Extract Management, Cleansing Manager, Mapping Manager, Scheduler Manager for ETL processing.

Project Manager

A project in Data*Informatics is composed of a closed-loop cycle, starting with Extraction, Cleansing, and Mapping and going through project execution or scheduling. Data*Informatics provides a comprehensive process for opening, managing and closing of ETL processing.

Extract Manager

Data*Informatics handle multiple data sources including DB2, Oracle, Sybase, Informix, and etc. Datga*Informatics creates a extraction consisting of multiple JDBC data sources. For user-friendliness of selecting and browsing data schema and actual data, source data in multiple databases are displayed in the form of tree.

Cleansing Manager

After accomplishing the process of extracting data from the source systems, many data cleansing jobs should be accomplished. During the cleansing phase, you can execute procedures to validate and verify data consistency.

Mapping Manager

Mapping is to create data table from one or several DB table to another. We may consider the mapping data from multiple representations to a single representation.

Scheduling Manager

Data*Informatics allows you to easily build a database of regularly occurring ETL tasks that need to be performed for your business. A user need to specify exactly what work needs to be done, how the work should be performed, how frequently and at what times.

Enabled Technologies in Data*Informatics

  • Multi Thread for Multiprocessing
  • Java Foundation Classes
  • Pluggable look and feel
  • Parallelism
  • JDBC
  • Bulk Loaders
  • Meta Data Technology

Data*Informatics' application field is as following.

  • Web Data Warehouses
  • Legacy Data Migration
  • Data Mining Manipulation
  • Data Marts & Data Warehouses
  • Integrating e-Commerce Data
  • Front- & Back-office Integration
  • Replication & Synchronization
  • Corporate Web Portals
  • ERP
  • Business-to-Business Data Access

System Requirements for Data*Informatics

  • H/W
    • Windows NT, Windows 2000
    • IBM AIX
    • HP-UX
    • Sun Solaris
    • Linux
    • 256MB RAM
    • 20MB Disk Space
  • S/W
    • Microsoft SQL 7.0 or higher
    • Oracle 8i or higher
    • JDK 1.3.0
    • JDBC 1.2