I'm working as a BI consultant, so the usual use cases for this solution are creating data integration and building a data mart.
The features I found most valuable on Oracle Database are the standard features: partitioning and analytic functions.
Oracle's technical support needs improvement.
Oracle should really continue working on their cloud topics. Everything they're currently doing on the cloud is on the right path, but they need to continue working on it.
I've been using Oracle Database for 15 years.
Oracle Database is a stable solution.
As an on-premise solution, scalability depends on the hardware, but I find Oracle Database scalable.
I contacted Oracle technical support in the past about a bigger issue and it was a hassle. On a scale of one to five, with one being the worst and five being the best, I'll give technical support a score of three.
I'm using all kinds of products, and it's not that I'm switching from one product to another. The product I'm using will depend on the client. We choose products that would be the best fit for the architecture. Architecture and pricing are the main points for choosing which product to use for each client.
Oracle Database is more complex than any other database that I have installed so far. On a scale of one to five, with one being the worst and five being the best, I'm rating the initial setup for this solution a three.
I implemented Oracle Database in-house.
Pricing for Oracle Database is on the high-end side. In addition to the standard licensing and fixed fees for this solution, there's a cost for implementation and additional services.
Their licensing policy also needs improvement.
I evaluated Microsoft SQL Server.
I have experience with MicroStrategy and also with SQL server reporting tools. The last time I worked with MicroStrategy was two years ago. With Microsoft SQL Server Reporting Services, I didn't work with it for a long time. I'm not currently working with it.
I'm not much into development nowadays. The only tool I'm currently working with directly is any kind of database, or with Power BI, e.g. Oracle Database, SQL Server, Access, etc.
In our organization, we don't use Oracle Database. In my own company, we don't use this solution, because it's being used on the client side. I'm working as a consultant, so I'm using it and most of the other tools, always on behalf of my clients.
Deployment for this solution took an hour, and what I did was a fresh install, not an update. I just set up a new Oracle database to try out new things, and not for setting it up on the client site. I implemented it myself and didn't need a third party or a technical team to help with the deployment.
I have no idea on the licensing costs of Oracle Database because it's the clients who pay for the licenses.
If I would install a new database, I would not go for Oracle. If Oracle Database is currently installed in the company, then it's okay to use it, otherwise, I won't recommend it as a new installation. My reason for not recommending it to others is because of their bad license policy and how they've treated their customers badly, in the past.
I'm giving Oracle Database a score of eight out of ten.
It's a great product, the most excellent feature is data reliability, availability and security. We've been an Oracle client for a decade.