Talend Open Studio Primary Use Case

Aymen ANNOUN - PeerSpot reviewer
Solutions Architect at El Djazair Information Technology (ELIT)

Our client wanted an open-source ETL tool to load data from his ERP to PostgreSQL Data Warehouse. Our company usually uses Microsoft technologies, but since the client wanted an open-source product, we used Talend and Postgres based on the client's requirements. So they just used it to pull data from the ERP source to PostgreSQL Data Warehouse.

View full review »
AC
Business Intelligence Intern at a computer software company with 1,001-5,000 employees

I am using Talend Open Studio for ETL. I extra data from APIs and transform it for the data warehouse.

View full review »
Hassan-Mustafa - PeerSpot reviewer
Senior Data Engineer at a financial services firm with 1,001-5,000 employees

We are currently using the free version. We use the solution to extract loads from the source system into the entire house. We are also doing API and data integrations from TXT or XML files.

Though we are not currently using it for big data, there is a plan to extract data from MongoDB.

View full review »
Buyer's Guide
Talend Open Studio
March 2024
Learn what your peers think about Talend Open Studio. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,319 professionals have used our research since 2012.
AaronRumley - PeerSpot reviewer
Software Engineer at Huron Consulting Group Inc.

Our primary use case is for data migration and validations.

View full review »
Celine Meesseman - PeerSpot reviewer
Director at Ingenia

I use the solution in my company to create dataflows and feed the data warehouse required for business intelligence.

View full review »
Azhagarasan Annadorai - PeerSpot reviewer
Founder at Unknown.University

We have used the solution for a real estate agency in Singapore to stream their data on a more or less real-time basis to a mobile app. Their backend system is primarily built on SAP. They used a combination of Kafka message querying and Talend to stream the data into a NoSQL environment, which is MongoDB. The solution basically streams the data from SAP backend systems, all the way to a NoSQL MongoDB database, to support a real-time or near real-time data flow into a mobile app. 

This mobile app will be a consumer-facing app. The end consumers will be able to look at the status of their real estate space. Users are mostly the tenants who either rent or lease commercial or residential spaces. The status of their leased property will be made available via a mobile app. The data solution comprised of technology such as Kafka for message queuing, Talend for data flow streaming, and MongoDB for storing the data. That's one use case.

The second problem solved using Talend is to build the data lake for internal data analytics at a government organization, again based in Singapore. Their backend systems are primarily supported by Sybase databases. From the Sybase databases, selective data is brought into a staging area via Qlik Attunity, which is a real-time data synchronization tool that uses the change data capture mechanism. Once the data comes to the staging environment through Attunity, then Talend takes over. Talend pulls that data and moves it to Cloudera's big data solution, the big data platform. Then, Tableau is used for data analytics and data visualization. This solution is set up for internal data analytics within the government organization.

View full review »
TJ
Computer engineer at a engineering company with 10,001+ employees

There are two main use cases related to the solution, one of which is building an ETL for a data warehouse and creating an automatic process related to jobs with some targets and some goals to prepare data for the company.

View full review »
RM
Data Analyst at Object Nation PL

We use it to construct a robust data warehouse. This involves seamlessly integrating data from diverse sources into our data warehouse. It plays a crucial role in ensuring data cleanliness and quality throughout the integration process. We also use it for effective fraud detection measures, further enhancing the reliability and security of our data warehouse.

View full review »
CB
Architect at Elections Canada | Elections Canada

I use the open-source version of this solution. It's data integration-related. Right now, I'm doing some legacy TL into a new enterprise data repository.

View full review »
EB
Developer with 1-10 employees

I primarily use the solution for integration. I consolidate data from several different databases and spreadsheets and merge systems into Amazon Redshift.

View full review »
SN
Works

I use Open Studio for the day-to-day management of our data architecture warehouse. 

View full review »
WS
Solution Leader at HORSA

Talend Open Studio is mainly with data warehouses. It is also used for data masks. There are so many types of projects we can do with Talend.

View full review »
Archan Chatterje - PeerSpot reviewer
Consultant at Keyrus

We primarily use the solution just to pull the data from the source to the landing zone. We are using the administrative console as well.

View full review »
Omar_Ismail - PeerSpot reviewer
ECM, Archives and Digital Preservation Consultant at DataServe

We use the solution for integration, warehousing, and enterprise service costs.

View full review »
KP
VP Bigdata and Analytics at Pharos Analytics Lab

My company uses Talend Open Studio to support ETL processes.

View full review »
ZK
Developer

I use Talend for different projects as I am studying business intelligence. 

I am using Talend for data integration and integrating Oracle and SQL Server, specifically using it for collecting data from Oracle and charging it to SQL Server.

