Questions tagged [talend]

Talend is an open source integration vendor that provides software for data integration, data quality, master data management, big data, business process management and service-oriented architecture.

Talend offers integration software along five axes:

  • Data Integration (ETL and ELT)
  • Data Quality (Profiling, Cleansing, Stewardship)
  • Master Data Management
  • Enterprise Service Bus (ESB - SOA)
  • Big Data

For each of these domains, Talend offers a freely downloadable version of their software licensed under GPL, and an extended enterprise version that comes under a subscription license but also includes access to the source code if desired.

On the open source side, the product list is:

  • "Talend Open Studio for Data Integration"
  • "Talend Open Studio for Data Quality"
  • "Talend Open Studion for MDM" - Master Data Management
  • "Talend Open Studio for ESB" and "Talend ESB Standard Edition" - Enterprise Service Bus
  • "Talend Open Studio for Big Data"
  • "Talend Data Preparation Free Desktop"
  • "Talend Data Streams Free Edition"
2775 questions
0
votes
1 answer

Talend Open Studio: delimited file with semi colon and header with quotes

I have a delimited file that is delimited by semi colon. The first row in this file is the header, and the header tokens are in double quotes: an example is below: "name", "telephone", "age", "address", "y" When using the tFileDelimited and tMap and…
Palu
  • 668
  • 3
  • 11
  • 26
0
votes
2 answers

Create Increment Counter Everytime Running A Job In Talend Using tMap

I Would like to ask how to create a specific counter every row if i run a job in Talend Data Integration when using tMap components For Example, this is a result in which there are 5 data in every row has 0 counter Table Animal Animal Counter…
Gekif
  • 15
  • 1
  • 5
0
votes
0 answers

Empty FactTable when using Talend

I constructed my database in mysql. I constructed next of the dimensions except (time dim). After filling the fact table, I realize that it is always empty. How can I solve this problem?
ena
  • 59
  • 1
  • 5
0
votes
0 answers

Can I Extract, Translate, and Compare using Talend?

I am evaluating Talend and I have little experience using the tool. My question is regarding audit. Does Talend offer a way to run with an audit option that extracts the source data, transforms it and then compares the transformed data to the…
MikeJRamsey56
  • 2,779
  • 1
  • 20
  • 34
0
votes
1 answer

How to run different sub job based on number of input values Talend

I am passing some values Jenkins to Talend to run job. I would like to run different sub job if there is one input value and another job if there are 3 input values. Is there a way I can do that in Talend ?
jmf
  • 356
  • 5
  • 25
0
votes
2 answers

To split 1 String into multiple rows

I have input file like - 101 | This is split example I want to this string "This is split example" into multiple rows. 1st 10 rows in 1st row 2nd 10 rows in 2 row and so on Output file as like - 101 | This is sp 101 | lit exampl 101 | e Using Talend…
0
votes
1 answer

Best way to migrate ETL-Jobs from free Talend Open Studio to Talend Server?

I have lot of defined etl jobs in talend open studio. This etl-jobs are in dedicate git repo (whole workspace). But now we want move this etl jobs to talend server. And whats the best way to do that?
user5517842
0
votes
1 answer

How to connect an SOAP API in PHP of Boondmanager ERP with Talend

I want connect my BoondManager ERP with Talend. I need to Extact the Database of Boond. I tried to use WSDL file.but i couldn't retrieve the schema I wanna really just establish the connection between the Boond Aplication and talend to extract…
0
votes
1 answer

How to automateTalend Job2Docker jobs to Kubernetes

Can someone give me some guidance on best practice to bring multiple Talend jobs dynamically into Kubernetes? I am using Talend Open Studio for Big Data I have a listener server for Job2Docker How do I change the scripts to automate a push to…
Anton Swanevelder
  • 1,025
  • 1
  • 14
  • 31
0
votes
2 answers

JSON parsing multiple nested arrays

I am trying to parse below json, which has multiple nested lists (input & output), how do I parse it ? { "status":"current", "entry":[{ "item":{ "name":"Task1", "identifier":"T00001", "input":[{ …
K S
  • 85
  • 1
  • 8
0
votes
0 answers

Add a column which is the result of two queries

code Table code_grille code_grille_talend s01 4 7 2 8 s02 5 2 8 9 6 3 7 s03 3 6 4 7 5 8 2 s04 2 6 4 8 5 2 8 0 s05 4 7 8 5 9 7 4 5 8 s06 2 4 7 8 9 3 6 5 s07 2 5 4 7 8 s08 …
0
votes
1 answer

Moving the files to done folder after ETL process is done in Talend

I need to move the files after they went through the ETL process into a done folder. However, since they are now placed inside a (working directory), when they are done and I move them to "done" directory, I keep on getting null errors, since I…
0
votes
1 answer

Unable to upload the talend job zip file from windows machine to tac through metaservlet api

Unable to call the associatePreGeneratedJob api endpoint. Keep getting the 180 error. Trying to upload the zip file from Windows machine to a tac server that is running on docker container Talend documentation: Command:…
0
votes
1 answer

How to check Salesforce's API Usage from Talend

I'm trying to read the API usage, there's a way to do it from the Salesforce console (Setup->Company Information->API Request Usage), I'd like to know how to do it by Talend.
0
votes
1 answer

Autoincrement field after the max number storred in db through talend

I am working on inserting data to database through talend ETL tool. For one of the field I have an auto increment number. however if I kill the server in talend and I start again, I have to empty the database because it will get duplicate (auto…
1 2 3
99
100