- Embedded R scripts
These features are key to separating BI tools from ETL tools. RDMS have ETL tools that run the transfer protocol. Some BI tools in the oil and gas industry have ETL features that take the place of accessing the database directly. In the big data ecosystem, the data cleansing process takes place before ETL processes are run to integrate the data. On the other hand, in RDMS, the data cleansing takes place after the data has been imported from disparate system into the database.
Improvements to My Organization:
I used it in an academic setting as a resource to learn R scripting. I have found it an easy API to learn.
Room for Improvement:
I encourage a seamless integration with Hadoop; a direct connection to Hadoop server from a session in Spotfire. This might exist for the Spotfire server connectivity, but I do not work with the server version.
Use of Solution:
I have infrequently used it for two years.
I have not encountered any stability issues.
I have not encountered any scalability issues.
I haven't used technical support.
I have used several BI tools and still maintain this diversity in product usage.
Initial setup was somewhat complex on the client’s system. I am not familiar with the server installation.
Cost and Licensing Advice:
It is economical to consider desktop client usage when possible.
Other Solutions Considered:
Consider how you intend to use the product before investing in functionality that you might not need.
Disclosure: I am a real user, and this review is based on my own experience and opinions.