Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III

Datastage to Talend

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 ?
Labels (2)
11 Replies
janhess
Creator II

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

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 ...
janhess
Creator II

Could the problem be with the etlconverter?
_AnonymousUser
Specialist III
Author

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
janhess
Creator II

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?
_AnonymousUser
Specialist III
Author

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
Anonymous
Not applicable

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
Anonymous
Not applicable

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

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