Welcome Guest! Log in


Stambia Data Integration allows to work with IBM Netezza Data Warehouses 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 IBM Netezza 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 bellow the necessary material to work with Netezza in Stambia DI

Name Description Download
Generic Templates Package containing the generic Templates download
Netezza Templates

The Netezza 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

 

Supported features

You can find bellow an overview of what Stambia DI can do with Netezza

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.

 

Comments  

# Virginie_Samson 2017-07-27 15:42
Hello
Where can we found all tag keyword that can be used in mapping please?
Thanks
# Cyril Dussud 2017-07-28 12:50
Hi,

You can find in Templates' documentation the information about the tags that can be used with it.

The documentation of the Templates present in the current workspace can be found in the Help Contents of the Designer (since Designer S18.2.0), or in the description of each parameter for instance.

Do not hesitate to contact the support team if you find a Template that is not documented yet :-)
# Virginie_Samson 2017-07-28 14:08
Oh S**T... we are in 18.0.3...
I must migrate our system ... :cry:
# Cyril Dussud 2017-07-31 11:02
The documentation is written directly in the Templates. The higher versions just simplify and extract the documentation to have it in the Help Content.

On previous versions you can still find the documentation directly in the Template description.

Simply open the Template Process and look at the Description in the Properties window.
You should have everything here :-)

You have no rights to post comments

Articles

Suggest a new Article!