About Microsoft SQL Server Use Cases

The Microsoft SQL Server can be used in scenarios such as the following:

You can create an integration that includes an SOAP Adapter connection on the source (inbound) side and a Microsoft SQL Server on the target (outbound) side. For example, when configuring the target Microsoft SQL Server, you can select a stored procedure that enables you to pass an employee ID as an input parameter from the SOAP Adapter to an on-premises SQL database to retrieve additional information about the employee (first name, last name, email ID, and so on). The request is sent to the on-premises agent for execution. The employee results are then returned to Oracle Integration.