Digital Project Delivery Manager at a computer software company with 51-200 employees
Real User
Top 20
2023-10-30T11:39:50Z
Oct 30, 2023
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.
Oracle Autonomous Data Warehouse can be useful for data warehousing. It's easier to do setup and maintenance compared to Oracle Exadata. For some users, if it is satisfying, they can use it very easily because you don't have to do anything, including any kind of streaming or special kind of physical design for most of the use cases, making it easy to use. It is very easy to expand and allocate dynamic resources because you can use some processing units of Oracle which are virtualized. In the product, considering the processor power and memory, you can easily add processing units to make your system more powerful, which can be planned. For working hours, you can use as many processing units of Oracle, while later, you can reduce its use. For test purposes, you can use fewer processing units of Oracle on the platform, and you can switch it off and activate it only when you need to develop something. The processing units are very flexible. Using the tool means payment for resources has to be made. The tool makes it very easy to use the space provided in the product because you can add one terabyte or gigabyte to your space. For somebody who knows how to use the features of the tool and go deep into its physical design, everything becomes available, including Oracle Exadata on Oracle Autonomous Data Warehouse. So people who are experienced and know Oracle Autonomous Data Warehouse can use the product to improve performance and do better design, making it more efficient. Somebody who doesn't know how to use the tool and does not have people to help can use it with a much simpler approach.
The solution can be used for many things, including: * Data storage * Analytical transactions * Provisioning for the Oracle Autonomous Database * Connecting to Oracle Autonomous Database * Use with JDeveloper * Use with Eclipse IDE * Use with Toad for Oracle * Use with Oracle SQL Developer * Use with Oracle Data Pump * Migrating Amazon Redshift to Oracle Autonomous Database * Migrating Amazon Aurora to Oracle Autonomous Database * Migrating Amazon RDS to Oracle Autonomous Database * Use with Oracle Data Integrator * Use with Oracle Analytics Cloud * Use with REST APIs
Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
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.
Head of Data and Analytics at a financial services firm with 10,001+ employees
Real User
2021-02-22T21:55:48Z
Feb 22, 2021
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.
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.
CTO at a tech services company with 51-200 employees
Real User
2020-05-15T22:11:00Z
May 15, 2020
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.
@BenjaminArnulf We have both Oracle ERP and EPM cloud services, and we are in the process of evaluating OAC and Oracle DW. Did you evaluate any other solutions such as Tableau and Snowflake? What is your experience with OAC and Oracle DW? Did you hire a 3rd party consulting firm to help you implement? What business needs are you trying to solve with these solutions?
Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and,...
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.
Oracle Autonomous Data Warehouse can be useful for data warehousing. It's easier to do setup and maintenance compared to Oracle Exadata. For some users, if it is satisfying, they can use it very easily because you don't have to do anything, including any kind of streaming or special kind of physical design for most of the use cases, making it easy to use. It is very easy to expand and allocate dynamic resources because you can use some processing units of Oracle which are virtualized. In the product, considering the processor power and memory, you can easily add processing units to make your system more powerful, which can be planned. For working hours, you can use as many processing units of Oracle, while later, you can reduce its use. For test purposes, you can use fewer processing units of Oracle on the platform, and you can switch it off and activate it only when you need to develop something. The processing units are very flexible. Using the tool means payment for resources has to be made. The tool makes it very easy to use the space provided in the product because you can add one terabyte or gigabyte to your space. For somebody who knows how to use the features of the tool and go deep into its physical design, everything becomes available, including Oracle Exadata on Oracle Autonomous Data Warehouse. So people who are experienced and know Oracle Autonomous Data Warehouse can use the product to improve performance and do better design, making it more efficient. Somebody who doesn't know how to use the tool and does not have people to help can use it with a much simpler approach.
Mostly, we use it in our company for online transaction systems.
I'm a research analyst and we are customers of Oracle.
It is used by banking customers. Oracle is strong in banking, and many of their existing customers do use or continue to use Oracle solutions.
The solution can be used for many things, including: * Data storage * Analytical transactions * Provisioning for the Oracle Autonomous Database * Connecting to Oracle Autonomous Database * Use with JDeveloper * Use with Eclipse IDE * Use with Toad for Oracle * Use with Oracle SQL Developer * Use with Oracle Data Pump * Migrating Amazon Redshift to Oracle Autonomous Database * Migrating Amazon Aurora to Oracle Autonomous Database * Migrating Amazon RDS to Oracle Autonomous Database * Use with Oracle Data Integrator * Use with Oracle Analytics Cloud * Use with REST APIs
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.
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.
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.
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.
We're currently using the solution to move data from legacy systems to the cloud.
Our primary use case of this solution is as a data management system for analytics.
We evaluated Oracle Autonomous Data Warehouse for use in a client project. We were among the first to try out this solution.
We implemented Oracle Autonomous Data Warehouse in Oracle Cloud with Oracle Analytics on top of financial and procurement data.
@BenjaminArnulf We have both Oracle ERP and EPM cloud services, and we are in the process of evaluating OAC and Oracle DW. Did you evaluate any other solutions such as Tableau and Snowflake? What is your experience with OAC and Oracle DW? Did you hire a 3rd party consulting firm to help you implement? What business needs are you trying to solve with these solutions?