Changing connection details for SAP adapters

SAP nodes can get SAP connection details from either the adapter component or a configurable service. By using configurable services, you can change the connection details for adapters without the need to redeploy the adapters. To pick up new values when a configurable service is created or modified, you must reload the integration node or integration server to which the adapter was deployed, by using the mqsistop and mqsistart commands, or the mqsireload command.

Before you begin

Read WebSphere Adapters nodes and Configurable services for background information.

About this task

Use the SAPConnection configurable service to change connection details for an SAP adapter. The SAP node reads all connection properties from the adapter component that it is configured to use. If a configurable service exists that has the same name as the node's adapter component, the node uses the values that are defined in that configurable service to override the corresponding properties from the adapter. If any properties on the configurable service are set to an empty string, the values that are configured in the .inadapter or .outadapter file are used. The properties of the SAP configurable services are described in Configurable services properties.

Creating, changing, reporting, and deleting configurable services

Procedure

To create a configurable service, use the web user interface or the mqsicreateconfigurableservice command, as shown in the following example.
This example creates an SAPConnection configurable service for the SAP adapter mySAPAdapter.outadapter that connects to the SAP host test.sap.ibm.com, and uses client 001 for the connections into that server:
```
mqsicreateconfigurableservice IBNODE -c SAPConnection
-o mySAPAdapter.outadapter -n applicationServerHost,client
-v test.sap.ibm.com,001
```
To pick up the new values in the configurable service, restart the integration server and message flow.
To change a configurable service, use the web user interface or the mqsichangeproperties command, as shown in the following example.
This example changes the connections that are used by the adapter mySAPAdapter.outadapter. After you run this command, all adapters connect to the production system (production.sap.ibm.com) instead of the test system (test.sap.ibm.com):
```
mqsichangeproperties IBNODE -c SAPConnection -o mySAPAdapter.outadapter
-n applicationServerHost -v production.sap.ibm.com
```
To pick up the updated values in the configurable service, restart the integration server and message flow.
To display all SAPConnection configurable services, use the web user interface or the mqsireportproperties command, as shown in the following example:
```
mqsireportproperties IBNODE -c SAPConnection -o AllReportableEntityNames -r
```
To delete a configurable service that you created, use the web user interface or the mqsideleteconfigurableservice command, as shown in the following example:
```
mqsideleteconfigurableservice IBNODE -c SAPConnection
-o mySAPAdapter.outadapter
```
You can delete only configurable services that you created; you cannot delete IBM® predefined configurable service templates.