Integration take on Oracle 12c
October 30, 2017

Integration take on Oracle 12c

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database 12c

The database platform is being rolled out to replace older versions for Oracle that my company has used as the back end data storage solution for many of our in house applications. The biggest business need addressed by this is support. Specifically, some of the older flavors of Oracle DB that we have been using for our systems are no longer supported by oracle tech support, and as such, upgrading allows us to continue to have access to our external tech support from Oracle.

Additionally, the platform itself is more secure, and operates at a faster pace than the previous versions of the product that we have utilized in the past, as is often the case with new versions of products (once bugs are worked out).
  • Data Indexing - 12c seems to be superior at this when compared to prior versions
  • Integration with other Oracle products - as is often the case, the latest version of one oracle product works best with the latest of another. Having a uniform version across all oracle products in a company is just wise.
  • Security: the product provides superior data encapsulation.
  • I've not found anything from an end user perspective that I dislike or feel needs improving at this time.
  • Positive: better security encryption.
  • Positive: Indexing seems to be quite fast.
  • Negative: all 'newer' products have bugs. The tool is new to our company and there is a bit of a learning curve.
Its not a straight forward comparison, but the other major DB platform we use is Actian Matrix. The latter being a columnar non-relational database, it really is a case of comparing apples to oranges - both are fruits but beyond that entirely different. Or in this case, both are 'databases' but aside from a share common SQL structure, they are quite different. Oracle is great at indexing and dealing with relatively small amounts of data. Actian Matrix is fantastic for data mining and massive amounts of data. Different tools for different jobs.
It's amazing at data storage in large numbers and ties in very well as a JDBC data-source for a WebLogic middleware instance. A lot of our in-house applications are Java-based programs that source large amounts of data. The databases are often fed via Informatica, and then the WL Application will source the data and transform or aggregate as needed. Oracle has been a sufficient platform for this in the past, and 12c seems to continue this trend.