Our web applications retrieve mainframe data through .NET web services that talks to the Adabas SQL Gateway. The web application passes the SQL statement to the .NET web service and the .NET web service performs OPEN OLEDB connection, Issue SQL statement, closes the connections and returns data back to the web application. In this configuration, each SQL statement causes a subtask of the mainframe gatreway to be started. It is additional overhead.
Plus, if we wanted to secure with RACF, we would cause a call to RACF for each SQL statement. This is not feasible to do…
Ideally, we would like to be able to call the web service to open the connection and RACF authenticate the user and keep the connectin open until the user logs off.
How can we achieve this?