DBArtisan from Embarcadero Technologies (acquired by Idera) is a database administration toolset.
N/A
Oracle Autonomous Database
Score 9.0 out of 10
N/A
Oracle Autonomous Database provides a self-driving, self-securing, self-repairing cloud service that eliminate the overhead and human errors associated with traditional database administration. Oracle Autonomous Database takes care of configuration, tuning, backup, patching, encryption, scaling, and more.
N/A
Pricing
DBArtisan
Oracle Autonomous Database
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
DBArtisan
Oracle Autonomous Database
Free Trial
No
Yes
Free/Freemium Version
No
Yes
Premium Consulting/Integration Services
No
Yes
Entry-level Setup Fee
No setup fee
Optional
Additional Details
—
—
More Pricing Information
Community Pulse
DBArtisan
Oracle Autonomous Database
Features
DBArtisan
Oracle Autonomous Database
Database Development
Comparison of Database Development features of Product A and Product B
DBArtisan
8.5
3 Ratings
0% below category average
Oracle Autonomous Database
7.2
24 Ratings
17% below category average
Version control tools
8.02 Ratings
6.213 Ratings
Test data generation
8.83 Ratings
5.714 Ratings
Performance optimization tools
8.02 Ratings
8.224 Ratings
Schema maintenance
9.83 Ratings
9.023 Ratings
Database change management
8.02 Ratings
7.015 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
Pro - Stability. Does everything anyone could need. If it's not there it will be on the next update. There is plenty of support for it. It's been around for a long time and it's reliable. The support is well documented and has a great reputation. Cons - Errors have been found in the documentation provided by Oracle with guidelines, etc. Oracles salespeople have a reputation of being obnoxious and condescending.
User interface is easy to use, and in some ways better than Toad. The left hand side shows all databases, and you can drill down to instance, storage, schemas, tablespaces, and performance views. The right hand side displays the details of the selected object.
This is the best tool if you want to manage multiple RDBMS platforms in a single tool using the same familiar interface. Other third party tools can do it also, but it's not nearly as integrated as this, and may require additional plug-ins installed. DBArtisan excels at this, and can perform cross-platform data migrations easily.
It has different DB analysts, which can help diagnose issues with performance, optimize storage, detect fragmentation, and plan for capacity growth. For almost any action you want to take, you can generate the DDL for preview, and/or schedule it to run at a specific time.
There is no access to the physical host of the DB. This is expected from a managed DB. Everything must be done through the console or via API calls. This is a new learning curve for the DBAs.
Due to the lack of physical host access, certain features are not supported, such as Transportable tablespaces and Oracle LogMiner.
Certain special data types, (such as XMLType) are not allowed; be sure the app vendor certifies their product on this platform.
Because it does exactly what we need: it enables us to manage our development and testing database environments in a quick and simple way without requiring support from a database administrators team.
The product is continuously evolving and new features are added frequently. Management options through the OCI (Oracle Cloud Infrastructure) console and through the command line and API are being enhanced frequently.
I found Oracle Autonomous Database very secure to store data and private information.I always feel secure with Oracle Autonomous Databases disaster recovery features.It is very effective to build applications for mobile and desktop devices lesser code using a low code development framework namely Oracle Application Express (ApEx).
It has a positive ROI on our organization. It's better than OEM and SQL Developer. Although the license could be expensive, it is perfect for large organizations, especially with multiple RDBMS platforms.
Most features are redundant between DBArtisan and Toad. I would not recommend using both if you already own one of them. Just download the trial for the one you're not using, and see what works best for your organization.
DBArtisan is great for DBAs and would be my personal preference. Toad is good for developers and DBAs alike but I feel like sometimes the interface is too busy and too clumsy to use.