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 (!)
Use Cases & Pain Points Addressed
This tool solves the following pain points, or greatly reduces their impact:
Large organizations must install and manage SQL editors on every client PC:
Cost savings in licenses as well as in operations.
Very easy handling of access towards external consultants, since no installation is required on their 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 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.
Cost savings in licenses as well as in operations.
Very easy handling of access towards external consultants, since no installation is required on their 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).
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.
Supports:
Costs/Expenses: comes at a fraction of the cost of international vendor tools (even not web-based).
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.
Supports:
- On premise: Oracle, SQLServer, PostgreSQL, DB2 (Luv & Z/OS), and any JDBC connection-supported database system – as the same single product, i.e. as opposed to having different packages for each.
- In cloud: Oracle, SQL Server.
Costs/Expenses: comes at a fraction of the cost of international vendor tools (even not web-based).
