Run Jobs and Services on DataFlux Integration Servers

Follow these steps to run jobs and services on Integration Servers from DataFlux (a SAS company):

1. Create jobs and services using the dfPower Profile and dfPower Architect software from DataFlux.

2. Upload the jobs to Integration Servers using the Integration Server Manager from DataFlux.

3. Create and run the SAS programs that run the jobs and services.

To run jobs and services, you do not need to load locales onto your local host. The DataFlux Integration Servers handle all interaction with your Quality Knowledge Bases.

For additional information, see these sections:

If security has been implemented on your Integration Servers, you need to include user names and passwords in the procedures and function calls that access those servers. You can specify the passwords directly, in plain text, or you can specify encoded passwords. SAS recognizes encoded passwords and decodes them before it sends the passwords to the Integration Servers.

The following example shows how you can encode a password and use that password in a call to the DQSRVSVC procedure:

/*   Encode password in file.  */
filename pwfile 'c:\dataEntry01Pwfile';
proc pwencode in='Oe3s2m5' out=pwfile;
run;

/*  Load encoded password into macro variable.  */
data _null_;
   infile pwfile obs=1 length=l; 
   input @;
   input @1 line $varying1024. l;
   call symput ('dbpass', substr(line,1,l));
run;

/*  Run service on secure Integration Server  */
proc dqsrvsvc 
   service="cleanseCorpName"  host="entryServer1"
   userid="DataEntry1"              password="&dbpass"
   data=corpName                   out=corpNameClean;
run;

For further information on the PWENCODE procedure, including information on the format of the encoded passwords, see the Base SAS Procedures Guide.

Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.