Skip to main content

How to set up Talend ETL

Updated yesterday

Setup takes about 20-25 minutes.

Introduction

Connecting Talend ETL to Foundational allows it to determine lineage and extract ETL metadata. Talend (now part of Qlik) is a leading ETL (Extract, Transform, Load) solution. It offers a unified platform for data integration, ensures data quality, and provides robust big data capabilities. Organizations use Talend to move, manage, and govern data assets. You can connect Foundational to Talend Cloud or on-premises.

Qlik Talend Cloud​

Foundational extracts the full data lineage directly from your source code repository (e.g., GitHub, Azure Repos, etc.). To make the connection, you need to:

  • Grant Foundational access to the Talend source code repository

  • Connect Talend Cloud to Foundational

Talend Data Fabric (on-premises)​

Foundational connects to Talend services to extract ETL definitions. To make the connection, you need to:

  • Configure network access

  • Create user credentials for Foundational

  • Connect Talend Data Fabric to Foundational


Connect Talend Cloud

Connecting Foundational to Talend Cloud is simple.

  1. Access the source code repository where Talend code resides. To connect Foundational to source control repositories, see our collection of source control connector articles.

  2. Verify that Foundational has permissions to access that repository.

Once Foundational has access to the source control repository, the connection is complete, and Foundational starts to extract the full data lineage directly from the source files.


Connect Talend Data Fabric (on-premises)

Prerequisites

Ensure you have:

Access permissions

Foundational works with metadata only. It does not execute jobs or access data.

The permissions you assign enable Foundational to:

  • Authenticate with Talend Administration Center (TAC)

  • List Talend projects and jobs

  • Determine lineage and downstream impact

Configure network access

Allow Foundational access to the services listed.

Service

Ports

Purpose

Talend Administration Center (TAC)

8080 (default), 443 (HTTPS)

Authenticate users and list Talend projects

Talend code repository (Git, SVN, etc.)

22 (SSH), 443 (HTTPS)

Export ETL definitions

Create user credentials for Foundational

Foundational needs credentials for a user with (at least) read-only access. Choose one option.

If you use SSO and don’t have a password, you need to create a Personal Access Token (PAT) instead of a password, see option C below.

Option A: Create a dedicated read-only Talend user (recommended)

  1. Sign in to Talend Administration Center (TAC).

  2. Go to Users.

  3. Click Add.

  4. Use the Talend documentation to create a user.

  5. Save and store the username and password. You’ll need them to set up the connection.

Option B: Use an existing Talend user

  1. Identify an existing user.

  2. Confirm the user has (at least) read-only access.

  3. Confirm the user has a password.

  4. Save and store the username and password. You’ll need them to set up the connection.

Option C: Use a Personal Access Token (PAT)

Use this option if you use SSO and do not have a password. See the Qlik Talend documentation.

  1. Sign in to Talend Administration Center (TAC) as the user Foundational will use.

  2. To create the PAT, follow steps 1, 2, and 4 (omit step 3) in the Qlik Talend documentation.

  3. Copy and save the token. You’ll need the token (in place of a password) to set up the connection.

Connect Foundational to Talend Data Fabric (on-premises)

  1. In Foundational, open the Connectors & Integrations page.

  2. In ETL, select the Talend ETL card and click Connect.

  3. Click Add Account.

  4. The initial setup screen opens. Click Start Setup.

  5. The Set Up New Connection screen opens.

    ​​

    Enter the details:

    • Talend Administration Center (TAC) URL: The URL of your TAC server.

    • Username: The Talend username Foundational uses.

    • Password or Personal Access Token (PAT): The password Foundational uses or the PAT.

  6. Click Next.

  7. The final setup screen opens. To complete the connection, click Save.

That’s it. Whichever deployment method you used, Foundational is now connected to Talend ETL.

Did this answer your question?