Components show

Name:
DB2DataWriter

Description:
Receives data through connected input port or reads it from input file, connects to DB2 database using db2 utility and loads data records into specified database table. Correspondence of input metadata and DB columns must be defined. Information about rejected records can be sent out through optional output port if connected. It works faster than DBOutputTable.

Database Migration

Migrate from Sybase to Oracle

We have a java-based transactional system, for internal use, that has been using Sybase as a datastore for 10+ years. We are modifying the system to use Oracle as the datastore. All historical data for the 50+ tables needs to be moved. The project includes translating some columns to a different data type and cleaning up some data problems.

Project status: in development
Purpose: non-commercial
Economy sector: industry
Kick-off date: 2007-01
Go-life date:
Length in months: 18
Company:
University of Chicago
United States
http://nsit.uchicago.edu
jrothen1@uchicago.edu

Number of project team members:
analysts: 1
ETL developers: 0
others: 0

Clover Usage

CloverETL framework usage:Standalone-runGraph util & XML graph definition
Main reason for Clover usage:Java based custom transformations
CloverEngine version:2.1.1
CloverGUI version:1.6.4
Number of different data sources:2
Transformed data volume (MB):200.00
Clover usage experience (years):0.00
Number of transformations (mappings):94

Technology

Operation system:Windows, Solaris
System version:Varies
Number of CPUs in system:1
Other used systems:
System type:64
Java Virtual Machine:Sun JVM 1.5
Database:Oracle, Sybase

Your account

Login:

Password:
Register