Welcome Guest! Log in
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Stambia Data Integration allows to work with SAP Hana 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 SAP Hana JDBC driver (ngdbc.jar) must be installed in the Designer and Runtime
  • Designer S18.3.0 or higher

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 SAP Hana in Stambia DI

Name Description Download
Generic Templates Package containing the generic Templates download

previous releases

SAP Hana Templates

The SAP Hana 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.

 download

previous releases

Demonstration Project A project that demonstrates most of the features through examples of Mappings and Processes download

 

To learn how to install and use SAP Hana with 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 SAP Hana databases

Standard features

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
  • Append
  • Incremental Update
Staging

The databases can be used as a staging area to make data transformation, mutualization, ...

The following modes are supported:

  • staging as subquery
  • staging as view
  • staging as table
Reject

Reject rules can be defined to filter or detect data that does not fulfill the rules during integrations.

  • Three type of rules can be created: Fatal, Warning, Reject
  • Depending on the specified type, the rejected data will not be handle the same way
  • Rejects of previous executions can also be recycled
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 can be performed using Slowly Changing Dimension (SCD)
Load methods
  • Generic JDBC load
  • Load through the IMPORT FROM SAP Hana statement
  • Load through Remote Sources

 

 

You have no rights to post comments

Articles

Suggest a new Article!