The Movio Connector enables Movio to securely synchronise the required data from your Vista database(s) into Movio. You will need two connector instances running, one connector for Vista Loyalty and another for Vista Head Office.
Installing the connectors
The Movio Connectors can be installed on remote computers if you do not want to install them directly on your Head Office or Loyalty servers. They require access to the Head Office and Loyalty databases, Loyalty web service, and the internet.
Prerequisites
- Set up a user with read-only access on your Loyalty and/or Head Office database. Please verify that the default language for the user has been set to "English".
- Set the user password to not expire
- The minimum Vista Loyalty version supported is 4.2.513
- The minimum Vista Head Office version supported is 4.2.513
- Your specific configuration settings and keystore file are provided by Movio, if you do not have these please contact us.
Installation
Run the movio-connector-setup.exe as an Administrator on the server you want to install the connector(s) on. The installer will prompt you to:
- Install the Loyalty and Head Office connector on the appropriate servers.
- Select an installation directory. (default: $PROGRAMFILES\MovioConnector)
- Once installation is complete, copy the keystore file to both the Loyalty and Head Office resources directories e.g. $PROGRAMFILES\MovioConnector\connector-headoffice\resources\ or $PROGRAMFILES\MovioConnector\connector-loyalty\resources\
Configuration
Depending on which connector(s) you installed you will see a connector-loyalty and/or a connector-headoffice directory inside the MovioConnector directory. To configure each connector, navigate to the appropriate connector directory, open the resources directory, and duplicate the default-connector.properties file renaming the new copy to connector.properties. Now edit the connector.properties file as follows:
|
db_host |
Enter the IP address or domain name of your database server |
|
db_port |
Enter the TCP/IP port number of your database server |
|
db_schema |
Enter the database schema name |
|
db_user |
Enter the username for the read-only Movio user |
|
connector_server_host |
Provided by Movio |
|
connector_server_port |
Always ensure this value is set to 443 |
|
connector_username |
Provided by Movio |
|
connector_type |
Always ensure this value is set to VISTA_HEADOFFICE or VISTA_LOYALTY |
|
http_request_execution_timeout_seconds |
Enter the timeout in seconds for requests to execution in. Defaults to 60 seconds. (optional) |
|
httpservice_VistaWS_enabled |
Always ensure this is set to true |
|
httpserice_VistaWS_url |
Enter the internal URL of your Vista Web Service endpoint e.g. http://1.2.3.4/visLoyalty/VistaLoyalty.asmx |
|
internal_proxy_host |
Enter the IP address or domain name of your internal proxy server (optional) |
|
internal_proxy_port |
Enter the port of your internal proxy server. e.g. 8080 (optional) |
|
internal_proxy_user |
Enter the proxy username for your internal proxy server (optional) |
|
key_store_file_name * |
Enter the file name for your keystore file, typically client-certs.jks. This should be in the same folder as your properties file. |
Windows Services
The installer sets up each connector as a window service (Movio Head Office Connector and Movio Loyalty Connector). After you've configured each connector you can start them via Services in Administration Tools. Make sure the connector services are configured to automatically start on reboot.
Updating the connectors
- Download the new connector here.
- Stop the "Movio Head Office Connector" and "Movio Loyalty Connector" Windows services.
- Back up the Head Office & Loyalty connector.properties and client-certs.jks files in a separate location. Usually these are found in $PROGRAMFILES\MovioConnector\connector-<headoffice/loyalty>\resources.
- Uninstall the old Head Office & Loyalty connectors by running the Uninstaller.exe file in the MovioConnector directory as an administrator.
- Install the new Head Office & Loyalty connectors.
- Place the backed-up connector.properties and client-certs.jks files in their original location.
- Start the Movio services that you stopped in Step 2.
- Let us know when the connector upgrade is complete.