Can't transform data between Oracle and MySql

[prakash_it55]

Hi,
I'm new to Apatar,I tried to transform data from oracle table to MySql table but its not working.

Here are the steps I did,
1. Drag-and-drop the Oracle connector.
2. Configured the Oracle connection and selected the corresponding table.
3. Select the Insert mode option and also selected the primary key field.
4. Drag-and-drop the MySql connector.
5. Configured the Mysql connection and selected the corresponding table.
6. Select the Update option and also selected the primary key field.
7. Drag and drop the Transform from operations.
8. Configured the fields.

Finally I used Run and Preview option in Transform, its showing some data were Processed in a panel and in a separate panel I can see the data also, but actually nothing was inserted in Mysql Table.

Please suggest me if I missed anything,

Thanks,
Prakash

[Sergei]

Hello Prakash,

You need to press Run and Preview on the target connector - MySQL connector. In this case your data will be populated in your database.

Regards,
Sergei

[Guest]

Hi Sergei,

Thanks for your reply and I did that too it shows those records in Apatar, but not getting inserted in MySQL database.

Thanks,
Prakash.C

[Sergei]