How to use the Data Gateway in your Office applications.

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 base URL for your data source:

http://server:5000/odata/demo

Replace:

• server with the server name
• demo with your database name

• Excel - Import and refresh data
• Access - Linked tables
• Power BI - Dashboards and reports
• VBA - Programming and automation