DBeaver vs. Oracle Enterprise Metadata Management (OEMM)

If you are connecting to Snowflake and want to query from your laptop, I find that this is much easier to use than Snowflake's IDE. It allows us as a business intelligence team to more easily connect to our servers, and code with much less hassle. It would be less appropriate if you are only on an on-premises SQL server, in that case, I would just use SSMS.

Incentivized

As mentioned in my first paragraph, we have found Oracle MetaData management to be very helpful with our training material. Because our business is constantly changing, we often have to modify terminology, procedures, photos, and more. Properly cataloging our materials allows us to use the metadata to quickly search through all resources and identify items that require revision. It is very helpful and saved a tremendous amount of time searching.

Incentivized

• Identify types of DB connections by color code: development, testing and production.
• Predictive typing, it is incredibly accurate and saves me a lot of time.
• Jump between different simultaneous DB connections.
• Navigate through the schema object tree.
• Provide all the tools I need in one window.

• I like that I can allocate the information according to a catalog or a categorization.
• The system has enough ability to do data analysis without problems.

Incentivized

• Schema editing is not very intuitive. Editing a single column forces you into multiple tab windows when trying to change something simple like a column name.
• Sorting and filtering in data is nice, but buried in long right-click menus.
• Some things are definitely non-standard UI for a Windows application, so it might be hard for die-hard Windows fans to get used to.

Incentivized

• Steep learning curve compared to other applications
• The UI can be finicky, certain actions cause the application to glitch or cause issues
• Occasionally laggy/slow to respond

Incentivized

It's perfectly easy to use. Not super new and shiny with lots of accessibility tailored tools, but does the job

Incentivized

Not a lot of users have DBeaver so fewer resources are available online to help you if you have any issues. When I was trying to figure out how to create my own ER diagrams, it was a little tough to find resources

Incentivized

MySQL workbench from MySQL only supports MySQL databases and it only provides basic functionality. On top of that, the user experience could be quite confusing for first-time users. SSMS from SQL server doesn't support inline editing nicely. The view for inline editing and view data is different, making it uncomfortable to use. All in all, DBeaver is the best tool when you manage a lot of databases with different types.

Incentivized

We researched Alex Solutions in addition to Oracle Metadata Management, and although there were comparable price points, features, and capabilities, we ultimately decided to go with Oracle because we use Oracle for our LMS. The integration was seamless and provided a way to get things up and running quickly. We haven’t had any major issues or concerns that have caused us to question that decision at this time.

Incentivized

• Positive Ability to manage DBeaver and query ad-hoc quickly
• By having the queries saved it has saved developer time and thereby increased the ROI on the investment on the tool
• This has made firefighting quicker and freed up resources for more development work.

Incentivized

• EDM is not a good ROI for a single application in the Oracle Cloud.
• EDM is a good ROI for when you have multiple applications in Oracle Cloud.
• EDM is not a good ROI if you have more then 5K unique members as it get very costly.

Incentivized