Oracle Autonomous Data Warehouse Reviews

We used to report all reports from Oracle. We centralized all the connections in the data warehouse, and we have a business intelligence team that makes all the reports for the company. The database connects with Power BI to show the dashboard to the management team.

The solution integrates well with Power BI.

While I'm not on the technical side and instead manage the team, I haven't heard of any complaints related to the user interface, configuration, or customization.

The product, overall, seems to be quite stable.

We are thinking of changing to a data warehouse on the cloud. I don't know if Oracle is in the cloud as well or if we will turn to another solution such as Google Cloud. 

The initial setup was pretty complex. It was not easy.

It would be ideal if the company could manage semi-structured data such as JSON. Some other data warehouses can handle that. However, Oracle doesn't seem to be able to.

I'm new to the company. The solution is also new and was installed in October 2020.

The solution is quite stable. Once you have configured and set it up it's a very stable solution. There aren't bugs or glitches. It doesn't crash or freeze. It offers reliable performance.

I'm not sure how scalable the solution is in the current format we have. Due to the fact that it's an on-premise solution, we have some constraints with the scalability. A cloud solution would be more scalable.

Currently, we have 50 users engaged with the solution.

Technical support is likely fine. I've never heard of any complaints about their level of service. I have never dealt with them personally, however. I can't directly speak to any personal experiences. I don't know if they are knowledgeable or responsive.

I'm new in the company. I know this solution is new as well. It is the new direction the company is trying. We installed the solution in October. However, before that, it is my understanding that we had Oracle also, although it was an older version. I am not aware of the company using a different solution.

The initial setup was now straightforward or easy. It was rather complex. A company needs to be prepared for that when they implement it.

I don't handle the billing or licensing aspect of the solution. I don't have any insights into the cost of the product or how many licenses the company holds.

We are customers and end-users of Oracle. We don't have a business relationship with the company.

I'm not sure of which version we are using. I don't know the version number off-hand.

In general, I would rate the solution seven out of ten. It's okay, however, the company has shown interest in moving away from on-premises in favor of some type of cloud solution.

Oracle Autonomous is a self-repairing version or cloud-based version of the Oracle Database. I typically use the new Data Warehouse capacity so I'll use it if I'm building anything connected to finance, HR, plus any of the standard business products. We also use it for other Oracle products if they're cloud-based; such as with ACM and all their other ERP tools, where the data resides on ADW. We're a consultancy so we partner with Oracle as well as other companies. I'm the principal consultant of the company. 

I like the fact that the solution is self-patching, that it's running machine-learning generally across its logs all the time in order to identify any issues and to self-repair. It means that I don't really need a DBA for the most part. I can do everything myself.

The product is also smart enough that it doesn't need me to set indexes because it's in the memory log so I don't have to specify them, it will actually learn and build the ones that are necessary.

I'm reasonably happy with what they're packaging. Because they've got the cloud offering, there's a lot of things that aren't part of ADW, yet interact with ADW. Purely as a database, it does what it needs to do. And then I've got the detailed analytics and machine learning, so I'm happy with that. It's a capable product. 

Ease of interconnectivity could be improved by which I mean setting up the VPN access and the like from on-premises to cloud. If that was a little easier, it would certainly make my life easier.

I've been using Oracle databases since 2011 and Oracle Autonomous for the last two and a half years. 

This is a stable solution, I haven't had any issues. 

This is an easy solution to scale, it's just a matter of changing parameters, and it will restart itself, although in the latest update the restart might not be required anymore. 

I've had contact with technical support many times. Normally I fill out a service request and they have a set of processes that they run. And even if you understand those and give them all of the information they require before they ask for it, I find they're still likely to delay the process to give themselves time. They will move the bug fix or the investigation up to a higher level of technical skill if required.

Other solutions I use are the standard on-premise Oracle Database and Microsoft SQL. Obviously we do a lot of web development, but I use MySQL for that. The product I use at any one time depends on the client. As a consultant, I work with whatever technology is required, but typically it's on an Oracle setup.

The initial setup is extremely simple. If you know in advance what you intend to set up, it takes less than five minutes before you're actually running or creating tables and placing data. It's very quick. We do the setup ourselves, specify capacity, username, password and then it should be up and running in a matter of minutes. 

