Connectors

Connect to various data sources ..

Pentaho Data Quality

PDQ Connectors

x

x

Snowflake

Snowflake is a cloud-based data warehousing and analytics platform that separates compute from storage, allowing for scalable and flexible data processing. Snowflake supports structured and semi-structured data, enables data sharing across organizations, and provides features for data lakes, data engineering, and machine learning.

Before you define the Snowflake connection, ensure the prerequisite steps have been completed.

For further information:

1. Click: + icon in the top right-hand corner of the UI.

2. Select Snowflake from the connector list.

Snowflake Connector

1. Enter the following details to connect to your database.

Field	Setting
Connection name	The connection name has to be the same as defined in PDC.
Description
Account	Your Snowflake account
Warehouse
Database
Authentication Type	Username and Password
User
Password

1. Validate the connection details.

2. Click: 'Connect' and select the required Table and Queries - the following screenshot dsiplays the 'Synthea' tables.

Connection to 'Synthea'

x

x

MSSQL

PDQ only supports MSSQL versions beyond 2017.

x

1. Click: + icon in the top right-hand corner of the UI.

x

1. Select MSSQL from the connector list.

x

1. Enter the following details to connect to: MSSQL AdventureWorks2019 database.

Field	Setting
Connection name	mssql:adventureworks2019
Description	Demo dataset of fictitious bicycle manufacturer
Server	pdc.pdc.lab
Port	1433
Database	AdventureWorks2019
Authentication Type	Username and Password
User	sqlreader
Password	2Petabytes
Schema	Sales
Driver	mssql-jdbc-9.2.1.jre15.jar

x

1. Validate the connection details.

x

1. Click; 'Connect' and select the required Table and Queries.

x

x

x

Oracle

SyntheaTM is an open-source tool that generates synthetic patient data, simulating individuals' complete medical histories. This encompasses medications, allergies, encounters, and social health determinants for each mock patient.

Synthea

The generated data is free from legal and privacy concerns.

Synthes ERD

---

x

x

1. Enter the following details to connect to: Oracle business_apps_db (Synthea) database.

Field	Setting
Data Source Name	oracle:synthea
Data Source ID	Leave Blank to autogenerate
Description	Demo dataset of patients medical records
Data Source Type	Oracle
Affinity	Default
Configuration Method	Credentials
Username	sqlreader
Password	2Petabytes
*Host	pdc.pdc.lab
Port
**Driver	postgresql-42.7.1.jar
Database Name	business_apps_db

x