Skip to Content
The SAP xMII Virtual Server Connector can be used to query data from a remote xMII Server datasource without establishing a direct connection to the datasource. This Blog aims to give a step by step direction as to how to go about it. Step – 1 : Identifying the Remote Datasource you need to connect to. Log on to the Remote xMII server where the datasource is residing and note the Datasource Name. In our example it is a SQL database with a datasource name of Supermarket. image Step – 2 : Configuring the Virtual Server connector on the Local xMII Server. In the Local xMII Server, go to Data Services -> Data Servers. image Uncheck the Show Only Enabled Servers checkbox and select the VirtualSQL Connector from the list. image Now enter the configuration parameters as explained below :

  • Name : The name by which this data source will be referred to (e.g. TestVirtualSQL for this example).
  • Enabled : Check this box to enable this data server.
  • Description : Any description of the data server connection.
  • IP : IP/MachineName of the Remote xMII Server.
  • LegacyURL : Check this if you are connecting to older xMII servers.
  • Port : The port the Remote xMII server is listening on. ideally it would be the number after the servername in the URL. (eg : http://:/Lighthammer/Menu.jsp) If nothing is mentioned after the servername then the default value of 80 would be fine.
  • Protocol : Default value of HTTP should be fine, however if you have HTTPS configured, the value entered should be https instead of http
  • RemoteLoginName : The Login name for the Remote xMII Server (not the Remote Datasource) with proper access rights to the remote datasource you want to access.
  • RemoteLoginPassword : The password for the Remote xMII Server.
  • RemoteServerName : The name of the datasource on the Remote xMII Server that you want to access (will be SuperMarket in our case).
  • TZOffset : The Time Zone Offset in minutes if a time difference exists between the local and the remote xMII server.

image Step – 3 : Testing the connection. Go to Data Servers->Query Templates and create a SQLQuery. Select the Virtual Server TestVirtualSQL in the Server list and choose the Query Mode. image Now choose the SQL Query Details tab and verify if the tables of the remote database are displayed in the Available Tables list. image Select a table, columns to query and test the query to see the results. Step – 4 : Troubleshooting. In case your connection fails when you try to access a Remote xMII server on your LAN, check under System Management->System Administration. image If you have a proxy server configured here, make sure you have checked the ProxyBypassLocal check box and have added the IP of the Remote Server to the ProxyBypassList parameter. image Please refer the Help Document http://:/LighthammerCMS/Help/System_Management/VirtualServerConnector.htm for details.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply