Data Source Connections

Connecting to SQL Server using Windows Authentication
SQL Server:   Datagaps ETL Validator v3.4.3 and later versions come with the JTDS JDBC driver to connect with SQL Server. There are two options to setup a...
Wed, 14 Jul, 2021 at 7:41 AM
Data Model Editor
This document documents the details on ETL Validator Data Model Usage
Sun, 26 Oct, 2014 at 8:50 PM
Connecting to Hadoop HIVE using Kerberos Authentication
Kerberos Authentication is the security mechanism that is commonly used for controlling access to the HDFS and HIVE. This knowledge base post is i...
Thu, 9 Sep, 2021 at 1:11 AM
How to find the host and Port for IBM DB2
For connecting to DB 2 database, ETL Validator currently requires the hostname and port number. But some of the customers might be configured to use a ODB...
Mon, 20 Jun, 2016 at 11:18 PM
Connecting to IBM DB2 with a specific Security Mechanism
IBM DB2 provides several options when it comes to security. IBM refers to these options as Security Mechanisms. Some of them are listed below:  CLEAR_...
Sat, 9 Jan, 2016 at 3:35 PM
Using custom JDBC URL for SQL Server Connection
A regular SQL Server connection using SQL Server Authentication in ETL Validator looks like below :  Notice that there is no option to prov...
Tue, 15 Mar, 2016 at 10:10 PM
Connecting to different flavors of IBM DB2 database
Background on IBM DB2 IBM DB2 comes in three flavors :  DB2 for LUW (Linux, Unix, Windows) DB2 for i (formerly known as DB2 for i5/OS) DB2...
Sun, 20 Oct, 2019 at 5:24 PM
Using SSH Tunneling to connect to Repository on Cloud
With more and more companies moving to the cloud (eg. AWS) , there is a possibility that access to the Repository/Workschema database (Oracle or Postgre...
Mon, 6 Feb, 2017 at 2:22 PM
Connecting to Salesforce
Salesforce as a Data Source is supported starting from ETL Validator v3.4.5. ETL Validator uses a commercial JDBC driver from Simba for performing the dat...
Fri, 27 Jan, 2017 at 8:13 PM
Accessing Flat Files/XML files in a Remote Location
It is common to have flat files (CSV and other delimited files) and XML files in a shared windows network drive or a linux/unix server with an SFTP access. ...
Thu, 4 Oct, 2018 at 6:18 PM