topic Datastage to Talend in Talend Studio

Datastage to Talend

_AnonymousUser — Sat, 16 Nov 2024 13:24:30 GMT

Hi All
We would like to move our Datastage Jobs to Talend and for this we wanted to use the open source ETL Converter Tool ( http://sourceforge.net/projects/etlconverter/files/)
Sadly it appears that the the conversion tool is creating almost all the jobs into the Talend workspace but they are empty when opening them into the design workspace
The item and properties files of each jobs are containing all the information from the datastage jobs .
Does anyone have an idea why the components don't show up in the job ? is there a way to validate the contents of the item files ?

Re: Datastage to Talend

janhess — Thu, 03 Jun 2010 10:30:07 GMT

Have you tried importing the items into a project? What version of Talend are you using?

Re: Datastage to Talend

_AnonymousUser — Thu, 03 Jun 2010 13:09:10 GMT

We have try with 2.4 , 3.2 and 4.0 version and didn't see difference .
The import jobs from a workspace to another is working but still the jobs a showing up empty ...

Re: Datastage to Talend

janhess — Fri, 04 Jun 2010 11:11:44 GMT

Could the problem be with the etlconverter?

Re: Datastage to Talend

_AnonymousUser — Fri, 04 Jun 2010 12:21:10 GMT

Well it might be possible.
So my concern was to test if the .item file was correctly formated but I have difficulties in creating the TalendFile.xsd even with some explanation I ve found on this forum.
Also is there a way to build/compile the item file in order to be sure the jobs is updated in the repository ?
thanks

Re: Datastage to Talend

janhess — Mon, 07 Jun 2010 09:52:16 GMT

If you've got a simple job you could post the item & properties files and I'll see if I can spot anything.
Do you know if anyone else has successfully used the product?

Re: Datastage to Talend

_AnonymousUser — Wed, 09 Jun 2010 13:19:10 GMT

The tool is working for some jobs but not for others, it might come from the syntax used for some specific case but can't figure it out
Thank you for your help , hope you can do something with it
How is possible to upload file thru the forum ?
here is the content of the properties file TxtEnHash_0.1.properties :
<?xml version="1.0" encoding="UTF-8"?>
<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:TalendProperties="http://www.talend.org/properties">
<TalendProperties roperty xmi:id="_id1__TxtEnHash" id="_id2__TxtEnHash" label="TxtEnHash" creationDate="2010-05-09T09:47:13.285+0000" modificationDate="2010-06-09T09:47:13.285+0000" version="0.1" statusCode=""

To see the whole post, download it here
OriginalPost.pdf

Re: Datastage to Talend

Anonymous — Wed, 11 Jan 2012 05:39:13 GMT

Hi All,
I installed ETL converter (1.0.1) on my system and by using this i tried to import DS jobs (Which is in XML format),Its showing properly all the stages everything on ETL converter window but the problem what i am facing is that whenever i am trying export the DS Jobs in TOS 5.0.1 version its showing status as processed but nothing is coming in my JOB design pallete.One thing what i noticed that it is creating item file,properties file in the procees folder related to all jobs but its not generating screenshot file after export it that can be one of the possible cause.....?

I am attaching some images related to this issue.Kindly guide me on the process for importing these jobs any help will be appreciated.
Regards
Ashish

Re: Datastage to Talend

Anonymous — Fri, 31 Aug 2012 13:28:04 GMT

i have tested recently and it's only working with TOS 3.2.3 and the process described in the help file
cheers
-robert

Re: Datastage to Talend

Anonymous — Fri, 13 Jun 2014 12:55:50 GMT

could you please provide me the link, where I can download Talend 3.2.3 version.

Re: Datastage to Talend

Anonymous — Fri, 13 Jun 2014 14:47:59 GMT

http://sourceforge.net/projects/talend-studio/files/Talend%20Open%20Studio/3.2.3/
but this version is no longer supported for a long time and lots of features didn't exist at that time. So it's at your own risk.

Re: Datastage to Talend

Anonymous — Fri, 13 Jun 2014 14:59:56 GMT

Thanks Esabot !
Do we have any converter tool to migrate DataStage code 8.5 to Talend 5.4 ? please suggest