For so many years now the DBMGui and the SQL Studio have been the primary graphical interfaces for developers and DBAs to access MaxDB instances.
Beside the many good features and the relative high stability (i remember the early versions of Oracle’s SQL Worksheet in release 9i…) the major drawback has been the fact that these tools were only available on Windows-Systems.
As a kind of compromise the WebDBMGUI was handed out to the open source community and to those SAP customers who asked for it. Unfortunately the built-in Webserver was kind of “too open” – in a way that this Web-Component was responsible for the majority of the bad press (look for ‘security’ and ‘maxdb’ on google and you’ll find the security warnings).
Of course each and every security leak was patched but still this was no satisfactory solution.
Thus a complete redesign took place. The upcoming product will be called “Database Studio” and will be presented live and in full color at the TechEd’07 (see dates below).
DBA Studio is completely Java-based and cross-platform from the start. It’s built up on the wellknown Eclipse Framework.
Besides this move to a standard platform many feature enhancements have been made. The following just represents a shortlist of the top features:
- DBA-/SQL-Workplaces combined in one tool
- Work parallel with several Instances or Sessions (no more waiting for one query to finish like in SQL Studio)
- Enterprise-wide or Client-based credential management
- DB Analyzer Front-end outside an Netweaver Installation
- Graphical Query Wizard (drag-n-drop Query creation)
- Integrated Explain plan facility
- Background Job-Management (long running Backup won’t block you anymore, since it can be send to “background”)
- DB Connect via JDBC
- Useable for SAP Support via Service connection
Unlike the BR*Tools Studio which has been SAP BR*Tools Studio for Oracle: Features this is not just a short glimpse to some screenshots. Database Studio will be available next week. So make sure you get your copy (visit the SAP Service Marketplace).
Ah – before I forget to mention it: I will be there at the Las Vegas TechEd ’07.
Come and watch the MaxDB sessions (current schedule):
LCM263: 10/2/2007 1:45:00 PM – 3:45:00 PM, Room: H1
LCM263: 10/4/2007 1:45:00 PM – 3:45:00 PM, Room: H3