View full review »
Sivanandam Krishnan - PeerSpot reviewer
Practice Lead at GainInsights Solutions

The solution can be deployed on the cloud and on-premise.

View full review »
VM
Senior Data Engineer at a tech services company with 10,001+ employees

We use this product for broader data synchronization, data storage, data transformation, data integration, and other data processing.  

View full review »
YA
Implementation Specialist, Individual Contributor at a computer software company with 201-500 employees

I'm currently doing the research and testing it on my machine. Our use case is to extract or manipulate data from one database to another one in a structured form.

View full review »
Celine Meesseman - PeerSpot reviewer
Director at Ingenia

We are a solution provider and Talend Open Studio is one of the products that we implement for our clients. I work as an integrator and a data flow developer.

The primary use case for Talend is data integration. It is typically used by engineers and managers.

View full review »
JN
Solution Principal at DXC

The primary use case for the solution depends on the customer, however, most likely in my case, the industry it would be under would be oil and gas.

View full review »
MS
CEO at Solutia, s.r.o.

We use this solution for data integration, especially in our big data projects.

For the past year, we have also been using Talend Open Studio for process automation. Some of the operations done by human beings are now automated. We also deliver this solution to our customers. 

Currently, all of the solutions that we deliver to our customers are on-premises.

View full review »
RM
Business Intelligence Specialist at Irving Oil

Integration jobs.                                                                                    

View full review »
FN
Principal Associate at Data Meaning, Inc.

We were using the entire Talend solution for the last client, but it was only for integration between the databases and the data warehouse. It was a standard ETL job. We have Talend Open Studio deployed on our desktop, but we used the Talend cloud service for our clients.

View full review »
SG
Senior Manager MI & BI (Senior Vice President) at Faysal Bank Limited

We have been using Talend for ETF functions in connection with our RDBMS system.

We are in the process of moving from RDBMS to Big Data, so we may not be using Talend in the future.

View full review »
OB
BI developer at a comms service provider with 501-1,000 employees

I use this solution for development purposes. This solution is installed on my PC. For the project that we're currently working on, I am the only user.

View full review »
GD
Data Architect with 1,001-5,000 employees

We use the Professional version of Talend for data integration between our IBM mainframe and Oracle to populate the Enterprise data warehouse.

It handles feeds from heterogeneous sources such as MS SQL, PostgreSQL, and flat files.

View full review »
VB
Information System Architect at Astvision

We are a system integrator and this is one of the products that we implement for our clients.

View full review »
PE
Expert Consultant CRM at a tech services company with 1-10 employees

We have migrated to the Talend Open Studio version 7.3. but have not used it yet. I have only done some testing on another computer to see how the new version is functioning.

We use Talend Open Studio only to do the ETL from our database, it takes XML files and converts them to CSV. Talend Open Studio transforms files on the website and modifies them for the database.

View full review »
HO
Consultant Business Intelligence at a tech services company with 501-1,000 employees

We use it to integrate data; we take several folders, transform them, and store them in the database, which is PostgreSQL.

View full review »
WM
Practice Head, Analytics at a tech services company with 201-500 employees

One use case for Talend Data Management is using it for data integration from multiple data sources and then to build our customer's golden record.

View full review »
Senior System Administrator at a tech company with 501-1,000 employees

We use the on-prem model of this solution. Our primary use case is for connecting legacy applications. We fill a new ERP and we also fill some legacy applications which we can integrate directly in ERP so we use Open Studio for this integration.

View full review »
WM
Practice Head, Analytics at a tech services company with 201-500 employees

One of our clients' use case was for data integration from multiple sources and then to build our customer golden record.

View full review »
AM
Senior BI Developer at a tech vendor with 11-50 employees

I use Open Studio for operational data in the telecom industry. We were working with the data, connecting or joining the tables between different data sources with a very large volume. We perform data preparation and transformation and then look deeper into the details.

View full review »
it_user948867 - PeerSpot reviewer
Software Engineer at a tech services company with 51-200 employees

We use Talend for the collection of data from many different sources. We use it mostly as a data integrator.

View full review »
IA
Assistant Manager at a tech services company with 1,001-5,000 employees

Our primary use case is for creating an information hub for the bank database. 

View full review »
JS
Board Member at a real estate/law firm with 1-10 employees

I'm a board member of our company and we are a customer of Talend. Our primary use case at the moment is working on data migration projects, migrating data from different databases and consolidating them. 

View full review »
AV
System Analyst at a tech services company with 501-1,000 employees

We are integrators of Talend and I'm a system analyst.

View full review »
Buyer's Guide
Talend Open Studio
March 2024
Learn what your peers think about Talend Open Studio. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,319 professionals have used our research since 2012.