Data Source Connections
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
This document documents the details on ETL Validator Data Model Usage
Sun, 26 Oct, 2014 at 8:50 PM
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
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
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
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
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
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
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
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