Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

DataVantage provides a wide range of data management solutions that focus on the protection and governance of sensitive information in both mainframe and distributed settings. Among its key products are DataVantage for IMS, Db2, and VSAM, which incorporate sophisticated features for data masking, editing, and extraction, ensuring the safeguarding of Personally Identifiable Information (PII) during non-production activities. Furthermore, DataVantage DME (Data Masking Express) enables economical, real-time data masking for Db2, IMS, and VSAM environments, facilitating compliance without hindering existing operations. For distributed infrastructures, DataVantage Global offers comprehensive data masking, obfuscation, and de-identification processes, promoting both compliance and operational effectiveness across various platforms. Moreover, DataVantage Adviser streamlines the management of COBOL files following mainframe rehosting or application modernization, thereby improving data accessibility and editing capabilities. This holistic approach to data management not only enhances security measures but also supports organizations in their quest for regulatory compliance and operational integrity.

Description

SQL-Ease for Db2 for z/OS significantly accelerates the processes of application review, debugging, and SQL performance optimization without requiring a departure from the ISPF edit environment. This tool effectively shortens development timelines by enabling developers to test and refine their SQL queries prior to the compilation of the program. Programmers can seamlessly test, debug, and optimize embedded SQL directly within the ISPF editor, utilizing various functions for generating, standardizing, checking, executing, interpreting, and analyzing SQL commands. SQL-Ease is capable of producing syntactically accurate SQL statements, including SELECT, UPDATE, DELETE, INSERT, MERGE, JOIN, UNION, and subselect queries, for languages such as COBOL, Assembler, SPUFI, PL/I, and C, and integrates the SQL into the designated location within the code. Additionally, it can transform manually written SQL into a uniform, easily comprehensible format, verify the syntax of SQL queries, execute SQL from both application programs and the SQL Editor, while also returning results accompanied by crucial execution metrics that aid in further performance tuning. Ultimately, SQL-Ease serves as an indispensable tool for developers looking to enhance their workflow while ensuring high-quality SQL performance.

API Access

Has API

API Access

Has API

Screenshots View All

Screenshots View All

Integrations

IBM Db2
Assembler Code Refactoring
C
COBOL
IBM z/OS
Insight
Kyndryl Data Center Services
NTT Global Data Centers
SQL

Integrations

IBM Db2
Assembler Code Refactoring
C
COBOL
IBM z/OS
Insight
Kyndryl Data Center Services
NTT Global Data Centers
SQL

Pricing Details

No price information available.
Free Trial
Free Version

Pricing Details

No price information available.
Free Trial
Free Version

Deployment

Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook

Deployment

Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook

Customer Support

Business Hours
Live Rep (24/7)
Online Support

Customer Support

Business Hours
Live Rep (24/7)
Online Support

Types of Training

Training Docs
Webinars
Live Training (Online)
In Person

Types of Training

Training Docs
Webinars
Live Training (Online)
In Person

Vendor Details

Company Name

DataVantage

Founded

1986

Country

United States

Website

datavantage.com

Vendor Details

Company Name

Broadcom

Founded

1991

Country

United States

Website

www.broadcom.com/products/mainframe/product-portfolio/sql-ease-db2-for-zos

Product Features

Data Management

Customer Data
Data Analysis
Data Capture
Data Integration
Data Migration
Data Quality Control
Data Security
Information Governance
Master Data Management
Match & Merge

Alternatives

Alternatives

No Alternatives