WKL Database Gateway: overview
Beta: The data service is published as a beta version. Features, configuration, and interfaces can change before the first released version.
The WKL Database Gateway data service (technical name Wkl.Data.Gateway) is the only way for users
and programs to reach your SQL Server databases. It
accepts requests over HTTP, checks sign-in and permissions, builds the SQL statement, and returns the
result. Together with the OData ODBC driver, the .NET client, and the administration app, it makes up
Database Gateway.
Where to start
| If you want to … | Go to |
|---|---|
| find out what the service does and whether you need it | What is the data service? |
| check what you need before you start | Prerequisites |
| set everything up from scratch | Set-up guide: from an empty server to data in Access, Excel, and Power BI |
| install the service | Install the data service |
| read your first data in ten minutes | Your first request over HTTP |
| grant and manage access | “Administrator guide for WKL Database Gateway Manager” |
| connect your own program | HTTP: native API, OData v4, “WklGatewayClient: VBA class for the data service” (documentation of the administration app) |
| evaluate whether the service fits your use case | Background, use cases, and alternatives, Security model and trust boundaries of the data service |
| fix a problem | Troubleshooting, “Troubleshooting” (in the “Administrator guide for WKL Database Gateway Manager”) |
How the documentation is organized
| Section | Contents |
|---|---|
| Getting started | what the service is, prerequisites, components, and first results |
| How-to guides | individual setup and operations tasks |
| Concepts | how the service works: aliases, permissions, sign-in, writing, names |
| Reference | native HTTP API, OData, administration API, configuration, commands, VBA class |
| Troubleshooting | symptoms with causes and fixes |
| Operations | installation, first administrator, backup, master key, emergency access |
| “Administrator guide for WKL Database Gateway Manager” | working with the administration app, task by task |
For changes by version, see Changes.
Manufacturer
EMSR DATA, D.O.O., Trg komandanta Staneta 8, 1000 Ljubljana, Slovenia
Email: Wolfgang.van.der.Stille@gmail.com, zp@datecpro.de
Website: https://wvds.it
“The White Knight Labs” and “WKL” are trademarks of EMSR DATA, D.O.O. How to report a
vulnerability and which versions are supported until when is described in SECURITY.md; the
manufacturer information with the end of support is in MANUFACTURER.md, and the third-party
components shipped with the product and their licenses are listed in THIRD-PARTY-NOTICES.txt,
and the license terms of EMSR DATA are in LICENSE.md. The files are in the program folder,
LICENSE, SECURITY, and MANUFACTURER also in German and Slovenian (for LICENSE, the English
version is binding);
see Installation package.