2. If the job completes without error, go to the next step. If error messages appear, read
and respond to the messages.
3. Right-click the target table and select View Data. The following display depicts the
cluster and match code columns in the target.
Display 17.22 Output from a DataFlux Data Service
Using a DataFlux Job or Profile in a SAS Data
Integration Studio Job
Problem
You want to incorporate a DataFlux Data Management Studio data job, process job, or
profile into the flow for a SAS Data Integration Studio job.
Solution
Create or identify a data job, process job, or profile in DataFlux Data Management
Studio. Deploy the job or profile to a DataFlux Data Management Server. Create a SAS
Data Integration Studio job and add a DataFlux Batch Job transformation to the job.
Configure this transformation so that it specifies the DataFlux job or profile on the
server. Execute the SAS Data Integration Studio job.
You will perform the following tasks:
“Verify Prerequisites” on page 356
“Create or Identify a DataFlux Job or Profile” on page 356
“Create and Populate a Job in SAS Data Integration Studio” on page 356
“Configure the DataFlux Batch Job Transformation” on page 357
Using a DataFlux Job or Profile in a SAS Data Integration Studio Job 355
Tasks
Verify Prerequisites
In addition to the “General Prerequisites for Data Quality Transformations”, the
“Prerequisites for Running a DataFlux Job or Profile in a SAS Data Integration Studio
Job” on page 338 must be in place.
The current version of SAS Data Integration Studio can execute data jobs, process jobs,
and profiles that were created with DataFlux Data Management Studio. You can also
execute Architect jobs that were created with DataFlux dfPower Studio, if the Architect
jobs do not contain macros. Architect jobs that contain macros must be migrated to
DataFlux Data Management Studio. For more information, see the DataFlux Migration
Guide.
Create or Identify a DataFlux Job or Profile
Create or identify a DataFlux job or profile. For example, you could choose the
DataFlux Data Management Studio profile for the MANUFACTURERS table, as shown
in the next figure.
Display 17.23 Profile Shows Data Errors in the Name Column of the MANUFACTURERS Table
The job must be deployed to a DataFlux Data Management Server, so that it can be
accessed from SAS Data Integration Studio. For information about data jobs, process
jobs, and profiles, see the appropriate chapters in the DataFlux Data Management Studio
User’s Guide.
Create and Populate a Job in SAS Data Integration Studio
Create a SAS Data Integration Studio job and add a DataFlux Batch job transformation
to the job, as shown in the next figure.
356 Chapter 17 Working with Data Management Platform
Display 17.24 Job with a DataFlux Batch Job Transformation
The DataFlux Batch Job transformation has no connection ports for data inputs or data
outputs. It is just a reference to a DataFlux job.
Configure the DataFlux Batch Job Transformation
Open the Properties window for the DataFlux Batch Job transformation. On the Job tab,
select the DataFlux Data Management Server and select the appropriate DataFlux job.
The next figure shows the values for the sample job.
Display 17.25 Job Tab for the DataFlux Batch Job Transformation
In the previous figure, the Server field specifies the DataFlux Data Management Server
where the job was deployed.
The Job type field specifies the type of DataFlux job that is available in the Job field.
Select Batch for file-based jobs, such as data jobs and process jobs. Select Repository
for repository-based jobs, such as profiles.
The Job field specifies the job to be executed.
Click OK to save your input and close the properties window. The job is now ready to
run. When you run the job, the specified DataFlux job is executed. Depending on the
nature of the job, the results might not be viewable in SAS Data Integration Studio.
Using a DataFlux Job or Profile in a SAS Data Integration Studio Job 357
358 Chapter 17 Working with Data Management Platform

Get SAS Data Integration Studio 4.9 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.