Data Sheets 3

• Data Sheets
• Useful Links
• How to extend Trial Period for Datagaps Products

Q & A 0

Installation 14

• Enterprise Deployment (Shared Repository)
• Bi Validator Architecture
• BI Validator Hardware Requirements
• Setting up Oracle Repository and BI Validator Server
• Updating BI Validator to the latest Chrome Driver

View all 14

Use Cases 9

• Test OBI Dashboards for Regression
• Test OBI Reports for Regression
• Stress testing OBI Environment
• Compare Report data with data in an Excel file
• BI Validator Usecase - Scheduler and Notification

View all 9

Cognos 1

• How to Specify Parameters in a Cognos Report?

Reference 9

• When I select prompts and click apply in OBIEE. Page keeps loading and we are unable to capture page after changing prompts or selecting new prompt values
• Stress Test Plan Parameters
• Setting up BI Validator with Selenium
• OBIEE: Adding Dashboard pages with prompt values
• How to test drill-down reports in BI Validator?

View all 9

Tableau 8

• Applying Filters
• How to test Tooltip data in Tableau Views?
• Login window pop up of Tableau while running Test plan despite automatic login is enabled
• How to check the reports are working properly and returning data?
• Worksheet data accuracy checking with set variance in the Report Test Plan

View all 8

Data Source Connections 5

• Creating a BI Connection for Tableau Online
• Connecting to MicroStrategy
• Creating an ODBC Connection
• Connecting to Snowflake
• Creating an Excel connection and data comparison

Troubleshooting 4

• What if the PDF/Result is Blank in the Report Test Plan?
• Why the PDF/Result contains weird data/text upon clicking the View link in the Result Column?
• After upgrading BI Validator, why the login screen is blank?
• In multi-user environment, after upgrade, why the scheduled jobs do not show up in the Jobs List tab of BI Validator Server screen?

FAQ 16

• What is the recommended hardware for AWS EC2?
• How do I benchmark reports?
• How do I remove selected reports/dashboards/accounts before running the test plan?
• Can I remove the test plan run history?
• Which setup file is required to run the trial version of BI Validator?

View all 16

Solutions for Resolved tickets 1

• #1299 Unable to Delete Users from the BI Validator

Installation 21

• Oracle Repository and Workschema requirements
• ETL Validator Deployment Models
• ETL Validator Upgrade Process
• ETL Validator Setup Guide
• Configuring email notifications

View all 21

Use Cases 30

• Compare flat file and a table
• Compare Table to Table (Source to Target)
• Validate a Flat File
• Data counts validation with allowed variance
• Test for Data Completeness

View all 30

FAQ 19

• What is ETL Validator?
• How can I login to ETL Validator Complete upon installation
• Can ETL Validator help check referential integrity?
• How does ETL Validator help test ETL data transformations?
• Does ETL Validator support sharing of Test Cases among multiple users?

View all 19

Reference 9

• ETL Validator Relational Model
• ETL Validator Performance Benchmark
• Email Notification issues
• ETL Validator - ALM Integration
• Setting up out of the box HTML Reports in ETL Validator

View all 9

Data Source Connections 18

• Connecting to SQL Server using Windows Authentication
• Data Model Editor
• Connecting to Hadoop HIVE using Kerberos Authentication
• How to find the host and Port for IBM DB2
• Connecting to IBM DB2 with a specific Security Mechanism

View all 18

Sample Files 1

• Sample Files

Troubleshooting 2

• DatagapsETLValidatorDatabase is not showing in Windows service section
• Apache log4j Vulnerability resolution steps

Solutions for Resolved Tickets 0

Installation 14

• DataOps Suite Hardware Requirements
• DataOps Installation with Yarn Cluster
• Yarn Cluster setup with Ansible
• DataOps Deployment Models
• High Level Implementation Plan for DataOps

View all 14

Connections 6

• Kerberized Hive Connection in DataOps
• Kerberized HDFS File Connection in DataOps
• ADLS Gen2 Connection for JSON,CSV,XML from DataOps
• Cassandra Database Connection setup with Catalog option
• AWS S3 Connection Requirements

View all 6

Dataflow 9

• DataOps Performance Stats
• DataOpsEMR Pricing
• Code to read csv file, skipping top and bottom rows with pipe delimiter. And replacing special characters with underscore.
• Code to skip last record from the dataset.
• Read xls which has html data.

View all 9

Test Data Manager 0

Components 0

Troubleshooting 8

• DatagapsDataOpsRepository is not showing in Windows service section
• Apache Vulnerability (CVE-2021-44228) - DataOps Suite for Linux instance
• Apache Vulnerability (CVE-2021-44228) - DataOps Suite for Windows instance
• Apache Log4j 1.2.17 Vulnerability Mitigation Steps Taken in Datagaps Products
• CSV to JDBC Table Migration

View all 8

Performance Statistics 1

• 1 Billion records Comparison With DataOps using EMR

Solution For Resolved Tickets 0

Enhancements 0

Issues 0