Using a Custom Data Adapter.ts

import { Component } from "@angular/core";
import { Designer, Stimulsoft } from "stimulsoft-dashboards-js-angular/designer";

@Component({
    selector: "using-custom-dataadapter",
    imports: [Designer],
    template: `<sti-designer [(report)]="report"  [options]="designerOptions"></sti-designer>`
})

export class UsingCustomDataAdapter {
    report: Stimulsoft.Report.StiReport;
    designerOptions: Stimulsoft.Designer.StiDesignerOptions;

    constructor() {
        Stimulsoft.Report.Dictionary.StiCustomDatabase.registerCustomDatabase({
            serviceName: "MyDatabase",
            sampleConnectionString: "123",
            designerCategory: "",
            process: function (command, callback) {
                if (command.command === "TestConnection") callback({ success: false, notice: "Error" });
                if (command.command === "RetrieveSchema") callback({ success: true, data: demoData, types: demoDataTypes });
                if (command.command === "RetrieveData") callback({ success: true, data: demoData[command.queryString], types: demoDataTypes[command.queryString] });
            }
            // data is only needed to specify the column types; it is enough to pass only the first line
            // if there is no data, then types are taken from types
            // and vice versa, if there are no types, the types are taken from data
        });

        this.report = new Stimulsoft.Report.StiReport();
        this.report.loadFile("Dashboards/CustomAdapter.mrt");

        this.designerOptions = new Stimulsoft.Designer.StiDesignerOptions();
        this.designerOptions.appearance.fullScreenMode = true;

        var demoData: any = {
            Table1: [{
                Column1: "value1",
                Column2: 1,
                Column3: Stimulsoft.System.Guid.newGuidString()
            }, {
                Column1: "value2",
                Column2: 2,
                Column3: Stimulsoft.System.Guid.newGuidString()
            }, {
                Column1: "value3",
                Column2: 3
            }
            ],
            Table2: [{
                Column1: "value1",
                Column2: 1
            }, {
                Column1: "value2",
                Column2: 2
            }, {
                Column1: "value3",
                Column2: 3
            }
            ]
        };

        var demoDataTypes: any = {
            Table1: {
                Column1: "string",
                Column2: "number",
                Column3: "Stimulsoft.System.Guid"
            },
            Table2: {
                Column1: "string",
                Column2: "Stimulsoft.System.Int32"
            }
        }
    }
}