Adapted for JasperETL powered by Talend version and later. At the top of JasperETL main window, a tool bar as well as various. Jaspersoft ETL is Talend ETL. Here is a list of Talend courses: Integration Software Course List. When used with the Jaspersoft Business Intelligence suite, Jaspersoft ETL enables Learn how TIBCO turns data—big or small—into differentiation at.
|Published (Last):||5 February 2010|
|PDF File Size:||16.11 Mb|
|ePub File Size:||18.8 Mb|
|Price:||Free* [*Free Regsitration Required]|
In this article, we introduce the tXMLMap component by transforming a list of customers having several addresses into a tabular representation using a table for the customers records, and another table for the list of adresses owned by each customer. The expected output will be two lists of records, one for the customers and another for customer’s addresses:. The input file used to jaasperetl customers in XML format can be downloaded here. But we won’t uasperetl to generate rows from this file.
Instead, we will read the whole file content at once. Do not forget this or you won’t be able to carry on with this example. We suggest that you read these, tutirial if they may seem a bit difficult to understand at first they were for me.
Take time to test each option one by one, it will greatly help you to understand all the potential of jaspperetl great component.
Configure tXMLMap so it looks like this:.
You can create the tree manually by right clicking on Customers and adding sub-elements and attributes by hand. The tXMLMap component will parse it and automatically guess its structure. This is the right way to do it. Once this is done, you need to set the loop attribute on the CustomerAddress element by jaxperetl clicking on it.
So this was the uasperetl difficulty of this exercise. To split customers on their multiple addresses, we are going to iterate on address elements instead of customer elements. Now, create the two output relations as described, close the box and connect each of these to a tLogRow in tabular mode.
Run the job and jaspereto the result below:. Yes, this clearly does the trick. We have successfully split each customer address into a row containing the customer id and the address belonging to him.
Learning JasperETL: any training materials?
But we’ve got 8 customers records in place of the 2 that we need. This is because we loop on addresses, so a customer record is created each time we find a different address. We could add a tUniqRow component to remove duplicated customer records, but fortunatly tXMLMap allows to loop on different elements for each output flow.
You will get this:. You cannot set the second loop on the Customer element, because loop cannot be set both on an element and on its child or parent.
So we choose to iterate on customer’s names to get customer records.
Jasperetl jasperserver tutorial jobs
Now, note the green dots and red cross in the jasperretl of each output relation. This means that Talend does not know on which loop to iterate to create the output relation. Click on each of them and add the corresponding sequence: CustomerName for customers and CustomerAddresses for adresses.
Now, validate and run your job one jasperefl time:. This time, we’ve got a good tabular representation with just the right number of record for each output flow! But they can do much more as generating XML as output flow, aggregating and grouping data and others.
In our next article we will do the work in the other way: Ce tutoriel vous a plu? Python vous tente et But XML represents data as a tree, which is ajsperetl to store hierarchical data, lists of lists and such.
Related Work — petl documentation
Moving from a two-dimensional tabular data representation to a tree representation is not so easy. But fortunately, Talend DI provides great tools for this. One of these is the tXMLMap that we propose to discover in this tutorial.
Configure tXMLMap so it looks like this: Run the job and see the result below: You will get tutoriial Now, validate and run your job one last time: