Oracle Data Service Integrator provides companies the ability to develop and manage federated data services for accessing single views of disparate information. Oracle Data Service Integrator is standards based, declarative, and enables re-usability of data services. For more information visit https://www.oracle.com/middleware/technologies/data-service-integrator.html
N/A
TIBCO Data Virtualization
Score 8.5 out of 10
N/A
TIBCO Data Virtualization is an enterprise data virtualization solution that orchestrates access to multiple and varied data sources and delivers the datasets and IT-curated data services foundation for nearly any solution.
Denodo is great, but if you want or need local storage and/or replication, then Oracle Data Service Integrator is the way to go. ODSI allowed us to perform data aggregation and run reports against locally stored data, which was a must in our environment. Oracle is the clear …
Once Oracle Data Service Integrator is set up properly, it is quite simple to snatch data from a myriad of disparate sources and put them into a single repository. Due to cost factors, it is not for the faint of heart; however, if you can handle it, the benefits will quickly outpace the initial investment. To take full advantage of the power of ODSI, I would recommend the training that Oracle provides.
Well suited: Useful for aggregating data sources and creating a master view to be used across Org streams/ units. Less appropriate: Not a lot of organs use TDV solely because it is marketed as a sole virtualization product rather than a suite of products. Moreover, there is definitely room for improvement when it comes to the user interface, especially the web manager console.
Performance of TDV repository database is rather poor for larger numbers of objects .(Note: We have approx. 9tsd objects introspected in TDV and approx. 20tsd objects generated in upper DV layers.)
Propagation of privileges to parent/child dependencies does not work when applying recursively on a folder. (It's a huge setback when working with large number of objects organized semantically into subfolders.)
Lack of command line client interface for scripting at the time of version 8.4 (I had to write my own CLI.)
TDV Studio does an absolutely horrible job with its own code editors when indentation is in place. Also, the editor is brutally slow and feature-poor.
Tracking privileges on the level of table/view columns causes occasional problems when regranting.
TDV's stored programs ("SQL scripts" in their own terminology) compiler leaves out many syntactic and semantic checks, making them hugely prone to run-time errors.
TDV Server's REST API is a very poor (in terms of features) and flawed cousin to its SOAP API (at the time of version 8.4).
It really is a product with excellent performance, the impact within the company has been very good since different processes have been improved in different areas, both data analysis, development, integrations, and best of all, it has not affected the users. Different systems with which it has connectivity to obtain the information.
On a few occasions I have asked TIBCO technical support for help because I have adapted perfectly to their tools, but in those few that I have communicated with their technical team I have received personalized, attentive, responsible attention and I am always assisted by an expert staff the topic. A TIBCO technical support technician spent more than an hour helping me to solve a problem in the initial stage of implementation in my department and this is something that I always appreciate.
The training was helpful. I was able to understand how to use TIBCO for the data load process that we implemented and how to perform various troubleshooting steps based on the training I received. The technician was thorough and took the time to answer any questions. Once we were shown how to use TIBCO in the test environment, we were able to configure the production environment ourselves.
Other vendors have clearer, more visual implementation documentation. We also did not have our data architect and and server administrator available full-time for implementation. In the future, we will secure the necessary internal resources.
While we tested and evaluated multiple data service providers, we came to choose Oracle Data Service Integrator since our infrastructure was so heavily dependent on Oracle software. The implementation would be easier and the difference in the number of features and performance wasn't enough to sway us in another direction.
[TIBCO Data Virtualization] is [has great performance] and [the] overall cost is much reasonable than other competitors. The wide range of services/features make it the perfect solution for our data needs. [TIBCO Data Virtualization] has always met our quality needs.
