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
2 answers

Google BigQuery doesn't parse nullable 2nd timestamp field

I'm trying to import a large amount of data into a flat table using CSV. During the import BigQuery reports: - File: 0 / Line:6659 / Field:11: Could not parse '' as a timestamp In the schema I have 2 timestamps: fields 4 and 11 . Both are nullable.…
Wouter
  • 422
  • 5
  • 11
4
votes
2 answers

Talend: Query Database with Strings/Parameters already defined

How can I perform a Query to my Database (using tOracleInput), like a Select, and use Strings that are already defined as parameters in other components, for example in a 'tFlowToIterate' ? For example: "SELECT * from TABLE_X where FIELD_X= ? ;" My…
user2144555
  • 1,315
  • 11
  • 34
  • 55
4
votes
1 answer

Talend internal variables

I am doing a data migration project in Talend and for one of the tasks i need to process a big table with many columns and map the (old) data to a different value for the new model. I have a unique mapping table with three columns. Example: Column…
Juan Jose
  • 97
  • 1
  • 8
4
votes
1 answer

Autonomous Talend job fails with 'Error: Could not find or load main class...'

I have exported a Talend (5.2.0) job as an autonomous job and deployed it to my production server (Windows 2008 R2 Standard 64bit). I have found the JVM and added it to the PATH environment variable of the server as it was not being found. The JVM…
Born2BeMild
  • 534
  • 1
  • 4
  • 16
4
votes
3 answers

Splitting data by column value into an indefinite number of tables using an ETL tool

I'm trying to split a table into multiple tables based on the value of a given column using Talend Open Studio. Let's say this column can contain any of the integer values of 1, 2, 3, etc. then according to this value, these rows should go to…
user1765796
  • 43
  • 5
4
votes
1 answer

SQL Server: Can I use EXEC to run an external Application?

Hello and thank you for your time, I have been searching everywhere online for an example, where a SQL trigger will run an external application, but I have had no luck. All I am seeing is that the EXEC will execute a SQL procedure. The reason I…
jnoel10
  • 295
  • 2
  • 4
  • 14
4
votes
1 answer

Data Warehouse ETL slow - change primary key in dimension?

I have a working MySQL data warehouse that is organized as a star schema and I am using Talend Open Studio for Data Integration 5.1 to create the ETL process. I would like this process to run once per day. I have estimated that one of the…
Jubbles
  • 4,450
  • 8
  • 35
  • 47
4
votes
1 answer

How to connect with database in talend

I am facing a problem while connecting to my Access Database. I have selected the Database but when I checked the connection, an error message appear. The error message is : [Microsoft][Pilote ODBC Microsoft Access] Ressources système insuffisantes…
Maria Jahan
  • 87
  • 1
  • 2
  • 4
4
votes
1 answer

Talend Training/Tutorials

Can anyone recommend a good source of material for learning how to use Talend Open Studio For Data Integration? I've had a look at the TalendForge tutorials but was wondering if a more cohesive training resource exists for beginners? I've search…
TJ Amas
  • 1,291
  • 13
  • 19
3
votes
0 answers

JavaMail Issue: Can't send command to SMTP host

I'm trying to send a mail via Talend ETL tools (using Java code), sometimes the mail get trigger successfully, but very often it bumps into the error below. StartTLS has been enabled, this inconsistent issue has only start to appear 1 month ago We…
RionArisu
  • 31
  • 1
3
votes
1 answer

Importing talend collection to postman

How can we import talend collection to postman? I found a way to import postman into talend but not the other way round. Is there any script or tool to do the migration?
best wishes
  • 5,789
  • 1
  • 34
  • 59
3
votes
1 answer

Migrate data from Schema free database to Relational Database : MongoDB to Snowflake

We had a use case that lead me to write this and I am sure many of you would have faced this situation. The situation was to migrate multiple collections from MongoDB into Snowflake Database through a single Talend job and retain the top level nodes…
Biraja Mohanty
  • 166
  • 5
3
votes
2 answers

Strategy to load a set of files in Talend

I want to know which is best strategy to aboard the following problem in Talend: I need to load data from a set of delimited files that are stored in a directory with names like (SAMPLE1.DAT, SAMPLE2.DAT, ... , SAMPLEX.DAT) The target will be a…
PabloCocko
  • 110
  • 1
  • 8
3
votes
1 answer

Snowflake Query Killed: "SQL execution canceled"

I've got a Talend job running with a couple of dataflows running in parallel against a Snowflake database. An update statement against Table A is causing an update on Table B to fail with the following error: Transaction 'uuid-of-transaction', id…
Nick Heidke
  • 2,787
  • 2
  • 34
  • 58
3
votes
1 answer

Talend: Aggregation summary?

I've seen how to use tMap in TOS to map different fields in a SQL-like JOIN. How do I aggregate based on certain fields? If I have two tables: [ A, B, C, D ] and that are tMap'ped to [ B, C, F, G ] [ B, E, F, G] how can I aggregate…
batman
  • 1,447
  • 5
  • 16
  • 27
1 2 3
…
99 100