Exporting Data to a Database

INFO

Find here all information for exporting data to a database.

Database Overview

INFO

Relational databases include Oracle, DB2, and MySQL.

Datameer X does not support all dialects. Not listed databases that are compatible with a dialect can be requested at the support.

Datameer X supports the export to the following databases:

INFO

The database to which you want to export must be prepared according to Datameer X's individual needs. Please check with the respective vendor.

INFO

Make sure you have the respective database driver installed in the 'Admin' tab.

INFO

Make sure you have configured the respective Datameer X connection.

INFO

Custom properties can be set especially for export jobs or during the cluster configuration.

Custom properties for the export jobs are:

Custom Property	Default Value	Description
export.jdbc.field.%s.varchar-length	50	property can be set on the cluster settings page or within an export job configuration (when set in both settings, the settings on the cluster setting page are dismissed) '%' must be replaced by the field name respectively property defines the length of a varchar field
export.jdbc.dialect.%s.varchar-length	100000	property can be set on the cluster settings page or within an export job configuration (when set in both settings, the settings on the cluster setting page are dismissed) '%' must be replaced by the dialect name respectively property defines the varchar length within a varchar column
export.jdbc.varchar-length	112	property can be set on the cluster settings page or within an export job configuration (when set in both settings, the settings on the cluster setting page are dismissed) property defines the varchar length within jdbc export jobs