Data is the core asset of any enterprise today. And the same is often spread across different database systems. Your website for example could be built with a popular Content Management system like WordPress, Drupal or Joomla which often run on MySql. Your intranet applications might be using SqlManager or Oracle etc, while a proof-of-concept or micro application being developed might be using an embedded database engine like SQLite or Sql Server Core.
IT departments are often required to grant limited access to such databases to people inside and/or outside the organisation, for analysis, support, troubleshooting, etc. You as a data engineer might yourself need access to your data while on the move.
Such access today requires remote access to the servers for using your data tools of choice. Such remote access is often costly requiring expensive systems and troublesome to set-up and manage on an on-going basis.
Not so any longer with Sql Manager however. Enabling web based access to most common database engines, Sql Manager allows data professionals to work with their data irrespective of whether they are inside or outside the DMZ (i.e. the corporate intranet). You get native like experience while working with your data which is consistent across different data platforms. You can query your data, manipulate it, work with schema, script schema objects and the like.
Access to database(s) and the objects inside the database is governed by the DBMS user account being used to connect to the database, which can be specified per user being given access to Sql Manager. Which essentially means your existing data access and security policies on the underlying DBMS work consistently with Sql Manager.
You can connect to multiple DBMSes in the same session allowing you to move data between them. With ability to build custom extension points in Sql Manager, you can easily customise the product to inject commands and functionality.
By delivering a familiar, intuitive and consistent web interface across DBMSes, SQL Manager provides a common solution to address local and remote data access needs for an organisation’s employees, vendors, and contractors etc.
Access databases over web
Frees professionals from needing Remote Desktop Access for data access.
Authorise users per database
Allows administrators to authorize users to access only the needed database(s).
Multiple DBMS Single Tool
Provides support for popular DBMS like SQL server, MySQL, Oracle and SQLite.
Allows saving and access to frequently used queries over even when connecting from different machines.
Provides quick reference to SQL Keywords, table and column names.
Features elegant query editor with native-like feature, e.g. syntax highlighting, line numbering etc.
Allows administrators to create auditing rules for monitoring user activities, for example when someone logs in for an indefinite interval of time or during off-working hours. Alerts are automatically dispatched when such rules are triggered.
Native database management features
Browse, create and alter schema objects, execute sql queries, manage stored procedures, export data to various formats: CSV, SQL, XML, PDF; import data from CSV and excel, manage security.