It doesn't require any maintenance on our part, that's all controlled by Oracle. The patching is done automatically, typically with zero outage and there's no performance tuning really, because it does the majority of it itself. Internally, we'd have a couple of hundred people dealing with the product at any one time. 

Licensing costs are typically arranged by Oracle CPU. You pay for the access and then you can scale. If you have a fairly intensive database activity, you'd scale up by CPU, and you're paying by the CPU and the uptime. So there's a marginal uptime cost. If your operations are only running 12 hours a day, you can put your database offline after that and reduce costs. If you had multiple databases supporting the same environment, let's say a development, a test, and a production, you could just turn off the development and the test when you're not fixing anything or developing, and that would reduce your costs. There is also a free version of ADW that can be accessed if you create a cloud account. I think it allows for 20MB of space that is free. 

It's worth looking at what Oracle has available because their ETL tool, for example, which is called ODI, Oracle Data Integration, is free if the target of the platform is Oracle ADW. So you can build an entire ETL or ODI process on a very capable tool and not have to pay for that tool if the target is an ADW database.

I would rate this solution a nine out of 10. 

We have a number of clients that are universities. They use the solution for student management. We also have clients in transport, banking, and science domains.

The product is easy to use. I like that it is cloud-based.

The tool is not as autonomous as it's led to believe. A lot of the tools that were previously there have now been taken away. If we write our queries in the same way, then it doesn't trigger the autonomy in the way that it should.

I have been using the solution since it was released.

I rate the tool’s stability a ten out of ten.

I rate the tool’s scalability a ten out of ten.

The product is easy to set up, but it can be very difficult once you get beyond the autonomy. The solution could be deployed on public, private, and hybrid cloud environments. The time taken for deployment depends on the client.

The price depends on the configuration we choose. It can vary massively.

We provide technical support to our customers. Overall, I rate the solution a seven out of ten.

The solution helps stream the data faster and in real time.

They should add features to make the solution more user-friendly. They should work on making its integration with GoldenGate easier. It would increase work efficiency while loading the data into the data warehouse.

We have been using the solution for twenty years.

It is a stable solution.

The solution is scalable, and I rate its scalability as an eight. We have 20 users of the solution in our organization.

The solution's support team responds well to specific issues. But sometimes, they suggest we refer to the manual, which is not helpful.

I used Snowflake earlier, but it works considerably slowly.

The solution's initial setup is straightforward. But, the implementation gets too complicated when we load the data from different systems into our data warehouse.

The solution's cost is reasonable. I rate its pricing as a five.

I rate the solution as an eight.

I'm a research analyst and we are customers of Oracle. 

The integration feature is very good because you can automate protection security automatically, restricting the access of unauthorized people. It can also maintain security in terms of service failure, service protection, and the duration of the disruption. 

Oracle should increase visibility options because what's available now is limited. Experienced users are easily able to understand everything, but from a layman's perspective, it's confusing and can be difficult to understand the steps required. In that sense, the solution requires an upgrade. I recently worked with the machine learning model offered by Oracle and could only find the visualization, without other options. There should be additional 3D, and 4D representations as well as other options that competitors such as Azure are offering for machine learning models. Azure offers its own machine learning studio, so Oracle should do the same, not only for machine learning but for all the database services.

I've been using this solution for about four months. 

The solution is generally stable. 

The scalability is very good. 

The technical support is very good because we initially had a few challenges that we were unable to solve, and the support team was able to solve them quickly. 

Positive

The configuration in our company took a few weeks and we implemented it in-house. We deployed the solution with the help of Oracle Autonomous Database. I would suggest that any company still relying on an on-premises environment should migrate towards a cloud service provider, whether it's Microsoft, Oracle, or Azure. We have around eight to 10 users. 

Licensing costs are paid on an annual basis and are reasonable although I'd like to see technical support included in the license fee. 

I rate this solution eight out of 10. 

This solution is used for bigger projects that involve a large number of transactions. For companies with these requirements, it is perfect.

At this point, we don't have any customers on this platform because, unfortunately, in our country, we are still lagging behind when we talk about the cloud.

The performance and scalability are awesome.

