Oracle to Sybase: How to transfer data from Oracle to Sybase
Step
1. Create a new job, and open the [Design Job] interface.
2. Create a new Oracle dataset as source in [Design Job] interface, and open the property dialog of Oracle dataset, set Oracle connection parameters in [Database] sheet, then click [Import field definition] button in [Fields] sheet to import field definition information.
Following is the detailed parameters of Oracle should be setted.
Property name
Description
Server name
Net server name of Oracle database.
User name
It is used to connect the Oracle database.
Password
Connecting password of the database.
Table name
Once you set up the parameters for database connection, click the combo box, all tables will be listed.
Field
List the definition information of the field that has the above format.
Before reading source data, you must define fieldĄ¯s information. About how to get field information.
3. Create a new ODBC dataset as target in [Design Job] interface, and open the property dialog of ODBC dataset, set Sybase connection parameters in [Database] sheet, then click [Import field definition] button in [Fields] sheet to import field definition information.
Following is the detailed parameters of Sybase should be setted.
Property name
Description
Data source name
The ODBC name of Sybase
User name
It is used to connect the Sybase database.
Password
Connecting password of the Sybase database.
Table name
Once you set up the parameters for database connection, click the combo box, all tables will be listed.
Create New table
Create a new table in target database. If it already exits, the new table can't be created
Submit records
Generally, capability is better when parameter is set as 100.
Field
List the definition information of the field that has the above format.
Before reading source data, you must define fieldĄ¯s information. About how to get field information.
4. Connect source and target. Create a new DBLink between Oracle dataset and MySQL dataset, and open the property dialog of DBLink, then set the "update mode" parameter.
5. Mapping fields. Click [Field mapping] button in [General] sheet in property dialog of DBLink to open [Set DBLink Fields Mapping] interface. You can edit calculation expression for each target fields, or drop source field to target field by mouse to generate field mapping list.
Necessary Enviroment
Oracle
Must install Oracle client in your machine.
Config Service Name for your Oracle instance.
Sybase
Must install Sybase client in your machine.
Configure data source in [Sybase ASE OLE DB Configuration Manager].
Create a ODBC for Sybase in Windows Control panel.
