> For the complete documentation index, see [llms.txt](https://docs.videc.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.videc.de/june5-3.7/en/datenquellenunterstuetzung-und-einbindung/microsoft-ole-db.md).

# Microsoft OLE DB

An OLE DB data source enables you to retrieve data from other database systems that can be accessed via the Microsoft OLE DB interface.

The OLE DB connector distinguishes between *measurement variables, measurement values* and *events*.

## Measurement Variables and Measurement Values

Measurement variables and measurement values must be stored in tables in the same database. For these to be read by JUNE5, the tables containing the data must have a specific structure. The structure of the tables with measurement variables and measurement values is described in the subsection [SQL Table Measurement Variables](/june5-3.7/en/datenquellenunterstuetzung-und-einbindung/microsoft-ole-db/sql-tabelle-messgroessen.md) and [SQL Table Measurement Values](/june5-3.7/en/datenquellenunterstuetzung-und-einbindung/microsoft-ole-db/sql-tabelle-messwerte.md) respectively.

## Events

Events such as failures, messages or audit trails can be stored in various tables in the same database. A brief description of the SQL table with events can be found in the subsection [SQL Table Events](/june5-3.7/en/datenquellenunterstuetzung-und-einbindung/microsoft-ole-db/sql-tabelle-ereignisse.md).

When configuring an [OLE DB data source](/june5-3.7/en/webanwendung/datenquellen/datenquellen-konfigurieren.md), you must specify which SQL tables contain the data to be imported. This includes the tables with measurement variables, the tables with measurement values, as well as the tables with events.

Microsoft SQL Server does not need to be installed on the JUNE5 server. A SQL Server available on the network can be integrated. To test the connection settings, you can create a file on the desktop with the name "Test.udl" (UDL = Universal Data Link). Double-clicking this file opens the data link settings. Here you must see the provider "Microsoft OLE DB Provider for SQL Server". Further connection properties can then be configured and tested in the subsequent dialogs.

Supported is Microsoft SQL Server from version 2008 onwards.

A JUNE5 license (Professional or Enterprise) with the Data Source option (Order No. JUNE5-OPTN-DS-OLE) is required.

Additional licenses may be necessary for alarm and event analysis for OLE-DB databases (Order No. JUNE5-OPTN-AEO).

## Port Number of the SQL Server

{% hint style="info" %}
The firewall must be configured by IT so that the server is accessible on the network via remote access.

* By default, data traffic to a standard instance of a SQL Server is handled via port 1433.
* Data traffic to a named instance of a SQL Server is handled via dynamic ports.
  {% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.videc.de/june5-3.7/en/datenquellenunterstuetzung-und-einbindung/microsoft-ole-db.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.