Talend Scheduling Scripts TAC Extraction Prerequisites

This topic briefs about the TAC Extraction Prerequisites.

In This Topic:

Introduction
TAC Export Process

Introduction

LeapLogic Assessment profiles existing inventory, identify complexity, lineage and provides comprehensive recommendations for migration to modern data platform.

TAC Export Process

Talend Administration Center (TAC) provides a web-based interface for managing and scheduling Talend jobs. To export schedule information and identify active or inactive jobs, you can use the TAC’s built-in features or query the TAC database. Here are two common approaches:

Approach 1: Use the TAC User Interface

Log in to TAC: Log in to the Talend Administration Center (TAC) using your credentials.
Access the Scheduler:
- In TAC, navigate to the “Execution” or “Scheduler” tab. The exact location and label of this tab may vary depending on your TAC version.
- In the Scheduler, you should be able to see a list of scheduled jobs.
Export the Schedule Information:
- Depending on your TAC version, there may be an option to export the schedule information directly from the TAC user interface. Look for an “Export” or “Download” button within the Scheduler.
- Export the information in a suitable format (e.g., CSV) that can be used for further analysis.

Approach 2: Query the TAC Database (Advanced)

This approach requires direct access to the TAC database, and it’s more suitable for advanced users who are comfortable with SQL queries and have the necessary permissions to access the database. Follow these steps:

Access the TAC Database:
- Use a database client (e.g., SQL client) to connect to the TAC database. You’ll need the database connection details and appropriate credentials.
Query the Scheduler Tables:
- Talend TAC stores scheduling information in its database. You’ll need to extract relevant tables to get schedule details from the tables: tac_job, tac_task, tac_schedule, taskexecutionhistory & taskexecution.
Export the Results:
- You can export the tables data to a suitable format (e.g., CSV).

Note:

Direct database access should be performed with caution, and you should have the necessary permissions and required database knowledge to execute queries safely.
The specific tables and schema structure may vary depending on your TAC version and configuration. Consult the Talend documentation or contact your Talend administrator for guidance on accessing and querying the TAC database.