Stack Overflow
Stack Overflow

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
5
votes
1 answer

Compare String using tMap

I am using Talend to prepare dataware. I want to compare the string with the contents of a column using the tMap component and create a variable to store in the DB. The problem is that the == operator does not give the right result (Example:…
Ahmed BEN MANSOUR
  • 53
  • 1
  • 1
  • 3
5
votes
1 answer

Cipher/Encrypt and uncrypt passwords in .properties files using Talend Data Integration

One suggested way to run jobs is to save context parameters in properties files. Like this one: # #Wed Dec 16 18:23:03 CET 2015 MySQL_AdditionalParams=noDatetimeStringSync\=true MySQL_Port=3306 MySQL_Login=root…
MordicusEtCubitus
  • 703
  • 8
  • 10
5
votes
2 answers

Need to Get the current DateTime in the Talend Studio?

I am working the Talend studio tool for data migration. Now I want to set the Current DateTime in the Date field. I get the DateTime from this code TalendDate.getDate("yyyy-MM-dd HH:mm:ss") but it returns String type data. But I need Date type to…
Rajesh kannan
  • 71
  • 1
  • 2
  • 11
5
votes
1 answer

Talend export and import a job

In Talend (particularly MDM Studio TOS and TOP 4.2.3 on Windows 7), how can I export a job so that it can be imported on a separate machine, into an existing workspace.
Uyghur Lives Matter
  • 18,820
  • 42
  • 108
  • 144
5
votes
2 answers

tRest and map JSON with tExtractJSONField with TALEND

I'm quite new to Talend and I am stuck with getting JSON data using tRest. We Suppose that I am trying to get all posts from social networks. That's why I am using https://tagboard.com to get data which is formatted in JSON. Here is one of the…
Ali Ben Messaoud
  • 11,690
  • 8
  • 54
  • 87
5
votes
1 answer

Talend - Combining two rows into one

Sample Input Here is an example of my input. As you can see, the address column has 2 values which I would like to separate and then combine into one value. Expected Output This is what the output should be, Combined values into one cell. Talend…
jc carmelo
  • 133
  • 4
  • 13
5
votes
2 answers

Talend: Update global variable in subjob

My simplified job look like this: tSetGlobalVar--->(onSubJobOK)--->tRunJob--->(onSubJobOK)--->tJava tSetGlobalVar will define a global variable and its initial value let's say: myKey:"firstValue" tRunJob will run a sub job which contain only a…
54l3d
  • 3,913
  • 4
  • 32
  • 58
5
votes
3 answers

Talend - generating n multiple rows from 1 row

Background: I'm using Talend to do something (I guess) that is pretty common: generating multiple rows from one. For example: ID | Name | DateFrom | DateTo 01 | Marco| 01/01/2014 | 04/01/2014 ...could be split into: new_ID | ID | Name |…
abierto
  • 1,447
  • 7
  • 29
  • 57
5
votes
1 answer

Talend: java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path

I have the jar and dll in the Talend lib directory. The path and classpath are set. I also have downloaded and installed the VC++ 2005 redistribution sp 1 patch and the missing dlls that are supplied by SAP. I have tried to run this ETL job on a…
user1082748
  • 365
  • 1
  • 7
  • 18
5
votes
3 answers

How to create multiple output files in Talend based on a column from an SQL Input

I have a need of creating multiple output files based on a value (column) from an sql input in Talend Open Studio. My tMSSQLInput returns about 50,000 rows in which where one of the columns is the building_name Building A Building B Building…
Viriato
  • 2,981
  • 7
  • 40
  • 54
5
votes
1 answer

Running parallel jobs in talend

I have a situation where i need to run five different child jobs in talend in parallel. Problem is that, in my select query i would be getting five different ID's and then for each particular id , i need to run five different jobs. Problem with…
Nitish Sharma
  • 331
  • 4
  • 7
5
votes
1 answer

Talend Open Studio For MDM + Postgresql + synchronization of two databases

I have two database A and B(replica of A) now one live web application is entering data into A now i want that the entries done in A should be reflected in B.(i.e the changes in A should automatically reflect in B). My sole purpose is synchronizing…
Jyoti Kumari
  • 96
  • 7
5
votes
3 answers

How to log progress of tasks in Talend Open Studio?

I have some sample jobs that migrate data from one database to another and I would like to have some information about the current progress, like the one you have when the job is run interactively from the application itself (I export and run it…
Bax
  • 4,260
  • 5
  • 43
  • 65
5
votes
1 answer

Expose Talend ETL Job as a Web Service

I am currently evaluating Talend ETL (Talend Open Studio for Data Integration). I would like to know how / if i can expose an ETL Job as a Web Service. I know i can export jobs as web services and invoke them through a specific URL however, my goal…
tpanagopoulos
  • 137
  • 2
  • 3
  • 11
5
votes
4 answers

Quickstart database migration using Talend

I have this requirement to migrate a live SQL server 2008 to MySQL server 5, I have tried the MySQL migration toolkit but its throwing lots of migration errors. Someone here in Stackoverflow suggested that I use Talend. I installed Talend Open…
quarks
  • 33,478
  • 73
  • 290
  • 513
1 2
3
…
99 100