Example of the SourceSystems.config file

The IBM® InfoSphere® DataStage® SAP BW RFC Server Manager is installed as a service named dsrfcmgr.exe in <DSSAPHOME>\DSBWbin on Windows (or UNIX). It runs automatically when the machine reboots. The program configures, starts, and stops the individual RFC Servers, named dsrfcsvr.exe, also located on these platforms in <DSSAPHOME>\DSBWbin. These servers run for each InfoSphere DataStage source system for SAP BW.

The InfoSphere DataStage server generates a text file named SourceSystems.config whenever you modify the list of source systems on a InfoSphere DataStage client machine. The control file tells the RFC Server Manager which RFC Servers should run with what configuration information.

An example of the content of the file follows:

SOURCESYSTEMS=<BEGIN>
<BEGIN>
DSPASSWORD=^L[^
INFOSOURCEDATAPATH=D:\Ascential\DataStage\SourceSystems\JDSRCSYS\Data
DSPROJECTNAME=test
SRCNAME=JDSRCSYS
RFCENABLED=FALSE
USEDEFAULTDATAPATH=TRUE
DSUSERNAME=AS
SRCDESCRIPTION=Test Source System
REFSERVERPROGID=wb-jdoe.JDSRCSYS
<END>
<BEGIN>
DSPASSWORD=LY[Y
INFOSOURCEDATAPATH=D:\Ascential\DataStage\SourceSystems\JDTEST\Data
DSPROJECTNAME=test
SRCNAME=JDTEST
RFCENABLED=FALSE
USEDEFAULTDATAPATH=TRUE
DSUSERNAME=FF
SRCDESCRIPTION=John Doe testing source system
REFSERVERPROGID=wb-jdoe.JDTEST
<END>
<END>
Note: Passwords appearing in the file are encrypted.

When the Manager launches an RFC Server instance, the Manager passes configuration information (Source System properties) to the RFC Server as command line parameters. The following Source System properties are passed to the RFC Server:

  • BW Application Server
  • BW System Number
  • BW SAP Router String
  • Default BW Logon User Name
  • Default BW Logon Password
  • Default BW Logon Client Number
  • Default BW Logon Language
  • RFC Server Program ID
  • Location of InfoSource data files
  • InfoSphere DataStage Project containing jobs that can be run using the DataStage Job parameter
  • InfoSphere DataStage Logon User Name and Password for running jobs

An RFC Server establishes a perpetual connection with the specified SAP BW application server machine and database system at the time of invocation. If the connection is broken on the SAP BW side, the RFC Server tries to reestablish the connection for one minute.

The RFC Server runs in a perpetual wait-state. SAP BW calls the RFC Server with requests.

If the job fails to run successfully, the extract is terminated.