When I was presented with the opportunity to review The Kompany’s dbRadar product, I jumped at the chance. I seem to be on a continual quest for good database tools.I have not enjoyed the query analyzers or enterprise managers of Microsoft, Sybase, MySQL, Oracle or DB2. They all seem lacking in features and if I were to venture a guess, were developed as maintenance tools by the engineers creating the databases. So it was, that I eagerly awaited the dbRadar package and when it arrived, I immediately opened it, yanked the cd and stuck it in the drive. I was ready to give it a run for the money.
I put the application through its paces for the next several days, and it is with reluctance that I say that dbRadar is not really ready for serious use by DBAs. The product has a great deal of promise, but version 1.0 fails to deliver on that promise. There are a number of GUI elements that seem to me to be unfinished. The main two that really were annoying were the main tree control, that does not expand properly and the context help that does not exist for most contexts. I ran dbRadar in Windows and in Linux, I ran it against MySQL, Oracle and DB2 in both environments.
In Windows, you will need a workaround if you do not have both Oracle and DB2 installed, otherwise every time you connect there will be 13 dll not found dialogs to click through. In Linux, these missing dlls do not present a problem. There is not any real Help in either Windows or Linux. The Help menu is comprised of two entries – About and What’s This. About is the usual blurb showing the product name and the company, no pun intended, who made it. What’s This turns your cursor into the context cursor of cursor/question mark, however, it only seems to provide help when applied against menu items, which are generally self explanatory. There does not appear to be any help associated with Dialog items, which are sometimes difficult to figure out. Your best bet for assistance in using dbRadar is the ‘Cool Getting start guide for dbRadar’ that comes on the CD. This is a nine page document with screen shots that covers the basics.
When I asked The Kompany if they could recommend a Platform/Database combination that would play to their strengths, they replied that Oracle on Linux was the best combination. I spent a couple of days getting an appropriate environment set up and I have to admit that dbRadar runs much better and is more useful when running in Linux against Oracle, especially with rexecd and Oracle Applications running. When this is the case you can kill sessions, monitor system resources and perform a number of administrative functions from within the tool itself.
As a sql editor dbRadar works quite well. You can execute pretty much any sql that the target database supports. I certainly could not make it break. I created tables and performed all of the standard operations on the table, insert rows, delete rows, alter table, create indexes, etc. This is something that The Kompany can build on.
dbRadar is a promising tool for DBAs, particularly for Oracle DBAs using Linux. However, there is a good deal of room for improvement in the functionality of the interface. The Windows version seems broken if you are not aware of the dll workaround. I believe that dbRadar will mature given time and vision, but Version 1.0 is a bit to beta for my tastes. If you want to give it a whirl, there is a demo available at here, otherwise, wait for the next version.
I’ve been looking for an alternative to DbArtisan which is very expensive (about $7000 with all the options included). As I see from the review and the screenshots, this is not it.
DbArtisan is a great tool that could be so much better and I’ve been waiting for someone to blow them out of the water. I guess, this ain’t it.
Not sure if this product is similar or not, but a great tool for working with Oracle DB is Tora – http://www.globecom.se/tora/ Very similar in functionality to Toad (from Quest Software)
Aqua Data Studio 3.5
Wow, I just looked at Aqua Data studio. Amazing.. works in linux, solaris, windows and OS X
Doh! I was going to suggest adstudio. It’s awesome.
Since i am working as a DBA for Oracle Applications i didn’t seen any tool to suport them. More than that we can administer Oracle Applications sessions from Linux and notice any load on the database server. This way we noticed some I/O issues on our database server when some concurrent requests were running. I hope dbRadar will continue its development!
Ah, you didn’t look hard enough. Try Aqua Data Studio. It supports several versions of Oracle. I don’t know how well, but it’s free, so try it. It’s only drawback is it’s written in shitty Java. The app is very good, but Java sucks. Runs on Windows and Linux.
I was talking about Oracle Businnes Suite. Yes i noticed Aqua is written in Java. DbRadar runs quite fast since is using c++.
I’ve been using DbVisualizer for a long time now and am quite happy with it. It’s written in the excellent Java language and seems quite similar in features to ADStudio.