Cloud
Cloud-Dienstleistung für schnelle und effektive Analyse und Visualisierung von Daten für Ihr Business ohne eigene Applikationen zu erstellen oder zu programmieren.
Using SQL Data Sources
Unsere Beispiele der Projekte und Berichtsvorlagen helfen Ihnen, die Grundlagen der Arbeit mit unserer Software zu erlernen.A dashboard bound to a SQL data source can have its connection string and query rewritten from code in the
In React.
How it works. The event intercepts each data request, so connections and queries stay under server-side control.
onBeginProcessData event.In React.
import { Viewer, Stimulsoft } from "stimulsoft-dashboards-js-react/viewer";
function App() {
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";
};
return <Viewer report={report} />;
}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.