> 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/webanwendung/datenquellen/endpunkt-anlegen/siemens-wincc-ole-db.md).

# Siemens WinCC OLE DB

The following input fields (required fields) are described below:

### Name

In this input field, a symbolic name of the newly created endpoint is entered.

### Identification

A unique identification is entered here.

### Enabled

If the check box is set, the Siemens WinCC OLE DB endpoint is enabled. Otherwise the endpoint remains disabled.

### Windows Integrated Security

The check box is enabled if the username and password do not need to be explicitly entered for authentication. In this case, the Windows credentials of the user under whom the JUNE5 Web server service is running are used. This user must have sufficient rights to read data from the WinCC databases. Additionally, the user must be added to the Windows user group "SIMATIC HMI". If access is not local and the WinCC Server and JUNE5 Server are not in the same domain, users with identical credentials can be created on both computers to use Windows integrated security for this user.

### Provider Name

In this input field, the name of the WinCC OLE DB Provider must be specified, for example "WinCCOLEDBProvider".

### Instance Name

In this input field, a name is specified to uniquely identify the WinCC SQL Server instance. This name consists of the computer name, followed by a backslash and "WinCC".

If the client and server are running on the same PC, the computer name can be replaced with a period.

For example: .\WinCC, localhost\WinCC or \WinCC.

### Username

In this input field, the name of a WinCC user who has sufficient permissions to read the configured tags from the WinCC variable repository is entered. Database access is performed via the Microsoft OLE DB Provider for SQL Server with the provider name "MSOLEDBSQL".

### Password

The password for the user specified in the Username field is entered in this field.

{% hint style="info" %}

* Two OLE DB interfaces are used to import the WinCC data: the WinCC OLE DB Provider and the Microsoft OLE DB Provider. The WinCC OLE DB Provider is used to retrieve process value archives; the Microsoft OLE DB Provider is used to query the configuration of the WinCC archives.
* The credentials entered in the *Username* and *Password* input fields are only used in combination with the Microsoft OLE DB Provider. In contrast, the credentials of the current Windows user are always used in combination with the WinCC OLE DB Provider.
* Only users in the Windows user group "SIMATIC HMI" have access to the data of the WinCC archives.
* When saving or subsequently changing the setting, all required fields must be filled in.
* Required fields are those fields whose left border is marked in red.
  {% endhint %}

## Test Connection

Using the *Test Connection* button in the horizontal toolbar, the connection to the endpoint can be tested.


---

# 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/webanwendung/datenquellen/endpunkt-anlegen/siemens-wincc-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.