DataOps Suite supports data validation for different kinds of Data sources. Along with other Data sources also it has support for Rest API. DataFlow is a powerful application using which you can easily perform end-to-end automation of a data migration pr ...
Datagaps Blog
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 requires multiple steps. Data Validation is the key to success of data migration projects. Datagaps Data Flow ...
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 by creating a new record in the dimension whenever a value in the set of key columns is modified and maint ...
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 Education etc. While the problems related to data testing are similar across industries and JSON and ...
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 for the 3rd consecutive year. At Datagaps, this is pretty important for us as the testing automation needs for various BI platforms follow a similar trend. It is i ...
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 case is for the CRM capabilities. In addition, many organizations have started using the power of the force ...
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 EBS 11i to R12, most companies reimplement R12 and migrate the data from their 11i instance. Reimplemen ...
Testing Automation of OBIEE Subject Areas
Subject Areas in Oracle OBI are great for business users. They hide the complexity involved in warehousing projects and present an easy to use mechanism to create adhoc analysis based on the business user's need. From an IT perspective, test ...
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 patterns, popular techniques and the typical challenges associated with this pattern. Though the article is ...
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 infrastructure can support this kind of load. So they asked us to perform stress testing using BI Validator with the ...
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 example OBIEE 11g to 12c upgrade or Business Objects 4.1 to 4.2 upgrade. Testing is an important aspect of the ...
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 to 11.1.1.9 or Business Object 4.1 SP5 to 4.1 SP 7). However, there are a number of risks which n ...
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 systems. This blog is to highlight on one such example. The customer offers a survey related product and the conf ...
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! Writing code in Python is something I enjoy when I want to get a break from my routine job of putting together ...
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 transaction systems). Here are the high level tests done in each: ETL Testing : Primary goal is to check if the dat ...
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 great job of putting together wonderful sessions spanning all areas of Analytics. Balaji Yelamanchili sha ...
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. I got a similar request from another prospect recently and thought that it might be a good idea to bl ...
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 dashboards which are widely used by your marketing, sales, finance and other divisions within your e ...
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 RPD. Warning – Missing functional dependency association of a column. Any Logical Table Source th ...