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

Talend - Exception in thread "main" java.lang.Error: Unresolved compilation problems: The import routines cannot be resolved

While working on Talend Integration Open Studio v7.3.1 & v7.2.1, I am facing below error: Exception in thread "main" java.lang.Error: Unresolved compilation problems: The import routines cannot be resolved The import routines…
CleanBold
  • 1,551
  • 1
  • 14
  • 37
4
votes
1 answer

Data integration for Magento to Quick Book

I'm currently new to Talend and I'm learning through videos and documentation, so I'm just not sure how to approach/implement this with best practices. Goal Integrate Magento and Quick Book using Talend. My thoughts Initially my first thought was I…
Indrajeet Latthe
  • 374
  • 1
  • 8
  • 22
4
votes
2 answers

I am looking for a solution on the issue(org.apache.hive.service.cli.thrift.TCLIService$Iface) while connecting talend open studio with hive

i am facing this issue while connecting talend open studio with hive. Below is the error: Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/hive/service/cli/thrift/TCLIService$Iface at …
Gyanendu
  • 41
  • 1
  • 1
  • 2
4
votes
2 answers

talend - specify jndi as datasource

I have a talend job that uses tOracleInput component with connection type of ORACLE CUSTOM. It is working well. Now, I have a requirement to use jndi as the database connection. Any ideas how can this be achieved?
lorraine batol
  • 6,001
  • 16
  • 55
  • 114
4
votes
2 answers

receiving batch error running an update on talend into PostgreSQL database

I have a talend solution where inside it rests a tMap --> tPostgreSQLOutput. Inside the schema is a integer(key field) and a Date(Timestamp) in the format of "dd-MM-yyyy HH:mm:ss". The intent is to update the date field with the current time/date…
arcee123
  • 101
  • 9
  • 41
  • 118
4
votes
1 answer

Open source tool to extract data from Temenos T24

Is there an open source tool to extract data from a T24 system to a SQL database? Or maybe a connector for Talend? Thank you
nickfrenchy
  • 293
  • 4
  • 16
4
votes
2 answers

TALEND - tmap component default Date

I am using a tMap component. I have a date field with default pattern as "dd-MM-yyyy". I just need to insert a Blank Value. i tried '01-01-1900',"",TalendDate.getCurrentDate() : However they gave errors. Is there a way to could only insert…
Oggu
  • 323
  • 1
  • 6
  • 18
4
votes
1 answer

Talend - Offline Package Installation

I'm working on a machine which does not have access to the internet, and only has limited access to the other machines on our internal network. I have successfully installed Talend 5.6 and when I attempt to create a new job a window pops up which…
jameselmore
  • 442
  • 9
  • 20
4
votes
1 answer

Outputting a single Excel file with multiple worksheets

Is there a component in Talend Open Studio for Data Integration to be able to output a single Excel file but with 2 separate sheets in it? I want to separate some columns in the original file into another sheet and another set of columns to the…
jc carmelo
  • 133
  • 4
  • 13
4
votes
3 answers

Using Talend to extract HTML Search Pages into .txt files based on input keywords. How can I parse this data End-to-End and write it to MySQL?

To add to the title: I now have a working workflow consinsting of two steps. 1) I extract the HTML Search Result pages for every keyword given in a input.txt file. - e.g.: SAP; Business Intelligence; Talend saved those results and writes them as…
ZedBrannigan
  • 601
  • 1
  • 8
  • 18
4
votes
1 answer

FTP using Talend, get only most recent file?

I have a Talend job that I need to pull down an XML file from an sFTP server to then be processed into an Oracle database. The date of the XML extraction is in the file name, for example "FileNameHere_Outbound_201407092215.xml", which I believe is…
mw90
  • 132
  • 3
  • 12
4
votes
1 answer

Talend - compare 2 files and keep entries that are not common to both

I follow this solution to compare two files in Talend Open Studio. It's seem to work but in my output file, I only have commas for each line. But the number of lines is correct. I don't understand why.
user3682912
  • 43
  • 1
  • 3
4
votes
2 answers

TALEND set a context variable depending from TalendDate

I want to set a context variable depending from a TalendDate routine in the "value as Table" tab which would allow me to select the day of yesterday : TalendDate.formatDate("yyyy-MM-dd", TalendDate.addDate(TalendDate.getCurrentDate(),-1,"dd")) It…
user3463383
  • 43
  • 1
  • 2
  • 6
4
votes
1 answer

Compare 2 files and keep entries that are not common to both

I have a CSV file and a database table as inputs. I need to keep all the records that are in the database table but exclude those that are in the CSV file. It all gets written to a CSV file in the end. All my attempts have resulted in hundreds of…
Ree
  • 863
  • 2
  • 18
  • 38
4
votes
1 answer

How to set up loop element/group element in component tWriteJSONField in TOS

I try to create a tree structure in JSON from a MySQL database. This JSON is used to represent a Path with all its steps I have to grab data from 5 tables and each one is a level in my JSON tree (in MySQL, One-to-Many relationships permit to build…
Elorfin
  • 2,487
  • 1
  • 27
  • 50
1 2 3
…
99 100