From the SAP xApp Manufacturing Integration and Intelligence (SAP xMII) main menu, select Data Services | Data Servers. A list of predefined servers appears on the Data Servers page.
Select the type of data source that you want to configure. The data source type is noted in the Description field. For example, "SQL Database."
Click the Copy button.
Enter a server name.
Select the Enabled check box to make the server active.
Edit the ServerURL parameter. Replace localhost with the machine name of the data source; however, if the data source is located on the server machine, localhost will suffice.
Edit the values in the other parameter fields.
Verify that the UserName is correct.
Enter a password.
Note: The system encrypts all passwords to your data sources for added security.
Click the Save button. A confirmation popup window appears.
Click the OK button in the confirmation popup window.
Click the Status button. The Connection Status page appears displaying the status of your data connections. A "1" in the ConnectionsAvailable column confirms a connection was made. A "0" means there is no connection to your data source. If you cannot establish a connection, confirm your settings for User, Password, and URL. Also verify that the Web server has the necessary security privileges to communicate with the data server. For more information on setting up a server, see SAP xMII System Configuration.
Note: The status page only shows information on JDBC servers in which a connection pool is built. Most tag-based servers such as UDS's do not respond to a status check.