Datagaps Blog
Data Profiling In Pharma Datasets Using DataOps Suite
Data profiling is a crucial step in the data management process, especially in the pharmaceutical industry where accurate and reliable data is...
Generate Complex SQL Queries Using DataOps Suite Query Builder
An Introduction to Query Builders Query Builder is a tool that allows users to create complex SQL queries without needing in-depth knowledge of the...
ETL Testing In Snowflake Using DataOps Suite
Introduction and Overview of ETL TestingETL stands for Extract, Transform, and Load. It is the process by which data is extracted from one or more...
Data Quality in Financial Institutions – Partial Flattening of Mainframe Complex Files
COBOL and Financial Institutes COBOL (Common Business-Oriented Language) is a programming language that was developed in the 1950s and remains in...
5 Critical Steps To Achieve Trustworthy Data in your Data Warehouse
Data Warehouses provide a comprehensive view of data across many different sources, and proper analysis can encourage better business decisions and...
Monitoring Your Data Pipelines In Production – DataOps
DataOps is managing data in its raw form or transforming it from one format to another. It ensures that the data flowing through your production...
Validation Of Complex and Hierarchical JSON and XML files
Complex Structural Hierarchical JSON and XML filesWhy are complex structural and deeply hierarchical JSON and XML files so difficult to...
Top 4 ETL Testing Tools
What Is ETL Testing? ETL Testing refers to the testing, validation, and analysis of the Extraction, Transformation, and Loading Processes that are...
Validation of Salesforce Objects, Uploads and Updates
Understanding Validation of Salesforce Objects, Uploads, Updates and How Datagaps DataOps Can Help Intro to Salesforce Salesforce is a cloud-based...
Top 5 Must Haves In Your Data Testing Platform
No matter how many new features an application has, how clean the user interface is, or even how fast the content is delivered across the Internet,...
Data Drift Using DataOps Data Profiling
What Is Data Drift?What is Data Drift? Within the data space, the only constant thing is "change". The drift in data here refers to a multitude of...
6 Critical Components of Data Testing
Importance of Data and Data Testing Data is a precious asset that has to be validated at various stages of use. One stage is at the point of...
Oracle to Azure Synapse Data Warehouse Migration Validation
This article discusses how a migration from Oracle to Azure Synapse data warehouse can be validated from an End-to-End perspective.Why migrate from...
DataOps Suite Feature Updates – Version 2022.5.0
Datagaps Inc. announced its latest product feature updates for the DataOps Suite Version 2022.5.0 - The theme of this update is Integration and Easy...
Oracle to Azure SQL Server Migration Validation
This article discusses how a migration from Oracle to Azure SQL Server can be validated from an End-to-End perspective.Why migrate from Oracle to...
How To Evaluate ETL Testing Tools
Why ETL Testing is Important Today, Data has become the core of any business, and ETL processes are important for every data-related project. Be it...
Leveraging DataOps Suite to comply with BCBS, SOC2 and other regulations
Many industries are regulated and have to adhere to a set of guidelines and industry standards. While we are a software company, we have been...
Data Validation for Snowflake
Migrating to Snowflake Cloud Data Warehouse Migration from a legacy data warehouse such as Netezza to a cloud-based Snowflake data warehouse...
Datagaps Attains Snowflake Select Technology Partner Status
Datagaps Inc. announces a new partnership with Snowflake, the Data Cloud company. Datagaps attains Snowflake Select Technology Partner in the space...
Testing Automation of OBIEE Subject Areas
Subject Areas in Oracle OBI. Subject Areas in Oracle OBI are great for business users. They hide the complexity involved in warehousing projects and...
Datagaps Data Validation and Migration To Snowflake
This article discusses why and how to use both together, and dives into the challenges of Bulk Data Migration to Snowflake.Why and How? People are...
Challenges In Data Migration To Cloud
We’ve decided on a new Cloud-based Data Warehouse. Now what? We’ve recently seen an uptick in data validation inquiries with Cloud Data Migration...
7 Incredible Test Automation Plans for Tableau using BI Validator
It is nice to see Tableau maintain its leadership position in Gartner’s magic quadrant. At DataGaps, this is pretty important for us as the testing...
Why ETL Validator when there is Python?
I am not sure if you ever wrote Python but it is one of the coolest language out there. Easy to learn, easy to write and do yeah, easy to read!...
What Are Data Quality Dimensions?
"A recent survey by TDWI found that 66% of organizations are looking for ways to improve data quality and trust. Data Validation using Data Quality...
How to Perform Continuous Data Validation?
At a recent TDWI virtual summit on “Data Integration and Data Quality”, I attended a session titled “Continuous Data Validation: Five Best...
Pitfalls of Cloud Data Migration
" 36% of data migration projects kept to the forecasted budget, and only 46% were delivered on time " -Forbes This statistic shows a grim picture of...
How Do You Automate Big Data Testing? Everything To Know
Big Data has passed the tipping point. It's no longer a fringe interest being practiced by data scientists. The Big Data industry is currently on...
Bookmarks Development and Testing
Tableau, Power BI, OBIEE, Cognos, Qlikview, Looker, Micro Strategy, and other developing BI Visualization technologies have pushed business...
Slicers Testing in Power BI Report
One of our clients decided to change their reporting platform to Power BI and started rebuilding their reports. However, they had a large number of...
DataOps Suite: Validate Rest API Response
DataOps Suite supports data validation for different kinds of Data sources. Along with other Data sources also it has support for Rest API. DataFlow...
Testing Type 2 Slowly Changing Dimensions using ETL Validator
Type 2 Slowly Changing Dimensions are used in the Data Warehouses for tracking changes to the data by preserving historical values. This is achieved...
Connecting to Mongo DB using Apache Drill in ETL Validator
Over the last few years, we have been working with a number of customers across various industries such as Life Sciences, Financial Services, Higher...
Data Testing Automation for Salesforce using ETL Validator
Over the last few years, the Salesforce platform has become an incredible force in the market for various reasons. Of course, the most obvious use...
Database (Backend) Testing for Oracle R12 Upgrade
Oracle E-Business Suite (EBS) R12 is a significant new version with valuable new features and capabilities. Although there is an upgrade path from...
ETL Validator for Data Migration Testing
Recently, I stumbled upon a relatively old article on Data Migration from TDWI that explains what it is, how it is different from other integration...
Simulating load for BI Stress Testing
One of our customer is planning to roll out new BI functionality to 2000 additional users. They were concerned whether their current BI...
The Role of BI Validator in Major BI Upgrades
Every few years the BI vendors have a major release that forces the companies using these products to uptake a complex BI upgrade project. For...
The role of BI Validator in “In-Place” Upgrades
As most of us in the BI community are aware, In-Place upgrades are fairly common when clients want to go through minor upgrades (e.g OBIEE 11.1.1.7...
ETL Validator for Testing Transactional Systems
Most of the use cases that we encounter are for DW scenarios. However, recently, we are also seeing many scenarios for testing transactional...
Difference between ETL and Database Testing
ETL testing applies to Data Warehouses or Data integration projects while Database Testing applies to any database holding data (typically...
BIWA SIG 2014
We just came back last night from BIWA SIG (http://www.biwasummit.com), a BI related event that was held in Redwood City, CA. The organizers did a...
Database Testing – Ensure acceptable variance in Data differences
At a recent event, one of the prospects at the attendees came over to our booth and asked me to demonstrate a use case that was kind of interesting....
OBI Dashboard Regression Testing
Below is a simple and real example that illustrates how you can leverage BI Validator for regression testing of dashboards. Assume that you have 250...
OBIEE 11g upgrade : Fixing consistency check errors during RPD Upgrade
This article walks you through the consistency check warnings found in the BI Apps RPD after running the 11.1.1.7 upgrade assistant on an 10.1.3.4.1...
Subscribe to get updates about our product enhancements, newsletters, webinars, and more information.
By subscribing, you are allowing Datagaps and/or its associates to reach you with periodic informative updates.