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)

Use Cases & Pain Points Addressed

This tool solves the following pain points, or greatly reduces their impact:

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

The following features and advantages should be noted:

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.