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

how to put data in fact table?

i'm new in business intelligence and i design a star schema that implement a data mart to help analyst to take a decision about student grades dimensions tables : - module (module code, module name) that contains information about the module -…
Mohammed Amnay
  • 73
  • 1
  • 1
  • 5
3
votes
2 answers

Talend Second Sequence number

i've got the following data: ID;NAME;SKILL 1;JOE;XML 1;JOE;JAVA 1;JOE;ORACLE 2;JOHN;JAVA 2;JOHN;API I need a counter that will give me this…
user2742409
  • 315
  • 5
  • 21
3
votes
2 answers

Talend Casting of JSON string to JSON or JSONB in PostgreSQL

I'm trying to use Talend to get JSON data that is stored in MySQL as a VARCHAR datatype and export it into PostgreSQL 9.4 table of the following type: CREATE TABLE myTable( myJSON as JSONB) When I try running the job I get the following…
codeBarer
  • 2,238
  • 7
  • 44
  • 75
3
votes
1 answer

Big query load fails with Bad Character (ASCII 0) while importing Datastore backup

This may look like already discussed scenario. I am trying to load Google App Engine DataStore backup into BQ using Talend tBigQueryBulkExec component, which does same as BQ Shell CLI. It connects to BQ and tries to read files from GCS and move to…
user4033385
  • 553
  • 1
  • 7
  • 16
3
votes
4 answers

Talend: How to use relative path in tFileOutputExcel or how to get the project dir?

Working with talend, I want to keep the project portable and therefore I need to avoid hardcoded absolute paths. Now I need to export a file as XLSX. Assume my project resides here on my local hard drive under Windows…
Uwe Heim
  • 178
  • 2
  • 10
3
votes
2 answers

How to share a database connection with a joblet in Talend

I have a job with a tMSSqlConnection setup, and I need to share that connection with a joblet. I found instructions online saying to register it as a shared connection, and then add an option in dynamic settings of the joblet components with that…
Atari2600
  • 1,219
  • 2
  • 13
  • 26
3
votes
5 answers

How to split one row in different rows in TALEND

I need help to migrate one row from old DB to multiple rows in my New DB. I have a data like: OID CUSTOMER_NAME DOB ADDRESS 1 XYZ 03/04/1987 ABC In my new DB i am storing data in KEY VALUE pair…
user3592257
  • 105
  • 1
  • 3
  • 16
3
votes
1 answer

Passing parameters from TAC for job execution

I have a job that is quite generic and differing parameters are passed as context parameters from different files. But i still need to "hardcode" the context file name and create multiple jobs in TAC (Talend Administration Console) for execution.…
user1486984
  • 287
  • 2
  • 6
  • 16
3
votes
1 answer

Export Talend items from talend studio put on SVN and build it from Jenkins

Hi I am using talend open studio 5.5. I want to export talend job and put into the SVN. It contains the following files. 1) process a) .items b) .properties I want to build talend job from this and create jar, bat and sh files as created when…
Avinav Mishra
  • 718
  • 9
  • 12
3
votes
1 answer

Talend tXMLMap get all ocurrences of element without looping

I am learning Talend and I need to a XML to CSV mapping that I cannot make work right. I have a document like this (really simplified):
trompa
  • 1,967
  • 1
  • 18
  • 26
3
votes
1 answer

Loading Hive table from Windows machine (Load data local inpath)

I am trying to load a Hive table using a file from Windows. But I am getting the following error: java.sql.SQLException: Error while compiling statement: FAILED: IllegalArgumentException java.net.URISyntaxException: Expected scheme-specific part at…
Nishanth
  • 51
  • 5
3
votes
2 answers

Talend tHBASEConnection and tHBaseInput for MapR

I have access to an edge node to a MapR Hadoop cluster. I have an HBase table named /app/SubscriptionBillingPlatform/Matthew with some fake data. A scan of it in the hbase shell results in this: I have a very simple Talend Job that should scan the…
Matthew Moisen
  • 16,701
  • 27
  • 128
  • 231
3
votes
1 answer

Talend query data in mysql based on inputs from hive

I have a requirement to query a column in Hive and based on the output I want to query it in MySQL DB. The flow is something like below: Query Hive table, get the list of IDs Use the list of ID's to query MySQL table. The query would be like…
Rakesh Shrama
  • 249
  • 1
  • 5
  • 16
3
votes
1 answer

Handling data truncation in Talend

I am copying data from Excel sheet to the SQL server tables. In some of the sheets I have data bigger in size of the Table's schema in SQL. i.e. Table's column has data type nvarchar(50) where as my Excel sheet has data of more than 50 characters in…
Quick-gun Morgan
  • 338
  • 12
  • 31
3
votes
1 answer

How to end tLoop when desired criteria reached

Here is my process: You can see the Java code in tJava_1. It parses out the data from the file and if it reached the last search page it will set a value to true. This is meant to be the stop criteria for the tLoop_1, as shown here: Am I handling…
ZedBrannigan
  • 601
  • 1
  • 8
  • 18
1 2 3
…
99 100