AtScale vs. Denodo vs. InterSystems Ensemble (legacy product)

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.

Incentivized

• Best suited for fast development with a fundamental emphasis on object orientation
• Prohibitive costs for very small integration projects

• Database Agnostic: You can easily connect to different environments and mash up data sets.
• The "magic" of data virtualization: No data is created, so data is reported in near-real-time to end users.
• It's easy to use UI for developers. You just connect to a data source, create tables, and join them to other datasets.

Incentivized

• Easy to use: The simplicity of its programming language allows fast learning. Visual environment to generate complex code.
• Robust: A fall of the system will not be a problem. Never again will information of the transactions in progress be lost. Never more messages lost.
• Connect to the world: The most popular connection is possible to implement quickly. FTP, File folder, TCP, SMPT, REST.... all method are ready to use. Only define "where" and "how"

Incentivized

• 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.

Incentivized

• Given that Ensemble and Cache are one of if not the only true fully object orientated database/development technologies for massive transactional data systems its customizability is extensive and it just comes down to the creativity of the developer to get the products to pretty much do whatever they want to do with it. However, this is not necessarily obvious to newcomers to the technology.
• The developer community could do with greater participation from the software developers/application specialists and engineers within InterSystems.
• More extensive documentation and greater access to proven working solutions particularly in the realm of some of the lesser known or new and upcoming technologies.

Denodo is very easy to use. It has a user-friendly drag and drop interface. I'm not a fan of the java platform it resides on.

Incentivized

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.

Incentivized

I have yet to raise an issue with InterSystems WRC that they have been unable to resolve to my satisfaction in the 20+ years that I have worked with their products.

Denodo is simple and easy to use. Highly recommended unless you have huge volumes of data

Incentivized

Mirth is another integration platform that we have used but its development, in Java, made us always create new methods every time a new product was integrated. Every connection process had to be developed from the beginning and it was not easy to reuse code. Nor did it allow us to have an extensive catalog of HL7 messaging, having to perform the validation of each and every one of its fields manually.

Incentivized

• It is a huge advantage that we can connect to many different databases to provide data rapidly and accurately.
• It has proven to be a valuable environment for deploying data virtualization solutions, and its user community is active in finding and fixing issues.

Incentivized

• We have integrated 5 laboratories in a treatment monitoring system in less than a month of development. Being able to integrate the following in a period no longer than a week.

Incentivized