== WvdS Data-Gateway ==

====== Overview ======

The **WvdS WebAPI Data Gateway** is a universal REST API interface for accessing relational databases.

===== What does the Gateway do? =====

  * Exposes databases as [[.:entwickler:rest:start|REST API]]
  * Supports [[.:entwickler:odata:start|OData]], [[.:entwickler:graphql:start|GraphQL]] and JSON
  * Enables access from [[.:anwender:excel:start|Excel]], [[.:anwender:access:start|Access]], [[.:anwender:powerbi:start|Power BI]], [[.:anwender:vba:start|VBA]] and all programming languages

===== Supported Databases =====

| SQL Server | SQLite | MySQL | PostgreSQL |

===== API Styles =====

^ Style ^ Use Case ^
| [[.:entwickler:odata:start|OData]] | Excel, Power BI, Access |
| [[.:entwickler:graphql:start|GraphQL]] | Modern Web Apps |
| [[.:entwickler:rest:start|REST/JSON]] | Universal |

===== Security =====

The Gateway supports [[.:business:sicherheit:start|Post-Quantum Cryptography]] for future-proof encryption.

====== Quick Start ======

First steps with the Data Gateway.

===== Start Server =====

<code bash>
WvdS.WebAPI.Data.Gateway.Api.exe
</code>

The server runs by default on ''http://localhost:5000''.

===== First Query =====

<code bash>
# Get table list
curl http://localhost:5000/api/v1/dsn/demo/tables
</code>

===== Read Data =====

<code bash>
# First 10 customers
curl "http://localhost:5000/odata/demo/Customers?\$top=10"
</code>

===== Next Steps =====

  * [[.:administrator:start|Installation & Configuration]]
  * [[.:entwickler:start|API Documentation]]
  * [[.:anwender:start|Excel & Access Integration]]
  * [[.:operator:start|Operator Handbook]] - Runbooks for Operations

----

===== Operator Handbook =====

<WRAP round tip>
**For Sysadmins & DevOps:** -> [[.:operator:start|Operator Handbook]] \\
Runbooks, checklists, copy-paste commands for daily operations.
</WRAP>

^  Category  ^  Description  ^  Runbooks  ^
| [[.:operator:tagesgeschaeft:start|Daily Operations]] | Start server, manage DSN, Health Check, Logs | 4 |
| [[.:operator:automatisierung:start|Automation]] | Windows Service, systemd, Docker, Kubernetes | 4 |
| [[.:operator:monitoring:start|Monitoring]] | Prometheus, Grafana, Alerting | 3 |
| [[.:operator:sicherheit:start|Security]] | TLS, Certificates, Firewall | 3 |
| [[.:operator:backup:start|Backup]] | Config Backup, DSN Export | 2 |

----
//Wolfgang van der Stille @ EMSR DATA d.o.o. - Data Gateway Professional//

{{tag>data-gateway overview api rest odata graphql}}