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.