Load from multiple tables in one DB to same tables in another DB
I'm new to Talend and i'm trying to create a single job in Talend Open Studio for Data Integration to take the data from tables in one DB (SQL Server) and load them into the same named table in another DB (DB2).
I've done some searching around and found various posts including this one: -
But for some reason i just can't get it to work and wondering if it is to do with Dynamic Schema as i have the No schema defined yet on the DBInput control in my job. The post above looks exactly what i'm trying to do and the guy mentions he is using the open studio as well.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Thanks Nikhil for the response and link to a very good blog post. As mentioned in my original post i was wondering if it was possible without using Dynamic Schema which is only available in the full version and not the open one. In the full version i was able to create a very simple job with a fileinput, flowtoiterate, sql server input, tmap and db 2 output all using a dynamic type single col. This seemed to work perfectly in copying the data from the table i specified in the input file from SQL Server across to DB2.
As i'm unsure if our budget would push to purchasing this version i was wondering if it is possible to accomplish this in the open studio.
I've since created some simple jobs to do the data migration from some troublesome tables in open studio to get by for now.
Unfortunately I don't think there is an equivalent way of doing the same process in Open Studio and Dynamic Schema is an enterprise version functionality.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
