SetConnect

XMLimport

Database::XMLimport
Description

Import data from an XML file into a database. The result is one or more tables which contain all data from the XML file. The relation between the tables can be saved to a textfile. "Id" columns inside the tables represents the relation between the tables.
Optionally you can import the structure of the XML file which will result in a list of tables as they will be imported. In this list you can select which tables you want to import.

Options
Xml file
The source Xml file .
Mode

Configures the XmlReadMode.

Auto
This is the default. Examines the XML and chooses the most appropriate option.
DiffGram
Reads a DiffGram and adds the data to the current schema. DiffGram merges new rows with existing rows where the unique identifier values match.
Fragment
Continues reading multiple XML fragments until the end of the stream is reached.
InferSchema
Ignores any inline schema and infers the schema per the structure of the XML data, then loads the data.
Select tables to import
Only the selected tables will be imported, unless the list is completely empty.
Destination handle
The name of the handle (opened database) to which the data will be imported. Tables are automatically dropped/created.
Datatype for string values
The datatype that must be used in the "CREATE TABLE" statement to create the columns that will contain the data.
Table name prefix
Prefix which is automatically added to all table names.
Column name prefix
Prefix which is automatically added to all column names.
Save relations to file
When checked, the relations info of the tables is saved to the configured file.

Documentation

Release notes