Anyone who has done anything with data (this includes technical and nontechnical folks) knows how much of a pain in the neck it is to:
- locate the data
- understand how to access the data
- understand the schema of the data
- define the transformations of the data
- define integration with other data/processes
It is really unfortunate that many businesses have unintentionally made their businesses less productive by creating silo’s of data. Generally this is a byproduct of using different tooling for creating and working data. Sometimes those tooling do not integrate well with others and/or is difficult to use, which is what creates barriers and data silo’s.
I could go on and on, but i know you’re all familiar with this oh so common problem. Wouldn’t it be great if there was a tool which would abstract these difficult API’s and allow me to easily build abstract transformations on top of it. Wouldn’t it be great if I didn’t have to schlep each data source’s data? Wouldn’t it be great to be able to expose this transformed data in an easy to use API that is familiar to almost everybody, i.e. SQL standard. Wouldn’t it also be totally awesome if we could easily expose these transformations in other easily consumable protocols?
Well… there is… JBoss Data Virtualization, this product is probably the best hidden secret on the Market. JDV is the productized version of JBoss Teiid, both are excellent and have vibrant communities.
I have a simply demo that I’ve put together for your viewing pleasure.
I have also have a git project that you’re more than welcome to clone and test it out and any feedback is always welcome.