Stambia Data Integration allows to work with Vertica databases to produce fully customized Integration Processes.
The database structure can be entirely reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user's requirements.
Prerequisites:
- The Vertica JDBC driver must be installed in the Designer and Runtime
Note:
Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.
If you have any question, any feature request or any issue, do not hesitate to contact us.
This component may require a dedicated license.
Please contact the Stambia support team if you have any doubt and if you need to use it in a production environment.
Download
You can find below the necessary material to work with Vertica in Stambia DI
| Name | Description | More Information | Download |
| Generic Templates | Package containing the generic Templates | download | |
| Vertica Templates |
The Vertica specificities are handled in dedicated Templates that can be found in this package Some are using generic tools that are shipped with the generic templates, make sure to import them too. |
Release notes |
download
previous releases |
| Demonstration Project |
An archive containing a project which demonstrates most of the features through examples of Processes and Mappings. |
download
previous releases |
To learn how to install and use Vertica in Stambia DI, have a look at the following getting started article.
Supported features
You can find bellow an overview of what Stambia DI can do with Vertica databases
| Name | Description |
| Reverse |
The database structure can be reversed in a dedicated Metadata |
| DDL /DML Operations |
DML/DDL operations can be performed on the database, such as: Insert, Update, Select, Delete, Create or Drop |
| Integration methods |
|
| Staging |
The databases can be used as a staging area to make data transformation, mutualization, ... The following modes are supported:
|
| Reject |
Reject rules can be defined to filter or detect data that does not fulfill the rules during integrations.
|
| Replication |
Replication of databases is supported. The replication source can be any rdbms, Flat files or XML files. |
Advanced features
| Name | Description |
|
Slowly Changing Dimension Integrations |
Integrations can be performed using Slowly Changing Dimension (SCD) |
| Load methods |
|
| Analyze of tables | The work and/or target table can be analyzed to optimize data loading during integrations |
| Deletion Strategy |
The Integration Template has the ability to automatically delete rows from the target Vertica table before processing based on the source dataset. The rows to delete can be selected through different methods:
There is also the ability to simply delete all rows before processing. |