MDACA
  • Why MDACA
  • Product
    • MDACA EQ
    • Data Collection & Integration
      • Data Flow
      • Server/Collector
      • Gateway Service Engine
      • Sharepoint Connect
    • Data Access
      • Information Portal Framework
      • Mobile
      • Big Data Virtualization
      • Cloud Storage Explorer
      • Data Explorer
      • Data Export Services
    • Data Lake
    • Data Insights
      • ML/AI
      • Data Analytics
    • Governance and Administration
      • Data Governance Decision Support System
      • Cloud Cost Optimization
      • Synthetic Data Engine
    • Blockchain
    • Extended Reality +
    • IoT and Edge Devices
    • Clinical Genomics and Precision Medicine
    • Digital Innovation Lab
    • MDACA Performance DB
  • Solutions
    • Government
    • Commercial
    • Healthcare
    • ProServ Consulting Services
    • Supported Open Source
  • Blog
  • Support
    • Contact Us
    • Training
    • Submit Feature Request
    • Submit Support Request
    • Quick Start Support
    • Documentation
    • Terms of Use
    • Privacy Policy
    • Open Source Component Licenses
    • Open Source Third Party Notices
  • Pricing
  • Partners
  • Search
  • Menu Menu

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. 

Request Demo






Access and Purchase MDACA Data Explorer

in AWS Marketplace

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

Let’s Talk
(703) 318-0803

Certifications

Follow Us

  • Facebook
  • Linkedin
  • Instagram

About Us

  • Management Team
  • Why MDACA

Contracts

  • GSA Multiple Award Schedule (MAS)
  • SeaPort-Next Generation
Copyright 2020 SpinSys. All rights reserved. Built by SpinSys | Home | Privacy Policy | Terms of Use | Address
Scroll to top
Share This
  • Facebook
  • LinkedIn
  • Twitter