====== Introduction for Users ======

How to use the Data Gateway in your Office applications.

===== What is OData? =====

OData is a standard that Microsoft Office natively supports. You can use it to load data from the Gateway directly into Excel, Access, or Power BI.

===== The OData URL =====

The base URL for your data source:

<code>
http://server:5000/odata/demo
</code>

Replace:
  * ''server'' with the server name
  * ''demo'' with your database name

===== Available Tools =====

  * [[.:anwender:excel:start|Excel]] - Import and refresh data
  * [[.:anwender:access:start|Access]] - Linked tables
  * [[.:anwender:powerbi:start|Power BI]] - Dashboards and reports
  * [[.:anwender:vba:start|VBA]] - Programming and automation