Tip
Metadata,Lookups and Database Connections defined as external may be shared among several graphs.
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 |
|---|
|
|
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 |