HSQL
Supported Features
Common Features
Feature | Description |
---|---|
Reverse |
Metadata can be reverse engineered. |
DDL/DML Operations |
DML/DDL operations can be performed on the database, such as: Insert, Update, Select, Delete, Create or Drop. |
Integration Methods |
|
Load Methods |
|
Staging Methods |
This technology can be used as a staging to make data transformation, mutualization, and more. The following methods are supported:
|
Rejects |
Reject rules can be defined to filter or detect data that does not fulfill the rules during integrations. |
Replication |
Data can be replicated from or to this technology using Replicators. |
Slowly Changing Dimension (SCD) |
Slowly Changing Dimension (SCD) feature can be used optionnaly when integrating data in this technology. |
Change Data Capture (CDC) |
Change Data Capture (CDC), which allows to capture, follow and store all the changes during data integration, is supported. |
Sub-Metadata support
The HSQL component lets you create Sub-Metadata on HSQL schema and query folder Metadata nodes.
To learn more about Sub-Metadata, see Work with Sub-Metadata.