Data source

The data source is a required part of the ReportObject. Flexmonster supports data from OLAP data sources, SQL databases, CSV and JSON static files, and inline JSON data. Each data source requires specific properties to be set inside the dataSource section of the ReportObject. To see examples of connecting to different data sources, visit the Examples page.

Read more in the following sections:

• JSON data sources
• CSV data sources
• SQL databases
• MongoDB databases
• The custom data source API
• Microsoft Analysis Services
• Elasticsearch
• Change the data source using the Toolbar
• Data source via API

JSON data sources

JSON data source can be:

• Files from the local file system.
• A remote static file.
• Data generated by a server-side script.
• Inline JSON.

Here is a list of dataSource properties used to connect to JSON data sources:

{
  "creationDate": "01-01-2022", 
  "userData" : {
    "flexmonsterData": [
      // your data
    ],
  },
}

Here is an example of JSON dataset using a file from the local file system:

report: {
    dataSource: {
        /* Path to the local JSON file */
        filename: "data.json"
    }
}

If the data is generated by a server-side script, type must be defined explicitly:

report: {
    dataSource: {
        type: "json",
        filename: "script_which_returns_json_data"
    }
}

Inline JSON:

report: {
    dataSource: {
        /* jsonData variable contains JSON data */
        data: jsonData
    }
}

CSV data sources

CSV data source can be:

• A file from the local file system.
• A remote static file.
• Data generated by a server-side script.

Here is a list of dataSource properties used to connect to CSV data sources:

sep=|
Country|Color|Price
Canada|blue|1000

In the following example data is taken from a CSV file where the colon character (:) is used to separate fields within the row. Line breaks in quotes are not ignored:

report: {
    dataSource: {
        /* URL or local path to a CSV file */
        filename: 'colon-data.csv',
        fieldSeparator: ':',
        ignoreQuotedLineBreaks: false
    }
}

If the data is generated by a server-side script, type must be defined explicitly:

report: {
    dataSource: {
        type: "csv",
        filename: "script_which_returns_csv_data"
    }
}

SQL databases

Here is a list of dataSource properties used to connect to SQL databases using the custom data source API:

Here is an example of how a connection to a relational database is represented in a dataSource object:

report: {
    dataSource: {
        type: "api",
        url: "https://olap.flexmonster.com:9202/api/cube",
        index: "fm-product-sales"
    }
} 

Read more about connecting to SQL databases with the custom data source API here.

MongoDB databases

Here is a list of dataSource properties used to connect to a MongoDB database:

Here is an example of how a connection to a MongoDB database is represented in a dataSource object:

report: {
    dataSource: {
        type: "api",
        url: "http://localhost:9204/mongo",
        index: "fm-product-sales"
    }
}

The custom data source API

Here is a list of dataSource properties used to connect to the custom data source API:

Here is an example of how a connection to the custom data source API is represented in a dataSource object:

report: {
    dataSource: {
        type: "api",
        url: "https://olap.flexmonster.com:9202/api/cube",
        index: "fm-product-sales"
    }
}

Check it out on JSFiddle.

Microsoft Analysis Services

There are two ways to connect to Microsoft Analysis Services using Flexmonster Pivot:

1. Via the XMLA protocol – an industry standard for data access in analytical systems. Works for multidimensional models only.
2. Via Flexmonster Accelerator – a special server-side utility developed by Flexmonster. Works for both multidimensional and tabular models.

Here is a list of dataSource properties used to connect to Microsoft Analysis Services:

Here is an example of how the connection to SSAS via XMLA is represented in dataSource:

report: {
    dataSource: {
        type: "microsoft analysis services",
        // URL to msmdpump.dll 
        proxyUrl: "https://olap.flexmonster.com/olap/msmdpump.dll",
        catalog: "Adventure Works DW Standard Edition",
        cube: "Adventure Works",
        // Microsoft Locale ID Value for French 
        localeIdentifier: 1036, 
        // roles from SSAS 
        roles: "admin,manager",
        subquery: "select {
                [Delivery Date].[Calendar].[Calendar Year].&[2008]
                } on columns from [Adventure Works]"
    }
}

Check it out on JSFiddle.

Here is an example of how the connection to SSAS via Flexmonster Accelerator is represented in dataSource:

report: {
    dataSource: {
        type: "microsoft analysis services",
        proxyUrl: "http://localhost:50005",
        catalog: "Adventure Works DW Standard Edition",
        cube: "Adventure Works",
        binary: true,         
        // Microsoft Locale ID Value for French 
        localeIdentifier: 1036,
        subquery: "select {
                [Delivery Date].[Calendar].[Calendar Year].&[2008]
                } on columns from [Adventure Works]" 
    }
}

You can read all the details about the Accelerator here.

Elasticsearch

Here is a list of dataSource properties used to connect to Elasticsearch:

Here is an example of how a connection to Elasticsearch is represented in a dataSource object:

report: {
    dataSource: {
        type: "elasticsearch",
        node: "https://olap.flexmonster.com:9200",
        index: "fm-product-sales"
    }
}

Try the example on JSFiddle.

Change the data source using the Toolbar

Use the Connect option to choose another data source or Open to load another report at runtime. Use Save to save the report with the current data source.

Data in the pivot table will be updated and saved within the report.

Data source via API

The API calls connectTo(), load(), and open() are used to change the data source at runtime. The API call save() is used to save the report.