Likelihood to Recommend
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.
Read full review
Toad Data Point is the clear tool of choice if the end-user is interested in reports that are relatively simple to build using SQL code and export to Excel. It is less useful if the analyst also needs to run statistical models on the data and visualize the data for those functions I usually use
or Jupyter Notebook which incorporates those features much more seamlessly.
Read full review Pros Very easy to use. Very easy to just grab data when needed. Very robust and has so many features to move and transform data. Functionality is very easy to implement with other Oracle data products. Read full review Ease of building SQL/accessing data, using the Query Builder. The new workflow feature mimics products like Hyperion and is centered on how business analysts are used to working with their data. The dimensional views are definitely a hidden gem. This feature allows you to display similar data in multiple windows, then filter on specifics. ALL windows will then reflect the same data. An example here would be salaries organized by dept then salaries organized by job type. As you filter, both analyses will reflect the filtered data. You can easily create spreadsheets and pivot table spreadsheets. You can email the results to the team/you can save the results in the intelligence central repository so others can access it. You can automate all of these things. Read full review Cons If not bundled with other products, the price can be prohibitively expensive SAP connectors tend to be a little expensive and slightly difficult to use The audit module had some difficulties debugging failed instances Read full review The program can error out when reconnecting to a database from a timeout but that is easily fixed by restarting the program. If you aren't familiar with database tools the UI can be overwhelming to some. Read full review Usability
I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap
Read full review Alternatives Considered
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.
Read full review
Toad give me more flexibility. Being able to utilize FTP to send data and receive files from external systems is wonderful. Using the automation tool to run different database, file, and system activities has made my day-to-day functions easy. Being able to schedule tasks right from the software has also made thing easy.
Read full review Return on Investment It provided terrific bulk data movement and data transformation services which we desperately needed It allowed to reduce development costs and lower the total cost of ownership among disparate architectures The enterprise edition's ELT allowed us to generate native code for wildly varied RDBMS Read full review ScreenShots