Addon Connector Jiwa

The SQUIZZ.com Jiwa Addon Connector is a separate application from the SQUIZZ.com Connector software, that allows Customer Account Product Pricing data to be extrapolated and exported from Jiwa's  underlying database. The SQUIZZ.com Jiwa Addon Connector runs as a web service on Microsoft Windows operating systems (version 7/2012 and higher), that can be periodically called by the SQUIZZ.com Connector software to export data from Jiwa.

Within the SQUIZZ.com Connector software a Generic adaptor can be configured call the Jiwa Addon Connector and then export to the SQUIZZ.com and TOTECS platforms.

The SQUIZZ.com Jiwa Addon Connector provides a web interface that allows its web service to be configured, based on a number of different settings that control how it communicates with Jiwa's underlying database stored in a Microsoft SQL Server instance. The web interface also allows credentials to be set up to limit how other software can talk to the addon Connector.

SQUIZZ.com Jiwa Addon Connector Web Service

The SQUIZZ.com Jiwa Addon Connector gets installed as a Windows service that always runs within the background of Windows, regardless of any users who are currently logged into Windows at the time. This allows the addon connector software to be called by the SQUIZZ.com Connector software at any time to export from Jiwa. Within the SQUIZZ.com Connector software It's recommended to set up scheduled data exports, that call the addon connector to export data at off peak times, to reduce the load on the Microsoft SQL Server, as well as the computer running the addon connector software.

Product Customer Account Pricing Data Export

The SQUIZZ.com Jiwa Addon Connector contains pre-built configurations on how it obtains customer account product pricing data from the Jiwa system. It will do this by first retrieving all relevant data from ths Microsoft SQL Server database storing the Jiwa data, this includes the product list, customer accounts list (debtors), debtor classification rules, inventory classification rules, and group rules. It will then extrapolate out these rules to produce a final list of product prices specific to each customer account, or based the same group of customer accounts that have the same tailored pricing. Optionally the pricing can be also obtained from a separate second Jiwa installation, then combined together into one final pricing list. This pricing data is then exported in its final form from the addon connector.

To install the SQUIZZ.com Jiwa Addon Connector software and configure it with the SQUIZZ.com Connector software, check that the computer that the addon connector is being installed on meets the following prerequisites. If it does then follow the steps below:

Prerequisites:

• Microsoft Windows Operating system. Version 7 or higher, or WIndows Server 2012 or higher.
• Windows user with privileges to install Windows services
• Microsoft.NET library version 4.6.1 or higher is installed.
• Computer operating system drive contains at least 2 Gigabytes of available space.
• Computer contains at least 1GB of RAM memory.
• SQUIZZ.com Connector Host Service is installed.
• SQUIZZ.com Connector application is installed.
• Computer has network access to the internet.

SQUIZZ.com Jiwa Addon Connector Installation and Setup Steps:

1. On a computer running the Microsoft Windows operating system (version 7 or higher , or version 2012 or higher) open a web browser and download the installer file by clicking on this download link.
2. Click on and run the installer file to install it on the computer. The Windows user you are logged in as must have permissions to install programs.
3. Once the installer has successfully completed, open up the web browser from step 1 and enter the URL http://localhost:8092/ui/login to access the addon connector's login page.
4. Type the default user name: user and password: changeit into the login form fields and press the enter key.
5. Within the Settings page modify the values of the settings under the Connector Addon Web Service Settings section, as described within the Application Settings section displayed below. It's highly recommended to change the User Name, Password and Data Requests Require Authentication settings so that no other people can easily login to the addon connector and modify its settings.
6. Click on the Save button to update the changes. If you change the Listen On Port Number or Host URL settings that the addon connector's web service runs on then you will need to change the URL from step 3 with the changed port number and website domain. If you change the User Name and Password settings then you wil need to repeat step 3 to login again with the updated credentials.
7. In the Settings page under the Jiwa Microsoft SQL Server Database 1 Settings section change each of the settings based on the Microsoft SQL Server that is hosting Jiwa's data. If you are unsure on these then contact Jiwa to determine how to obtain these settings for its system. If your organisation is running to separate instances of Jiwa's software then the Addon Connector can join the data from the separate instances. If this is required then under the Jiwa Database 2 Settings (optional) sections configure the settings for the 2nd Microsoft SQL Server database storing data of the second Jiwa system.
8. Click on the Save button to immediately have the the changes occur when the next time the addon connector's data exports are run.

SQUIZZ.com Connector Configuration Steps

1. Open up the SQUIZZ.com Connector application.
2. WIthin the Adaptors and Messages tab, either create or use an existing Generic adaptor to handle running data exports that allow the SQUIZZ.com Jiwa Addon Connector software to have its data exports run.
3. For the Generic adaptor click on the Settings button.
4. From the Data Source Type drop down select the Ecommerce Standards Documents web service data source type, type a name such as "Jiwa ERP System", and click on the Create Data Source button.
5. Within the Data Source Settings window set the Address/URL setting to localhost:8082/esd/
6. Click on the save button
7. Click on the Data Exports tab
8. In the Data Export drop down select the Customer Account Product Pricing data export
9. In the URL set the value data/price_customer_account_pricing
10. Click on the save button
11. Close the Generic Adaptor Settings window and for the adaptor the routines were created for click on the Exports/Routines button.
12. Under the Data Exports tab tab and select the Customer Account Product Pricing data export to call the addon connector to export the product pricing data for customer acocunts.
13. Click on the Run Once Off button.
14. If the data export is successfully run and are correctly configured within the addon-connector then data should be exported to the selected Ecommerce System. If they don't successfully run then check that the addon-connector is running, has been correctly configured, and that the data source and data export within the Connector application are correctly configured. Common errors include incorrect spelling in URLs, incorrect address to the computer that the addon connector is installed on, order anti-virus or firewall software is blocking the Connector from making requests to the addon connector.
15. It's recommended to set up the scheduling of these data exports from step 12 to run on a regular basis, such as daily or weekly. When scheduling data exports ensure that they run in the correct order and have enough time to finish before the next routine starts.

With the SQUIZZ.com Jiwa Addon Connector installed and configured, and a SQUIZZ.com Connector software configured to talk to the Jiwa Addon Connector, the configured Generic adaptor within the SQUIZZ.com Connector software can now run the data exports for the addon connector to communicate with the Jiwa system, to retrieve and export customer account product pricing data. The Connector's Generic adaptor can then be used to forward the exported data to the SQUIZZ.com or TOTECS platforms.

The following settings can be configured for the SQUIZZ.com Jiwa Addon Connector web service, controlling different aspects on how it runs, and how it communicates and retrieves data from the Jiwa API.