XML database

This section contains information on the configuration and the data type mapping of XML files as databases. The database structure, tables and columns are defined in an XSD file. The XML file, the XSD file and an XSL file containing style information are created with the TwinCAT Database Server configurator (Create command). Based on the XSL file the XML file can be opened in a web browser, where a graphical enhance view of the database or the table is presented.

Further information on working with XML files as databases can be found in section "XML - information".

Declaration in the TwinCAT Database Server Configurator

XML database

Database Type

Select "XML" from the drop-down menu.

XML Database File

Enter the name and path of the XML file.

XML Schema File

Enter the name and path of the XSD file.

Database

Enter the name of the database. If the database does not yet exist, it can be created with the Create button. Corresponding permissions must exist. In the case of XML databases, the XML, XSD and XSL files are created automatically.

XML database 1:

Windows CE support

This database is also supported by the Windows CE version of the TwinCAT Database Server. The connection can be established locally.

Data type mapping between DB and PLC

E_ColumnTypes

XML

TwinCAT PLC

BigInt

bigint

T_ULARGE_INTEGER (TcUtilities.lib)

Integer

integer

DINT

SmallInt

smallint

INT

TinyInt

tinyint

BYTE

Bit_

bit

BOOL

Money

money

LREAL

Float

float

LREAL

Real_

real

LREAL

DateTime

datetime

DT

NText

ntext

STRING

NChar

nchar

STRING

Image

image

ARRAY OF BYTE

NVarChar

nvarchar

STRING

Binary

binary

ARRAY OF BYTE

VarBinary

varbinary

ARRAY OF BYTE

XML database 2:

Data type support

WSTRING is not supported by this database. (See WString support)

Notice

Data security

In flash memory devices the number of write access operations is limited. The flash memory devices can fail, with a risk of data loss.

  • Make regular backups of your system. Use the IPC diagnostics in order to determine the status of the flash memory devices.