Datagaps

https://www.startus.cc/company/datagaps

13800 Coppermine Road

Herndon, VA 20171

United States

Website

https://www.facebook.com/datagapsinc

General information:

Datagaps data validation and observability software helps automate the end-to-end testing of data migration, Data Warehouse, Data Lake, Data Quality, Data Reconciliation and BI projects. Datagaps is committed to helping clients trust their enterprise Data and BI projects. Whether you are using Microsoft Power BI, Tableau, Amazon Redshift, Snowflake, Azure Synapse or other platforms, our flagship solutions are here to help your business manage data-driven testing automation. Talk to us today and find out more about our data testing solutions.

Learn more about automated data testing, ETL testing tools, data migration testing tools, and cloud data warehouse services on our website.

Company information:

Company type:

Company

Industry:

IT - Software Development

Total numbers of employees:

Products and Services:

ETL Validator

Product category:

products

ETL Validator is an ETL Validating testing tool developed by Datagaps which helps in ETL validation and validating ETL ( Extract, Transform, and Load) during data migration and is one of the top ETL testing tools available in the industry and has multiple features and benefits when compared with competitors.

ETL Transformation Testing

Component test case supports testing of ETL transformations by providing a visual test case builder that supports extracting test data from multiple sources in a single test case.

DB Component: Supports Source Qualifier, Lookup, Sort and Joiner Transformations.
Script Component: Supports procedure transformation.
Baselining Capability: Target data can be saved as a baseline and used to compare with latest data for regression testing.

Connects to Popular Data Sources

ETL Validator connects to a wide variety of data sources. From time to time, we are constantly adding support for many modern data sources. If you don’t see a data source of yours, please send an email to us with your question.

Relational Databases: Oracle, IBM DB2, Microsoft SQL Server, Teradata, IBM Netezza, MySQL, PostgreSQL, AWS Aurora, SAP HANA.
Cloud Data Warehouses: Snowflake, Redshift, Azure Synapse Analytics.
Data Lake: AWS S3, Hadoop Hive, Cloudera, Hortonworks
Flat Files: Delimited Files (eg. CSV), Fixed width Files, XML, Microsoft Excel
SAAS: Salesforce

Easy Wizard Based Test Creation

ETL Validator makes it easy to test most common ETL testing scenarios by providing out-of-the-box support. Comes with an in-built Query Builder.

Data Quality Testing: Data Accuracy, Duplicates, Referential Integrity checks.
ETL Testing: Source to target data and data profile comparison, Incremental ETL testing.
Metadata Testing: Compare metadata across environments, Source to target metadata checks.

Enables Continuous Integration

By automating the data testing, ETL Validator enables Continuous Integration for your ETL Projects.

Integrates with Jenkins: ETL Validator provides a command line interface for kicking of Test Plans. Customers have used this interface to execute tests automatically from Jenkins.
Email Notifications: Key stakeholders are automatically notified by email.
Web Reporting: ETL Validator comes with out-of-the-box web reporting. Queries can be executed on the ETL Validator repository for additional reporting.

BI Validator

Product category:

products

The most comprehensive BI Testing tool / Testing Automation Solution for BI tools such as Tableau, Oracle Analytics and Microsoft Power BI.

Enables Continuous Integration for BI

By automating the BI Regression and Performance testing, BI Validator enables Continuous Integration for Business Intelligence application development.

Integrates with Jenkins: BI Validator provides a command line interface for kicking of Test Plans. Customers have used this interface to execute tests automatically from Jenkins.
Email Notifications: Key stakeholders are automatically notified by email.
Web Reporting: BI Validator comes with out-of-the-box web reporting. Queries can be executed on the BI Validator repository for additional reporting.

Compare Report Data & UI

BI Validator is integrated with the BI Platform’s REST API and Javascript API to making it easy to automate BI testing. It uses the metadata to completely eliminate the need for custom programming.

Report UI & data Testing: Baseline and compare reports to automatically identify data and UI differences.
Filters & Parameters Testing: BI Validator automatically retrieves Filters and Parameters making it easy to test the list of values displayed in a filter as well as applying them before running the reports.
PDF & Image Comparison: BI Validator compares PDF exports and Image snapshots of the BI dashboard and highlights the differences intuitively.

Easy Wizard Based Test Creation

BI Validator is tightly integrated with the BI tools making it easy to automate BI testing. It uses the BI tool metadata to completely eliminate the need for custom programming.

Regression Testing: Baseline and compare reports to identify data and UI differences.
Stress Testing: Simulate concurrent user load to identify system bottlenecks.
Adhoc Report Testing: Automatically tests different attribute and measure combinations.
Performance Testing: Track report performance trends and issues proactively.
Functional Testing: Compare report data with data from SQL Query.

BI Performance and Stress testing

Upgrade with peace by comparing BI dashboard performance before and after the upgrade.

Performance testing: BI Validator automates performance testing of dashboards by accurately measuring the time taken by BI bootstrap requests and tab-switch events. BI Validator further simplifies the performance recording.
Stress testing: The performance of the BI reports under concurrent user load can be tested using the stress test plan. Stress testing can be very helpful when adding new users or upgrading to a version of the BI Platform.