I think that is the best solution for big data warehouses. Larger companies need this kind of solution. Since it is autonomous, you don't have to worry about things like database administration.

The only thing that you have to be concerned with is the data modeling, and how you want the data, or your client's data, to be presented. Since the data warehousing task is quite big, it will give you more time to decide on how you want the data to be presented.

It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment. On-premises,  you can integrate with different vendors such as Microsoft. There should be flexibility in terms of how you can accomplish things and not just with a single vendor, but with all vendors.

I have been using the Oracle Autonomous Data Warehouse for the past month.

I have not needed to contact technical support.

There is no installation for this cloud-based system.

You pay as you go, and you don't pay for services that you don't use. If you feel that you need additional resources then you can increase them and pay only for them. There is no need to worry about paying for something that you don't use.

Licensing depends also on how you want to store your data. For example, some clients use a hybrid approach, where some data is stored on the cloud and other data is stored on-premises.

Overall, I think that the price is quite cheap, and they gave me a $300 credit.

Overall, I am quite happy with this product. I recommend it to my customers and I will continue recommending it to others. 

I would rate this solution a ten out of ten.

Oracle offers this solution as Platform as a service (PaaS). The serverless option provides cost optimization to the organization where they can save huge amounts of money, but not require a highly skilled DBA to manage the database. 

Oracle controls the entire service, where a customer is only responsible for managing data. All other things are managed and maintained by Oracle. There is no billing when the service is stopped.

The solution really helps to test our new applications, do modifications and updates with minimal costs and no HW requirements. Autonomous Database (ADB) provides a highly scalable, secured platform. With Exadata on the back-end, we can achieve higher performance, durability, and data security. You can switch off and on the service to avoid excessive cost/charges. It can be easily accessed remotely. Besides, Oracle has a new DC in our region which greatly resolves DB security and other local governance body issues. 

ADB runs on Exadata technology, which is the proven industry best solution for any kind of workloads. Besides, ADB provides complete automated features, such as, self patching, upgrade, tuning, automated indexing, and automated backups. Also, recovery of the database is easy. 

The entire host and DB software maintenance is done by Oracle and automated. Also, it provides Transparent Data Encryption (TDE) capabilities by default to address data security issues. In addition, the connectivity is highly secured.

An ADB serverless service provides no control over storage, host, and facilities. One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace. 

There are many data types and parameters which are not supported. That should be improved a bit so many customers can adopt.

Over six months now.

With different layers of protection, it is highly stable. Besides, you can choose to have a replica at another region or domain. 

Considering Oracle Cloud setups, it is highly scalable.

Oracle is responsive towards cloud problems.

We were using on-premises databases for testing new application functionality. This was causing a lot of cost to the organization.

With pre-DBA knowledge, it is simple, straightforward procedure.

In-house team.

High.

We discussed other cloud solutions, but the Oracle offering was cost optimized.

I highly recommend it for companies who want to test their application functionality, dev, or test DBs for cost optimization.

With existing DBA knowledge, it is easy to manage and migrate a database to ADB.

We're currently using the solution to move data from legacy systems to the cloud.

The analytics have been very good. We've found them to be quite useful.

The solution needs to offer support for the R language. It doesn't exist and it really is something they should have. 

Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable.

There isn't support for data migrations. It would be helpful to have more documentation or information about this process. It's not easy for us to find online or on their website.

We have only been using the solution for about a year on a few projects that we are currently running.

We haven't found any issues with stability. There might have been two or three small issues around having the database inaccessible occasionally, but other than that, it's good. We haven't faced any bugs or crashes.

The scalability is okay.

We are planning to have 50-60 users on the solution once we've finished the projects we are working on. Right now, it's a work in progress.

We've had to contact technical support in the past for a few issues. However, our partner contacted them and dealt with the problems, so I haven't had any direct contact myself. I wouldn't be able to rate their service or give any insight into it.

The initial setup was handled by our partner. We didn't handle it. I wouldn't be able to speak about if it was complex or straightforward as I wasn't personally involved.

We had a partner handle our setup for us.

I'm not sure if I'm capable of giving advice to anyone as it's a solution that's so new to us still.

I'd rate the solution seven out of ten.