Data Source Connections

Connecting to Oracle Database in ETL Validator
At Datagaps, one of the key challenges is our ability to empower customers to test with ease. ETL Validator is a very powerful and intuitive tool that helps...
Thu, 16 Nov, 2017 at 7:28 AM
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 Educati...
Wed, 11 Jan, 2017 at 7:33 PM
Creating Apache Drill Connection in ETL Validator
Apache Drill Apache Drill is an open source tool.  Using this tool we can query a variety of NoSQL databases and file systems, including HBase, MongoDB, ...
Tue, 28 Aug, 2018 at 4:23 AM
Connecting to Azure SQL Data Warehouse
ETL Validator can be used to compare data between Azure SQL Data Warehouse and other data sources. This post details the steps to create a Data Source conne...
Sat, 10 Nov, 2018 at 7:08 PM
Reading data from a HDFS Data Source
 ETL Validator v3.4.8 comes with an embedded Apache Spark that can used to read files directly from HDFS. This article outlines the steps to create a HDFS C...
Mon, 12 Nov, 2018 at 5:51 PM
Connecting to Hive Cloudera Using Kerberos Authentication
Configuring Hive Cloudera to use Kerberos authentication includes the following two steps: Configuring Hive connection in server machine  Adding connecti...
Thu, 21 Nov, 2019 at 1:17 PM
Generic connections of ETL Validator
ETLValidator will only support Oracle or Postgres as Repository, and this both are ETLValidator internal databases. By default we will install postgres. ...
Wed, 25 Sep, 2019 at 10:58 AM
Connecting to Athena
Amazon Athena is a server less interactive query service capable of querying data from Amazon Simple Storage Service (S3) using SQL. It is designed for shor...
Fri, 4 Oct, 2019 at 4:02 AM