Perform End-to-end BI Testing

BI Validator helps automate the comparison of report data with database query output thus enabling end-to-end testing of BI reports and dashboards.

Compare Report to SQL Query output: Connect to any ODBC enabled data source and compare BI worksheet data with SQL Query output from the ODBC data source.
BI Tool Migration testing: BI Validator makes it simple to compare the data between reports from different BI tools. Data from one BI Platform can be compared with the data in another BI Platform.
Compare Summary to Detail report data: Compare aggregate metrics in a summary report with data in a detail report.

DataOps Dataflow

Product category:

products

DataOps Dataflow is a modern, web browser-based solution for automating the testing of ETL, Data Warehouse, and Data Migration projects. Use Dataflow to inject data from any of the varied data sources, compare data, and load differences to S3 or a database. With fast and easy to set up, create and run dataflow in minutes. A best in the class testing tool for Big Data Testing

DataOps Dataflow can integrate with all modern and advanced data sources including RDBMS, NoSQL, Cloud, and File-Based.

Enables Continuous Integration

By automating the testing of Data Lake and Data Migration projects, DataOps DataFlow enables Continuous Integration.

Integrates with Jenkins: DataOps Dataflow provides a command-line interface for kicking of Dataflows and Pipelines. Customers have used this interface to execute tests automatically from Jenkins.
Email Notifications: Key stakeholders are automatically notified by email.
Web Reporting: DataOps DataFlow comes with out-of-the-box web reporting. Queries can be executed on the Dataflow repository for additional reporting.

Connects to all Popular Data Sources

We support your data source in whichever form it is. You think of any kind of data source – whether it is a relational, NoSQL, cloud, or file data source – we support most of them.

Data Transformation Testing

DataOps Dataflow supports testing of Data transformations by providing a visual test case builder that supports extracting test data from multiple sources in a single test case.

SQL Component: Support transforming data using Spark SQL queries.
Code Component: Supports Python, Scala and R
Attribute Component: Rename columns and use spark SQL UDFs to transform data

DataOps Data Quality

Product category:

products

Displays a trend of Data Quality Scores for the enterprise. Users can drill down to review the scores at Data Model, Table, Data Element, and Data Quality Dimension levels. Data Quality Score is automatically computed based on the Data Quality Rules for data at rest as data in motion (ETL). An easy-to-monitor Data Quality Dashboard, competing with best-in-class Data Quality Tools.

Data Observability for Data Pipeline

By automating the testing of data being ingested in your Data Lake and Data Integration projects, DataOps Data Quality enables Continuous Integration.

Data Profiling: Profiles the datasets being ingested and maintains a repository of historical values.
Anomaly Detection: Uses Time Series based algorithms to predict expected value and identifies anomalies
Grouped metrics: Identifies deviations to business metrics and notifies users.

Connects to all Popular Data Sources

We support your data source in whichever form it is. You think of any kind of data source – whether it is a relational, NoSQL, cloud, or file data source – we support most of them.

Data Quality Dimensions

Support data quality checks for the following DQ dimensions

Completeness
Conformity
Validity
Accuracy
Uniqueness
Consistency
Timeliness

Test Data Manager

Product category:

products

Test Data Manager (TDM) is a self-service application that allows QA professionals to build test data on their own. Using Test Data Manager, QA teams can build, store, manage, edit, subset, mask, and find test data required to cover test scenarios. Testers don’t have to wait or search for the right test data. One of the best test data management tools available with an easy-to-use test data generator tool.

PII Data Masking

Data masking or data obfuscation is the process of hiding original data with modified content but at the same time, such data must remain usable for the purposes of undertaking valid test cycles.

Datagaps Test Data Manager helps mask the Personally Identifiable Information (PII) data in production environments and also keeping the data realistic and appear consistent.

GDPR Compliant-ready Test Data

With Datagaps Test Data Manager, hide sensitive and private data and convert it into meaningful, usable data. Implement best practices around data protection and privacy using data masking and avoid legal problems associated with GDPR.

Custom Size of Test Data

Datagaps Test Data Manager helps create the right size of test data for the right context. Increase test coverage by leveraging powerful synthetic data generation mechanism to create the smallest set of data needed for comprehensive testing as well as for specific business case scenarios.

Expert Services

Product category:

services

How it works

Our Expert Consultants guide you through your data testing requirements in the functional areas that include:

Configure Datagaps’ Products with other systems within your ecosystem.
Establishing a solid base of test cases and test plans for different scenarios in your environment.
Train and assist your team members in test creation.
Integrate Datagaps’ Products with the CI/CD process in your environment.
Managing your Datagaps’ Product instances for upgrades, backup and recovery.
Provide insights from Datagaps Product Development teams for complex scenarios.

Data Warehouse Services

Product category:

services

Datagaps is led by a team of ex-oracle employees that have implemented Oracle BI Applications for Oracle. Datagaps specializes in Data Warehouse and Business Intelligence services including Architecture, Installation and Setup, Development and Testing.

Architecture Services: High level and Low level designs
Development Services: ETL and BI Development
Installation & Setup Services: Operations and Maintenance
Testing Services: Automated testing using our tools