MDACA Data Explorer (DE) is a lightweight, web-based universal SQL client that allows you to query and browse any Open Database Connectivity (ODBC) compliant databases.
MDACA Data Explorer is a web-based application, enabling end users to connect via browser to various SQL servers, explore data by writing and running complex SQL queries, and eventually visualize the results. It also allows users to set up and share queries with team members, playing a major role in moving projects forward and supporting training and collaboration with other team members. MDACA Data Explorer is the ideal tool for data analysts, scientists, database administrators, and developers who want to perform data exploration and visualization via SQL, all via an intuitive and simple web app.
Database Support
MDACA Data Explorer supports an extensive range of industry leading databases, query engines and virtual databases. Secure connections via ODBC include, but are not limited to, the following:
- MDACA BDV
- Redshift
- SQL Server
- Oracle
- Percona
- MySQL
- Postgres
- Trino
- Hive
- MariaDB
- Snowflake
- BigQuery
- SQLite
- Starburst
- Any ODBC Database
KEY FEATURES
Tag and Share your Query
Allows team collaboration and query sharing by providing the capability to tag and share queries
Database Browser
Browse database objects such as schemas, tables, columns, and more
SQL Editor
Edit SQL scripts. Run SQL queries and Auto column and auto table lookup
Data Query Tool
Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more
Lightweight Data Visualization
Create charts and graphs against your data in support of visual representation and analytics
SQL Query Builder
Create, select, insert, update, and delete SQL statements; create multi-table joins
Data Explorer Integration with BDV
Data Explorer combined with BDV enables:
- Executing high performance data queries across multiple environments with robust Massively Parallel Processing (MPP)
- Support for Role Based Access Control (RBAC) to your data, including row and column level access security
- Easily accessible through standard Structured Query Language (SQL) and/or Web Services interfaces for virtual data utilization and sharing
- Advanced query capabilities across the enterprise
Data Explorer Integration with KeyCloak
Designed to work with KeyCloak and other identity management providers to provide user federation, strong authentication, user management, fine-grained authorization, and more.
Data Explorer combined with KeyCLoak enables:
- Single-Sign On – Login once to multiple applications
- Integrate with identity management providers and connect to existing user directories
- Support standard protocols such as: OpenID Connect, OAuth 2.0 and SAML 2.0
- Centralized Management – For admins and users