SeekTable's "Web API" connector allows you to create your own data sources or customize an access to your SQL database in a special way (say, to implement very specific calculations).
For this purpose you can develop your own custom connector in the form of web API endpoint that can handle data queries from SeekTable's reporting engine (PivotData Microservice); requirements are described below.
Custom connector web API provides an interface to query a tabular data model: incoming HTTP request contain a query (JSON) that determines a list of data columns to return. There are 2 kind of columns that may be requested:
If query contains at least one "Aggregate" column all "Field"-type columns should be handled as a grouping criteria.
Custom connectors may be used only on SeekTable installations. To enable "Custom conector" data source option add this line to
After docker containers restart you should be able to configure your custom connector on the cube configuration form ("Connect to database"):