Integration Customization Tool

Overview

This installation guide will detail the steps to install the Solver Integration Customization tool for Solver Private Host and Cloud. The Integration Customization tool enables customer using Live Reporting off their ERP to expand the “out of the box” integration package provided by the Solver application to support customization done to their ERP.

This feature is compatible with Solver Cloud (in conjunction with use of the Hybrid agent) and Private Host customers who have version 5.2.30319+ installed.

System Requirements and Licensing

System Requirements

In order to install the Solver Integration Customization tool, the following is required.

Feature Requirement
Operating System Windows Server 2016+ OR Windows 10+

  • 64 bit recommended
Ram Min 8gb
Processor Intel or AMD; 32bit or 64 bit.

  • 64 bit recommended
Other Software .net Framework 4.7+

Microsoft SQL Express LocalDb (installed by installer if not installed)

  • Reboot may be required
Internet Access Access to the IP address: 13.69.228.4

  • this address is not pingable

Licensing

There is no license key needed for integration customization. Users are able to install and immediately use the Solver Integration Customization tool.

 

IMPORTANT: Integration Customization tool is considered an administrative tool and inherits database access based off the credentials defined in the connection string.

Before You Begin

Terminology

The Integration Customization Tool creates an “extension”. An Extension is a .xml file that is then uploaded to the Solver Application.

Installation Notes

Integration Customization Tool is installed as a user software, meaning that it is available to only the logged in user who has installed the software. Additionally, it can only be uninstalled by the user that has installed the software.

Best practices for installing the software included:

  1. Use a service account to install the software.
  2. Document that server AND the username that the Installation Customization Tool was performed by.

Software Usage

The Solver application supports only one customization file. Users must keep track and build on the original, exported integration customization file. Importing a new/different integration file will result in previous customizations being lost.

Best practices include:

  1. As previously mentioned, it is recommended to use a service account to install and use the Integration customization Tool.
  2. Store the exported customization to a network location that can be easily accessed by any who might need to load this file to the Solver application, including the service account who will be maintaining this customization.

Installation

Before starting this installation, below are key architecture notes of this install:

  1. The Customization Tool is a separate program within Solver application and should not be generally installed.
  2. It can be used for both Private Host and Cloud customers who are using the hybrid agent. It cannot be used for any Data Warehouse customization.
  3. It can be installed on a system that does not have Solver Reporting Installed. It is also recommended not to install this with a Terminal Server environment.
  4. This install will add SQL Server 2017 Local Db software and require a Reboot of the system.

To install the Solver Integration Customization tool:

The download can be found within the Solver Private Host zip file that was download or within the Help menu within Solver Cloud.

  1. Make sure you are log in as the user that is going to use the Customization Tool.
  2. Copy the executable to the desktop of the computer that the Customization Tool will be installed on.
  3. Right-click on the executable and choose Run as administrator. Please follow any User Account Controls (UAC) popups that appear on the screen. The installer will open.
  4. Next the program will install a Microsoft SQL Server 2017 LocalDB. This is needed to create a small SQL database to store relevant application information.
  5. The database is created in this file location:

    C:\Users\<UserName>\AppData\Roaming\Integration Customization\

  6. Click Next to install. The EULA will appear.
  7. Accept the Terms and click next. Click on Finish to complete the install.
  8. The system will ask for a reboot to complete the installation.
  9. That will complete the installation.

Configuration

Once the installation is done you have to setup the packages for which ERP that you have.

  1. Open Integration Customization (Start > Integration Customization)
  2. This will bring up the Log on screen. Type in the password “admin”, all lower case and with no quotes. Note you can change the password in the Settings.
  3. Click on Integration Packages.
  4. Select the integration package that corresponds to your ERP.
  5. Go and select “Install Selected
  6. The integration package will now appear in the Installed Packages list.
  7. Click Home > Data Connections

  8. Users will see the Package that was installed. Select New and enter the requested information.
    • Server: type in the name of the SQL server where the ERP database(s) are located. This can be either the hostname or the IP address.
      • If the ERP database is located on an instance of SQL, append \instanceName to the end of the server
      • If the SQL server is using a non-standard port, append :portNumber after the server name. Take note of the colon that is needed.
    • User: if left blank, the connection to the database will user Windows Authentication. Any User name that is typed into this text box must be a SQL user
    • Password: leave blank if the User box has been left blank. Type in the password of the SQL user if applicable.
    • Database: type in the database name.
      • GP: type in the name of the Dynamics database
      • SL: type in the name of the SLSystem database
      • Sap Business One: type in the name of the SBO-Common database
      • All other ERPs: type in the name of company database.

  1. Test the connection to see if it works. Click Ok and your connection is ready.

At this point you have now successful configured the Integration Customization tool. Navigating back to home, click on Integration Customization to begin extending the Solver Integration to support your customizations as well. 

Integration Customization

This section will give a high-level overview of the actions available in the Integration Customization menu. Upon clicking Integration Customization, the integration package will load. Depending on the amount of data and the number of extensions that have been configured on the ERP database, it may take 5-10 seconds to load.

  1. System Integration: Displays the ERP integration that has been loaded.
  2. Data Connection: Displays the name of the Data Connection that was configured by the user, as detailed in the Configuration section above.
  3. Company: displays a list of companies that exist on the database as defined in the connection string as detailed in the Configuration section above.
  4. Add/Edit Module: Use this menu to edit existing modules and add new modules as desired. A module is a menu item that appears on the left-hand side of the Report Designer pane in Excel. Modules group factsets together. The simplest example here is one might create a “General Ledger” module that includes both General Ledger Summary and General Ledger Detail factsets.
  5. Add/Edit Dimensions: Use this menu to edit existing dimensions or add new dimensions relevant to the data in your system. A dimension is used to describe the data.
  6. Add/Edit factset: use this menu to edit existing factsets or add new factsets. A factset is a set of transactional or operational data stored in the ERP
  7. Add/Edit Enumeration Dimensions: use this menu to edit existing dynamically generated dimension or configure your own enumerated dimension. An enumerated dimension is a dimension that does not have a physical table on the database.
  8. Save Integration Customization: use this menu to save and export the customization to the desktop for import into the Solver Product.

Uploading the Customization File

Only tenant administrators can upload a customization file, referred to as an Extension. Customizations are tenant specific and must be applied to each tenant. To upload a customization:

  1. Log into your Solver application
  2. Click on Settings > Administration
  3. On the Overview tab, a list of installed Integrations and Extensions will appear.
  4. Click Add to import the extension file.
  5. In the popup that appears, find the extension file (.xml) and upload it to Cloud.
    • For Cloud customers, please note that it may take up to 1hr for the change to take effect
    • Private Host users can wait 1hr for the change to take place or can restart the report rendering service to apply the change quicker.