SAP tables via Informatica

For UofT Informatic Users

When you're running an Informatica that connects to tables in SAP, a speciall connection is required.

First, you need to create a shortcut to the R3 verify program (R3vfy32.exe) with appropriate parameters. Once you have the shortcut created, right-click to get the Properties tab. In the Target line add in "C:\Program Files\UofT\R3Verify\R3vfy32.exe" poort.utcc.utoronto.ca * (ROUTER) <>. This assumes that your R3Verify is in the same directory, otherwise make the necessary entry.

Second you will need to make a Registry adjustment. In Notepad, cut and paste the following:

REGEDIT4
[HKEY_LOCAL_MACHINE\SOFTWARE\UofT\ROUTER]
[HKEY_LOCAL_MACHINE\SOFTWARE\UofT\ROUTER\config]"sqlmode"=dword:00000001"remoteport"=dword:000033f3

Save the file as Router98.reg.

Double click on the file Router98.reg and it will insert the appropriate information into your Registry.

Just before you decide to run the Informatica program, double-click on the shortcut and put in the required security information. Once connected, run your program.