Data integration is a key to our organization's analytics needs. After applying business logic and transformation, we integrate data from multiple applications and store that ...
We used Talend to implement an Enterprise Data Warehouse (EDW) that could contain all Supply Chain information in order to create an evolved reporting system. Moreover, we nee...
We are basically bringing data from multiple places to the EDW using Talend. We are stitching data from multiple places to have a unified business view so that we can understa...
Talend is helping us in getting the data extracted from mediation (Telecom) and transforming it into reports like Prepaid recharge master and credit limit enhancement. Product...
Talend is used at EWS to integrate data between our MS SQL Reporting Server (ERP & Exact Global) and Cloud Apps like Cropin & SalesForce. We implemented it in 2018 and...
COZYROC SSIS+ is a suite of 240+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services. The vendor states that COZYROC is an easy-to-use, code-free library of tasks, components and reusable scripts that aim to significantly cut development time and improve…
Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.
We use Talend to transform data from non-relational databases into relational databases. Talend is extremely robust and versatile, so much so that we have even migrated from other ETL tools and trained employees in order to use Talend. It is versatile in the sense of readability, it can read many more types of files and you are able to interact much more with the data.
If you are ingesting heavy data, Talend is the right tool for you. If you are just casually transforming data, then a less high-end tool would be better suited. Talend does a really good job of taking heavy data from multiple sources and allowing you to manipulate it easily.
Talend is used at EWS to integrate data between our MS SQL Reporting Server (ERP & Exact Global) and Cloud Apps like Cropin & Salesforce. We implemented it in 2018 and it’s proved to be highly efficient & reliable while working on large datasets replacing the custom (.NET coded) solution. It is used as a middleware to pass data of Farmers/Growers, Contracts & Fields from Reporting Server (ERP) to Cropin and Yield Estimations, Sowing, Transplanting & First Receiving Dates from Cropin to Reporting Server. In other Use cases, it integrates Reporting Server & Exact Global with Salesforce to pass Customer's Information and credit limits, Products & Price List, Accounts & Inventory information.
It’s a great middleware integration suite product to integrate on-prem with Cloud-native apps e2e seamlessly and with high efficiency and reliability while handling large datasets, interfacing data instead of manual interventions, thereby replacing clunky custom-coded solutions. It’s a critical connector for business operations at EWS and hence super important as a solution.
Talend Data Integration is primarily used by the data warehousing team. While the management of data warehousing in handled by a single team, they work with data sourced from and sent to all departments across the entire organisation - this makes Talend Data Integration a critical software component for our use cases.
If your organisation or department works regularly with ETL jobs or sources data from multiple locations and needs to integrate them to provide for better data compatibility, then Talend Data Integration is a great tool and I would strongly recommend it. This mostly applies to established corporations, and not startups as the licensing fee is quite high.
We use the big data edition of Talend Integration Suite. It is used by the Business Intelligence department for extract transform load (ETL). There are more than 400 jobs that pull data or push data from various sources. Talend is used to load data into the enterprise data warehouse. (EDW). I use the big data edition to pull data from hive cluster. There are complex sources like highly nested JSON and XML that can be easily parsed using Talend components. The best thing I like about Talend is the ease of use/debug and ease of deployment. Behind the scenes it uses Java coding, so whatever you do in the interface can be easily visible under code. Packaging and deployment of code is easy too in any environment (Windows or Mac or Linux) with any version of Java compatibility.
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.
Cons
The Talend Administration Console TAC is a great place to schedule and monitor your jobs. Probably the interface can be improved.
Talend as an ETL tool is robust and flexible because of the transparency of the behind the scene Java code. Developers can debug and optimize the code easily because of visibility. The big data component of talend makes it the IDE for working with file formats like JSON and log files.
Talend gives the ability to pull data using WSDL/API and also to make data available as REST API. Talend jobs are platform independent and can be deployed easily. IDE is eclipse based.
Talend is used to build a corporate data warehouse solution which centralizes all relevant company intel into a single repository. Talend is used for development only by the IT department (as expected) but the information it gathers is used for the whole company. The main problem which talend addresses is to unify different sources of intel by retrieving data from databases, files, web services, the internet, etc.