Q-Bot Standard Edition
Linux/Unix
Product Overview
Q-Bot(Quality Bot) is a BI/DWH Test automation tool, which is used to validate the quality and accuracy of the data.
It loads data from different sources, uses Apache Spark to convert the data as data frames, and do different checks, finally produce the result as a report.
Data Validation can be done in the below forms
- File(CSV, Text) Validation (Source can be a remote file, S3 File)
- File to File Validation (Source and Target can be a remote file, S3 File)
- File to DB Validation
- DB to DB Validation (Currently it supports MySQL, SQL Server, Redshift, and Snowflake)
- Custom Query (Directly pass the query to retrieve data from the source and target)
Different checks handled during Data Validation
. Header Check - For file related test groups
. Detail Record Check - For file related test groups
. Trailer Check and Trailer Aggregation Check - For file related test groups
. Primary Key Check
. Null Check
. Data Type Check
. Length Check
. Report Statistics
. Range Check
. Transformation
. Row Level Validation Check
Customers can access our application on an EC2 Instance that is launched using a CloudFormation template.
While launching the CloudFormation stack the customer can choose the VPC, Subnets, and the instance type as they want.
Once the stack creation is successful, the users can access the application by SSH tunneling.
Version
Q-Bot Standard Edition V2.0
Video
Operating System
Linux/Unix, CentOS 7.8.2003
Delivery Methods