Need advice about which tool to choose?Ask the StackShare community!
Talend vs Xplenty: What are the differences?
Talend: A single, unified suite for all integration needs. It is an open source software integration platform helps you in effortlessly turning data into business insights. It uses native code generation that lets you run your data pipelines seamlessly across all cloud providers and get optimized performance on all platforms; Xplenty: Code-free data integration, data transformation and ETL in the cloud. Read and process data from cloud storage sources such as Amazon S3, Rackspace Cloud Files and IBM SoftLayer Object Storage. Once done processing, Xplenty allows you to connect with Amazon Redshift, SAP HANA and Google BigQuery. You can also store processed data back in your favorite relational database, cloud storage or key-value store.
Talend can be classified as a tool in the "Big Data Tools" category, while Xplenty is grouped under "Big Data as a Service".
I am trying to build a data lake by pulling data from multiple data sources ( custom-built tools, excel files, CSV files, etc) and use the data lake to generate dashboards.
My question is which is the best tool to do the following:
- Create pipelines to ingest the data from multiple sources into the data lake
- Help me in aggregating and filtering data available in the data lake.
- Create new reports by combining different data elements from the data lake.
I need to use only open-source tools for this activity.
I appreciate your valuable inputs and suggestions. Thanks in Advance.
Hi Karunakaran. I obviously have an interest here, as I work for the company, but the problem you are describing is one that Zetaris can solve. Talend is a good ETL product, and Dremio is a good data virtualization product, but the problem you are describing best fits a tool that can combine the five styles of data integration (bulk/batch data movement, data replication/data synchronization, message-oriented movement of data, data virtualization, and stream data integration). I may be wrong, but Zetaris is, to the best of my knowledge, the only product in the world that can do this. Zetaris is not a dashboarding tool - you would need to combine us with Tableau or Qlik or PowerBI (or whatever) - but Zetaris can consolidate data from any source and any location (structured, unstructured, on-prem or in the cloud) in real time to allow clients a consolidated view of whatever they want whenever they want it. Please take a look at www.zetaris.com for more information. I don't want to do a "hard sell", here, so I'll say no more! Warmest regards, Rod Beecham.
Pros of Talend
Pros of Xplenty
- Simple, easy to integrate/process data without coding2