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)
Type: Product
An SQL query editor software (TOAD-like), but web-based: the effect is savings in license and time, as well as in enhanced security.
Service Mgmt. & Support
Hotline (English):
- 24/7.
- 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.
Competitor Product
None (!)
(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).
(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
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.
Large organizations must install and manage SQL editors on every client PC:
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).
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:
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).
Supports:
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.
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).
Supports:
- 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.