You are here: Folders Riser Bar>Using the Address Update Add-On>Using the Address Update Add-On with Data Management Server

DataFlux Data Management Studio 2.5: User Guide

Using the Address Update Add-On with Data Management Server

Overview

The DataFlux Data Management Server provides a scalable server environment for large DataFlux Data Management Studio jobs. Address update jobs can be imported from DataFlux Data Management Studio to a Data Management Server, where the jobs are executed. One approach would be to run test jobs and small jobs on the DataFlux Data Management Studio computer, and to upload larger jobs to the Data Management Server. Under this approach, both DataFlux Data Management Studio and Data Management Server must have all of the software, licenses, DSN connections, and other resources that are required to execute address update jobs and reports.

If you are using both DataFlux Data Management Studio and the DataFlux Data Management Server to execute Address Update jobs, a typical approach is as follows:

Enable Jobs on a Data Management Server to Access an Address Update Repository

Address update jobs must be able to access an address update repository from the computer where the jobs are executed. Accordingly, if you deploy address update jobs to a Data Management Server, these jobs must be able to an address update repository from the server.

The first task is to view the properties of the DSN that was used to create the address update repository in DataFlux Data Management Studio.

  1. In DataFlux Data Management Studio, select Tools > Address Update: NCOALINK PAF Administration.
  2. In the PAF administration dialog, choose Select address update repository from the action menu.
  3. Select the DSN of the address update repository that you want to make available to jobs on the Data Management Server. Make note of the DSN name.
  4. Go to the Data riser and expand the Data Connections folder.
  5. Right-click the DSN that you identified above and select Properties to view a properties dialog for the DSN.
  6. Use this dialog to view the connection type, the path to the address update repository, and other connection attributes that are required to access the address update repository.

If an address update repository has a DSN that points to a DBMS such as Oracle, DB2, Teradata, or SQL Server, then you can create the same DSN with the same DSN name on the Data Management Server. This address update repository should now be available to any address update jobs that are deployed to the Data Management Server.

If an address update repository has a DSN that points to a file path, such as an SQLite file, then you can perform the following steps.

Create the same DSN with the same DSN name on the Data Management Server. If the file path to the address update repository is accessible from the Data Management Server, then the address update repository should now be available to any address update jobs that are deployed to the Data Management Server.

If the file path to the address update repository is not accessible from the Data Management Server, you could copy the address update repository file to the Data Management Server or make it available on a shared drive. Create the same DSN with the same DSN name on the Data Management Server, except update the path for the server. This address update repository should now be available to any Address Update jobs that are deployed to the Data Management Server.

Deploy an Address Update Job to a Data Management Server

It is assumed that you have met the prerequisites that are described in Overview above. Perform the following steps to deploy an address update job to a Data Management Server:

  1. Open the Data Management Servers riser.
  2. Navigate to the jobs folder and right-click it to access a pop-up menu. Click Import to display the Import From Repository wizard.
  3. Navigate to the data or process job that you just created and select it. For example, you could select a data job that runs the Address Update Lookup and two process jobs that contain report nodes, as shown in the following display:

  4. Click Next to access the Import Location step of the wizard.
  5. Select the Batch folder, where the Data Management Server expects to find data jobs and process jobs. This selection is shown in the following display:

  6. Click Import. Review the log to verify that the import operation completed successfully.
  7. Click Close to close the wizard. The job has been deployed to the server. The next task is to verify that the deployed job will execute properly.
  8. To run the imported jobs, right-click each job and click Run in the pop-up menu.

 

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfDMStd_T_NCOA_DManServ.html