Talend Data Integration

Talend Data Integration allows us to quickly build data integrations without a tremendous amount of custom coding (some Java and JavaScript knowledge is still required).

I like the UI and it's very intuitive. Jobs are visual, allowing the team members to see the flow of the data, without having to read through the Java code that is generated.

Dynamically table creation from new source.

Using contexts with both connections and variables causes some troubles. CLOBs and dates with timestamps have issues.

The server-side should be completely revamped. The documentation is lacking within the product. They need to get better at all aspects of describing how it works and how to use it.

Consumes more CPU and Memory. I feel it's bit less efficient.

Data Transformation

Integration of various sources

It can use multiple type of data

More modules to integrate to more sources

Help from [the] Community

Data Transformation

Version Control

Search

Pricing

Logging

The speed of migration is very good for a Free ETL tool.

The amount of components or connectors we have is impressive.

Talend Data Integration is not high available in the free version.

Talend support for sub-7 version on the latest MacBooks is not good.

Easy to use interface

Designing jobs is very straightforward

Allows the use of custom components to suit specific needs

Syncing with Git should be made easier

Can face issues with certain big data spaces

Support find it difficult to resolve complex issues

data integration

support for different data sources

documentation

memory management

too technical for business users

IDE is slow

JSON parsing, if you are into highly nested JSON object parsing Talend has the ability to display the structure of JSON and allows you to define the extraction logic in the metadata. Same with XML source.

Customization, For mostly all ETL work you will have a component in Talend. And in case you have a very specific requirement you can end up easily designing a custom component that you can code and reuse and share with others.

Talend has a connectivity option to almost all the databases (relational or NOSQ)L and sources available. It also has generic JDBC/ ODBC drivers in case you need it.

I like the ease of deployment across environment (DEV and PROD) with the use of context variables.

The Talend Administration Console TAC is a great place to schedule and monitor your jobs. Probably the interface can be improved.

Reading for multiple sources: Any modern Database, Files, WebServices, etc.

Monitoring and scheduling task dependencies for data loading purposes.

Really useful to design a Data Warehouse, thanks to its built in components for design patterns like SCD, etc.

It's also useful to publish data interfaces via WebServices or REST.

Good and high qualified support team.

Connecting to various databases from classic Relational (MSSQL, Oracle, MySQL, etc.) to No-SQL Databases.

Well documented.

Community which provides plugins, etc.

Installation process of Integration Suite platform.

JAVA memory management. It's easy to get a memory overhead error, and you have to modify configuration files to increase memory manually.

Migration process.

Its an open source tool.

Developers can add new customized components to Talend for specific needs.

It has low cost as compared to commercial data integration tools.

The enterprise version has an option for integrating a variety of data platforms and connects to variety of data sources.

To run a job, a developer need not upload it to the server, jobs can be run locally.

Data loading components for different databases can be improved further. Currently Greenplum target compenents or postgre data target components are not yielding high throughput,

Transformation components can be made visually more attractive and informative.

Syntax used in data transformation can be simplified.