Oracle Autonomous Data Warehouse vs. ThoughtSpot

II would recommend Oracle Autonomous Data Warehouse to someone looking to fully automate the transferring of data especially in a warehouse scenario though I can see the elasticity of the suite that is offered and can see it is applicable in other scenarios not just warehouses.

Incentivized

Well suited for my clients for a Macro view of business insights, credit risk, ESG insights, etc. However, I think ThoughtSpot needs to make exploring underlying data easier, adding a feature where you can click on charts and filters will help users and especially business users to easily understand the granularities as well.

Incentivized

• Very easy and fast to load data into the Oracle Autonomous Data Warehouse
• Exceptionally fast retrieval of data joining 100 million row table with a billion row table plus the size of the database was reduced by a factor of 10 due to how Oracle store[s] and organise[s] data and indexes.
• Flexibility with scaling up and down CPU on the fly when needed, and just stop it when not needed so you don't get charged when it is not running.
• It is always patched and always available and you can add storage dynamically as you need it.

• Beautiful visualizations. The visuals are distinct, clean, and easy to discern from one another.
• Intelligent querying functionality. When looking to manipulate the data, the search function makes it easy to manipulate the features in the data, along with aggregating them in the way you'd like.
• Embedding! It has been a smooth process thus far for our product & technical teams to work with ThoughtSpot and bring it into our product.

Incentivized

• It is very expensive product. But not to mention, there's good reasons why it is expensive.
• The product should support more cloud based services. When we made the decision to buy the product (which was 20 years ago,) there was no such thing to consider, but moving to a cloud based data warehouse may promise more scalability, agility, and cost reduction. The new version of Data Warehouse came out on the way, but it looks a bit behind compared to other competitors.
• Our healthcare data consists of 30% coded data (such as ICD 10 / SNOMED C,T) but the rests is narrative (such as clinical notes.). Oracle is the best for warehousing standardized data, but not a good choice when considering unstructured data, or a mix of the two.

Incentivized

• Ability to build a single dashboard tile containing the main value, a sparkline, and a percent change over time
• Easy way to build a user experience that allows for selecting different metrics to trend from a drop-down on a multi-axis graph

Incentivized

Because

• It is really simple to provision and configure.
• Does not require continous attention from the DBA, autonomous features allows the database to perform most of the regular admin tasks without need for human intervention.
• Allows to integrate multiple data sources on a central data warehouse, and explode the information stored with different analytic and reporting tools.

Incentivized

We have had success with the initial use cases and there are more use cases that can receive return on investment. I don't give it a 10 because other products like Tableau are building functionality that may start to compete in the coming years.

Incentivized

The tool is easy to use if you know what you are doing and looking for. I know as they work towards improvements and simple language it will become even easier, but as of now they are doing a great job but there is room for improvement.

Incentivized

it's available unless there is a server or system update etc. sometimes the timing of this is bad (for example during a month end close)

Incentivized

It does what it is supposed to. Would be nice to have a bit more insights

Incentivized

It's been fine. Minimal issues

Incentivized

inhouse in-person training. Took a bit to long to get the basics.

Incentivized

poor instructions

Incentivized

Understanding Oracle Cloud Infrastructure is really simple, and Autonomous databases are even more. Using shared or dedicated infrastructure is one of the few things you need to consider at the moment of starting provisioning your Oracle Autonomous Data Warehouse.

Incentivized

Understand use case and model and design accordingly

Incentivized

As I mentioned, I have also worked with Amazon Redshift, but it is not as versatile as Oracle Autonomous Data Warehouse and does not provide a large variety of products. Oracle Autonomous Data Warehouse is also more reliable than Amazon Redshift, hence why I have chosen it

Incentivized

We also explored Tableau Ask Data. Tableau is our standard for BI in our organization. We want to use the smallest amount of tools in our company to have the best adaption. ThoughSpot will fill a few gaps that we have with our current set up and will also enhance out offering for our employees in the transition of being more data driven within in near future

Incentivized

Seemed to deal well with multiple instances of Sales Force Marketing Cloud

Incentivized

• Overall the business objective of all of our clients have been met positively with Oracle Data Warehouse. All of the required analysis the users were able to successfully carry out using the warehouse data.
• Using a 3-tier architecture with the Oracle Data Warehouse at the back end the mid-tier has been integrated well. This is big plus in providing the necessary tools for end users of the data warehouse to carry out their analysis.
• All of the various BI products (OBIEE, Cognos, etc.) are able to use and exploit the various analytic built-in functionalities of the Oracle Data Warehouse.

Incentivized

• Positive ROI immediately seen for first POC.
• Saved an immense amount of time for a sole analyst on a team by enabling the end-users to ask their own questions instead of always turning to her, allowing her to focus on other priorities.
• Immediate answer to question on second POC that led to personnel changes.

Incentivized