Connecting to a new data source at runtime

Data source

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<div>
  <h2>How to connect to a new data source at runtime</h2>
  <p>
    Connecting to a new data source at runtime is possible with the
    <code>connectTo()</code> API call. It clears the report and connects
    Flexmonster to the specified data source.
  </p>
  <p>
    <a href="https://www.flexmonster.com/api/connectto/" target="_blank"
    >Learn more about connectTo() in our documentation</a>.
  </p>
</div>

<button onclick="connectJSON()">Connect to JSON</button>
<button onclick="connectCSV()">Connect to CSV</button>
<button onclick="connectSSAS()">Connect to SSAS</button>
<button onclick="connectFDS()">Connect to Flexmonster Data Server</button>
<button onclick="connectElasticsearch()">Connect to Elasticsearch</button>

<div id="pivot-container"></div>

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  report: {
  	dataSource: {
      type: "csv",
      filename: "data/happiness.csv",
    }
  }
});

function connectJSON() {
  pivot.connectTo({
    filename: "https://cdn.flexmonster.com/data/retail-data.json"
  });
}

function connectCSV() {
  pivot.connectTo({
    filename: "https://cdn.flexmonster.com/data/data.csv"
  });
}

function connectFDS() {
  pivot.connectTo({
    type: "api",
    url: "https://olap.flexmonster.com:9500",
    index: "fm-product-sales"
  });
}

function connectSSAS() {
  pivot.connectTo({
    type: "microsoft analysis services",
    proxyUrl: "https://olap.flexmonster.com/olap/msmdpump.dll",
    dataSourceInfo: "Provider=MSOLAP; Data Source=extranet;",
    catalog: "Adventure Works DW Standard Edition",
    cube: "Adventure Works"
  });
}

function connectElasticsearch() {
  pivot.connectTo({
    type: "elasticsearch",
    node: "https://olap.flexmonster.com:9200",
    index: "fm-product-sales"
  });
}