Database Export

hale»studio writes to databases using JDBC. hale»studio offers support for PostgreSQL and PostGIS databases out of the box, support for other databases can be added through plug-ins.

The database export in this version of hale»studio is deemed experimental. This means it does not have the full functionality we want to provide for a database export feature. However, within its limits it is functional and may be useful to you.

The database export currently has the following known limitations:

• The database schema must already exist. It should be loaded as target schema from the database. The export based on other types of schemas will fail due to missing information on SQL types.
• IDs (primary keys) generated in the database during insertion are not available to be used to create references between different tables. To be able to link tables, IDs and references must be provided as part of the mapping/transformation. For auto-generated numerical columns (auto-increment) referenced in foreign keys, the identifier assigned during transformation will be replaced by the auto-generated value.

When storing geometries in PostGIS, hale»studio will try to detect the spatial reference system associated to the target column and transform them appropriately.

To store data in the database, you need to provide the database driver and specify the database host and name:

Next you will be prompted for a user and password to use for connecting with the database.

What is an Instance?

Save the transformation result

Database Import