# Integration

{% hint style="info" %}

{% endhint %}

x

{% tabs %}
{% tab title="Email" %}

{% endtab %}

{% tab title="PDQ Connection" %}
{% hint style="info" %}
Pentaho Data Quality (PDQ) integrates with Pentaho Data Catalog (PDC) enabling the user to pull metadata information from PDC to semantic layer in PDQ. 

The following information is pulled from PDC:

1. Connections
2. Domains
3. Tags
   {% endhint %}

#### Mappings

{% hint style="warning" %}
Before you connect to PDC and pull the metadata, consider the mappings between PDC & PDQ.

● A Term in the attribute level will pulled and mapped to the same attribute in PDQ for the asset. 

● The Tags will also be mapped for the same assets. 

● The PDC Glossary will be added as a domain to the asset in PDQ - with prefix HitachiPDC\_

● The creation and assignment of metadata will occur in a PDC job.

● The data source in PDQ needs to be the same name in PDQ.
{% endhint %}

The following is the mapping between PDC & PDQ:

| PDQ         | PDC         |
| ----------- | ----------- |
| Connections | Data Source |
| Domains     | Glossary    |
| Tags        | Tags        |
| Terms       | Terms       |

<figure><img src="/files/PK6bROReo6Wk1WiQCE6p" alt=""><figcaption><p>Integrations</p></figcaption></figure>

1. Click on the Hitachi | Pentaho Data Catalog Tile.
2. Enter in the following connection details:

| Settings |                       |
| -------- | --------------------- |
| Host     | <https://pdc.pdc.lab> |
| User     | <system_admin@hv.com> |
| Password | Welcome123!           |

{% hint style="warning" %}
Limitation

1. The integration is only supported for the following connectors :&#x20;

&#x20;           ● MSSQL&#x20;

&#x20;           ● Oracle

&#x20;           ● Snowflake

2. If a term is created under a category, then only the parent glossary will be created in PDQ

3. The username and password has to be provided by the user and the asset has been selected for a connection in PDQ. The integration will not pull the username and password of a data source connection from PDC.
   {% endhint %}

4. Select all the Field options

<figure><img src="/files/NfdfK3Zvbth5ptBQ8ZP1" alt=""><figcaption><p>PDC Integration - Connection</p></figcaption></figure>

3. Validate & save the connection.

{% hint style="info" %}
The user can use the refresh button to refresh the integration data in PDQ.&#x20;

The refresh will only refresh the semantic section of PDQ and not update the mappings to the asset until the Catalog update task is triggered as part of the asset run.
{% endhint %}

***

x

<figure><img src="/files/n6ee2gjGqqqF2mFOif7f" alt=""><figcaption></figcaption></figure>

x
{% endtab %}

{% tab title="Second Tab" %}

{% endtab %}
{% endtabs %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://academy.pentaho.com/data-quality-en/pentaho-data-quality/pdq-settings/integration.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.