Main Task Flow for Users

---

SAS ETL Studio is an application that enables you to manage ETL process flows—sequences of steps for the extraction, transformation, and loading of data. ETL process flows are saved in a job: a metadata object that specifies processes that create output. SAS ETL Studio uses each job to generate or retrieve SAS code that reads sources and creates targets on a file system.

The following steps summarize the task flow for creating jobs. It is assumed that all installation and setup tasks have been completed as described in Chapter 5, "Setup Tasks for Administrators," on page 37.

1. Identify the job that must be added or updated. This is basically a matter of identifying the sources and targets that will address a business need in your project plan, as described in Chapter 4, "Example Data Warehouse," on page 27.

2. Start SAS ETL Studio. For details, see "Start SAS ETL Studio" on page 56.

3. Create the appropriate metadata profile if one does not already exist. For details, see "Create a Metadata Profile" on page 57.

4. Open the appropriate metadata profile. For details, see "Open a Metadata Profile" on page 58.

5. Add metadata for the job's inputs (sources). For details, see "Specifying Metadata for Sources and Targets" on page 60.

6. Add metadata for the job's outputs (targets). For details, see "Specifying Metadata for Sources and Targets" on page 60.

7. Create and run the job. For details, see "General Tasks for Jobs" on page 113.

---