Migrate table from one database to another

[Anonymous]

Hi there,
Newbie here.
I'm probably not getting one of the fundamental concepts of Talend Open Studio.
What I'm trying to do is migrate a single table from one database (MySQL) to another (PostgreSQL).
Both databases have a table with addresses, say AddressOld and AddressNew. The columns in AddressNew are different from those in AddressOld (different names and different types).
I'm dragging the source and destination table onto the canvas, then link them and drop a tMap on the link. No matter what I do, I am not able to get to a dialog where I can choose which field of AddressOld is to be mapped to which field of AddressNew.
No matter what I do I get either the metadata of AddressOld or AddressNew on both sides in the tMap editor, not AddressOld on the left hand side and AddressNew on the right hand side.
I've watched a tutorial where the Job Templates function is used from the Enterprise Edition, which does not exist in Open Studio. I've also read some threads that say with Open Studio you'd need to do one table at a time, which is perfectly fine with me.
Any help/pointers much appreciated.
regards,
Jan

[Anonymous]

Same as above but use tOracleOutput.

[Anonymous]

Hi,
Have you checked the related forum: https://community.talend.com/t5/Design-and-Development/complete-migration-from-oracle-to-sql-server/...?
Best regards
Sabrina

[Anonymous]

hi,
My Requirement is i want to copy one table from oracle 12c database to Ms sql server database in talend.
Thanks,
Shekar

[Anonymous]

Hi ,
I want Basics in Talend Like tables copy,columns and table creation and load the data from excel sheet.

Thanks,
Shekar

[_AnonymousUser]

Hi,
I build a job with MySql server in Talend Studio. Could you please tell that how can I export the same job and run the same with oracle database in another machine which doesnt have Talend Studio
Thanks

[Anonymous]

Hi,

I build a job with MySql server in Talend Studio. Could you please tell that how can I export the same job and run the same with oracle database

Is your source file from MySql DB? If so, you can migrate your table by creating a job as:tMySqlInput_1--main--tOracleOutput.
The Build Job feature allows you to deploy and execute a Job on any server, independent of Talend Studio(JDK installed).
Please take a look at document about:TalendHelpCenter:How to build Jobs
Best regards
Sabrina

[_AnonymousUser]

Hi,
  I have 5 parameter values in a property file. I need the 5th parameter value to be passed to a query. How can i get the value from property file.
Thanks

[Anonymous]

Hi,
We usually use tcontextload to  load a context from a flow.
You can design your job like:tFileInputxxx(parameter value)-->tcontextload
                                                  onsubjobok
                                             t<DB>Input(pass context.parameter in query)-->output
Best regards
Sabrina