Menu
Download Free Trial
  1. API reference
  2. Welcome
    1. Component overview
    2. Quickstart
    3. System requirements
    4. Troubleshooting
    5. Installation troubleshooting
    6. Managing license keys
  3. Connecting to Data Source
    1. JSON
      1. Connecting to JSON
      2. Data types in JSON
    2. CSV
      1. Connecting to CSV
      2. Data types in CSV
    3. SQL database
      1. Connecting to SQL database
      2. Connecting to database with .NET
      3. Connecting to database with .NET Core
      4. Connecting to database with Java
      5. Connecting to database with PHP
    4. Microsoft Analysis Services
      1. Connecting to Microsoft Analysis Services
      2. Getting started with Accelerator
      3. Installing Accelerator as a Windows Service
      4. Configuring username/password protection
      5. Configuring secure HTTPS connection
      6. Troubleshooting
    5. Pentaho Mondrian
      1. Connecting to Pentaho Mondrian
      2. Getting started with Accelerator
      3. Configuring Mondrian roles
      4. Сonfiguring username/password protection
      5. Сonfiguring secure HTTPS connection
      6. Troubleshooting
    6. icCube
  4. Configuring report
    1. What is a report
    2. Data source
    3. Slice
    4. Options
    5. Number formatting
    6. Conditional formatting
    7. Set report to the component
    8. Get report from the component
    9. Date and time formatting
    10. Configuring global options
    11. Export and print
    12. Calculated values
    13. Custom sorting
  5. Integration with frameworks
    1. Available tutorials
    2. Integration with AngularJS
    3. Integration with Angular 2
    4. Integration with Angular 4
    5. Integration with React
    6. Integration with RequireJS
    7. Integration with TypeScript
    8. Integration with ASP.NET
    9. Integration with JSP
    10. Integration with PhoneGap
  6. Integration with charts
    1. Integration with Highcharts
    2. Integration with FusionCharts
    3. Integration with Google Charts
    4. Integration with any charting library
  7. Customizing
    1. Customizing toolbar
    2. Customizing appearance
    3. Localizing component
  8. Updating to the latest version
    1. Updating to the latest version
    2. Release notes
    3. Migration guide from 2.3 to 2.4
    4. Migration guide from 2.2 to 2.3
  9. Older Versions
    1. Documentation 2.3
    2. Documentation 2.2
    3. API reference - Flex
Table of contents

Installing Accelerator as a Windows Service

Overview

There is an option to install Flexmonster Accelerator as a Windows Service instead of using Console application. Main benefits of running Accelerator as a Windows Service are:

  • it’s running in the background and out of sight
  • it’s starting automatically on Windows startup
  • it’s harder for a user to inadvertently quit the application

Requirements

  • Flexmonster Pivot Component version 2.2 or higher
  • Microsoft Analysis Services installed and configured
  • Microsoft .NET Framework 4 or higher

Step 1: Configure Data Speed Accelerator on the server

Start installation using server/installer/Flexmonster Accelerator.msi setup file and follow the wizard. After successful installation you can run Flexmonster Accelerator Manager:fm-accelerator-manager

First of all, let’s review Config file. It contains following parameters:

  • CONNECTION_STRING – connection string for Microsoft Analysis Services. Example: Data Source=localhost;. Required.
  • PORT – port number for the proxy service endpoint. Optional. Default is 50005.
  • CACHE_MEMORY_LIMIT – size of maximum RAM memory available for cache (in MB). Optional. Default is 0 (unlimited).
  • CACHE_ENABLED – indicates whether the cache is enabled. Optional. Default is true. Available since version 2.211.

You can check the Accelerator is up and running by navigating to its URL in the browser (i.e. http://localhost:50005).

After configuration you can close Flexmonster Accelerator Manager – service will continue working in the background.

Step 2: Open a port for Data Speed Accelerator in the firewall

If it’s planned to allow connection to Data Speed Accelerator from outside of the server, you should open an appropriate port in the firewall. Default port number is 50005, but it may vary depending on PORT parameter in flexmonster.config file.

Step 3: Configure Flexmonster Pivot Component

Now it’s time to configure the client – Flexmonster Pivot Component. Let’s create a minimal configuration using JavaScript API (replace proxyUrl, catalog and cube parameters with your specific values):

var pivot = new Flexmonster({
	container: "pivotContainer",
	toolbar: true, 
	report: {
		dataSource: {
			dataSourceType: "microsoft analysis services",

			/* URL to the Data Speed Accelerator */
			proxyUrl: "http://localhost:50005",

			/* Catalog name */
			catalog: "Adventure Works DW Standard Edition",

			/* Cube name */
			cube: "Adventure Works",

			// Flag to use Data Speed Accelerator instead of XMLA protocol
			binary: true
		}
	},
	licenseKey: "XXXX-XXXX-XXXX-XXXX-XXXX"
});