Using SQL Data Sources
Our sample projects and report templates can help you learn the basics of working with our products.A dashboard bound to a SQL data source can have its connection string and query rewritten from code in the
In Vue.
How it works. The event intercepts each data request, so connections and queries stay under server-side control.
onBeginProcessData event.In Vue.
<script setup lang="ts">
import { Viewer, Stimulsoft } from 'stimulsoft-dashboards-js-vuejs/viewer'
Stimulsoft.StiOptions.WebServer.url = "http://localhost:9615/";
var report = new Stimulsoft.Report.StiReport();
report.loadFile("Dashboards/SalesOfProducts.mrt");
report.onBeginProcessData = function (args) {
// Replace connection parameters or the SQL query before the request
if (args.connection === "MySQL")
args.connectionString = "Server=localhost; Database=northwind; UserId=root; Pwd=;";
if (args.dataSource === "products")
args.queryString = "SELECT * FROM MyTable";
};
</script>
<template>
<Viewer :report="report" />
</template>StiOptions.WebServer.url— the Node.js SQL adapter the engine sends data commands to.args.connectionString/args.queryString— swap the connection or SQL per data source before the request.
How it works. The event intercepts each data request, so connections and queries stay under server-side control.