Configuring an ETL Job: Step-by-Step Guide

Step 1: Access ETL Jobs in ReadyWorks

• Action:
  • Log into ReadyWorks.
  • Navigate to ETL Jobs from the main menu.
• Tip: Familiarize yourself with existing jobs to understand how they’re configured.

Step 2: Create a New ETL Job

• Action:
  • Click on New Job.
  • Choose to start with a blank template or clone an existing job if similar.
  • Tip: Cloning can save time if you’re importing similar data from the same source.

Step 3: Configure General Settings

• Job Name: Enter a descriptive name.
• Active: Set to Yes to enable the job.
• Allow Empty Tables: Decide based on whether downstream processes require the table.
• Destination Table: Provide a unique name (e.g., “cm_custom_data”).
• Data Identity: Usually matches the destination table unless differentiating between data sources.

Step 4: Set the Job Schedule and Order

• Job Schedule: Select Hourly, Daily, or Weekly.
• Order: Assign a number (e.g., 1 for the first job to run).

Step 5: Specify Fields to Index (Optional)

• Action:
  • In the Fields to Index field, list columns to index.
• Example:
  • ComputerName, LastLoggedOnUser
• Tip: Only index columns used in joins or filters to optimize performance.

Step 6: Define the Data Selection Query

• Action:
  • Enter your SQL query in the Data Selection field.
• Example: SELECT ComputerName, LastLoggedOnUser, OSVersion FROM SCCM_Computers
• Tips:
• • Test your query in a SQL client to ensure it works.
  • Ensure you have the necessary permissions to access the data source.

Step 7: Save and Activate the ETL Job

• Action:
  • Review all configurations.
  • Click Save to store the job.
• Tip: Double-check that the job is set to Active if you want it to run according to the schedule.