My database connection details are kept in every client, installed on every pc. You call this secure? (COO)
My OPEX is still too high - reduce it more, even if by 50K. (COO)
Service Mgmt. & Support
- Remote support provided via ticketing system.
- Email groups are available to post questions (counts as a ticket).
- SLA defined for critical/major/minor issues.
- No additional difference for bronze/silver/gold service levels.
(No other product that has the same capability set, being at once a web-based editor, as well as able to connect to miscellaneous database types from a single editor, in parallel sessions).
Use Cases & Pain Points Addressed
Large organizations have a wide variety of database systems to operate, both classic and NoSQL.
- This solution allows at once to connect to all systems from a single platform.
- Organizations can apply standards for all resources, regardless of whether external 3rd parties or internal employees.
- It makes the handling of database access towards external consultants very easy, since no installation is required on their PC.
- It consolidate IT tools, operations and increase governance.
Large organizations must install and manage SQL editors on every client PC:
- This is a bottleneck and generates continuous costs in IT desktop support (e.g. installing database agent, client application, set parameters & complete configuration).
- Assets must be managed for new/moving/leaving users, etc.
- Inventories must be updated: licenses are usually by number of installed users and admins (i.e. on PC-basis): these constraints are being evaded, by providing a single tool for all users.
DBA's regularly update the system: if any IP or service name is changed, all clients would have to be updated. Henceforth this would be done in a central place, once for all.
A centralized platform allows some security measures to be applied, such as hiding connection parameters, thus heighten control of database access (i.e. who is supposed to access what database).
Key Features & Differentiators
No features lost:
- Supports schema browsing, data export, and more... in essence, the editor supports all features of TOAD, especially for standard users.
- When it comes to TOAD Administrator License (normally used by DBA's only): only the SQL spooling is not supported, and a few other menu choices, i.e. shortcuts.
Web-based GUI interface to connect and run SQL queries on databases: no need to install anything on clients.
Horizontal scalability & high-availability means vry large number of users can use the platfrm without experiencing bottlenecks (load balancer manage the traffic).
- On premise: Oracle, SQLServer, PostgreSQL, DB2 (Luv & Z/OS).
- On premise: any JDBC connection-supported database system – as the same single product, i.e. as opposed to having different packages for each.
- Oracle, SQL Server in the Cloud: AWS only.
- Deployment in the Cloud: AWS only.
- NoSQL database: MongoDB.
Costs/Expenses: comes at a fraction of the cost of international vendor tools (even not web-based)... very easy pricing scheme. Moreover, there are cost savings in operations.
Implementation case: One large corporation has all its database users (>10.000 active users (!)) using this web editor as single platform.