Denodo is the eponymous data integration platform from the global company headquartered in Silicon Valley.
N/A
Stitch from Talend
Score 7.5 out of 10
N/A
Stitch, or Stitch Data, now from Talend (acquired in late 2018) is an ETL tool for developers; the company was spun off from RJMetrics after that company's acquisition by Magento. Talend describes Stitch as a cloud-first, open source platform for rapidly moving data. It is available on a Free plan, and also a Standard and Enterprise plan which include more advanced features (e.g. an account manager, multiple data destinations, HIPAA compliance, advanced scheduling).
Denodo allows us to create and combine new views to create a virtual repository and APIs without a single line of code. It is excellent because it can present connectors with a view format for downstream consumers by flattening a JSON file. Reading or connecting to various sources and displaying a tabular view is an excellent feature. The product's technical data catalog is well-organized.
Caching - but I am sure it will be improved by now. There were times when we expected the cache to be refreshed but it was stale.
Schema generation of endpoints from API response was sometimes incomplete as not all API calls returned all the fields. Will be good to have an ability to load the schema itself (XSD/JSON/Soap XML etc).
Denodo exposed web services were in preliminary stage when we used; I'm sure it will be improved by now.
Export/Import deployment, while it was helpful, there were unexpected issues without any errors during deployment. Issues were only identified during testing. Some views were not created properly and did not work. If it was working in the environment from where it was exported from, it should work in the environment where it is imported.
Stitch is not good at replicating document stores like MongoDB to relational databases. To be fair, this is a difficult task. Stitch flattens the objects, but the result is unwieldy.
Stitch cannot replicate the same source to multiple sinks, which is inconvenient if you want to replicate some of a datastore's tables to Redshift and others to Redshift Spectrum, for instance.
Denodo is a tool to rapidly mash data sources together and create meaningful datasets. It does have its downfalls though. When you create larger, more complex datasets, you will most likely need to cache your datasets, regardless of how proper your joins are set up. Since DV takes data from multiple environments, you are taxing the corporate network, so you need to be conscious of how much data you are sending through the network and truly understand how and when to join datasets due to this.
Stitch from Talend is way more cost effective and has a business model that better aligns with our company. From what I can tell Stitch from Talend has a better customer support platform as well and has been very easy to work with when issues have come up. They also seem less pushy when it comes to sales.