This article describes the principal changes of Generic Templates.
The Template download section can be found at this page
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.
INTEGRATION Rdbms and INTEGRATION Hsql
Recycling of previous rejects fixed
When using the option to recycle the rejects of previous execution an extra step is executed to add those previous rejects in the integration flow.
Possible duplicates while retrieving those rejects are now filtered using DISTINCT keyword.
Unload Rdbms to File
Template has been updated to use automatically technology specific syntax when generating empty NULL columns.
This has been modified to address issues with technologies which requires a different syntax than using "NULL" keyword, such as IBM Informix database which requires the column to be dynamically datatyped using "NULL:integer" for instance.
Stambia DI Designer S19.0.15 or higher is required for the Template to use technology specific syntax for this case.
When using prior Designer versions, or a technology on which the syntax has not been defined, this will continue to work as before, by using the 'NULL' keyword
TOOL Ldap Integrator
Operation failure management
Each row of source file is now processed even if an issue occurs while executing one of the iterations.
Previously, as soon as one of the operations was failing, the tool stopped executing and returned the error, avoiding all other iterations to be processed.
From now, all rows will be processed and when an iteration fails it will simply log information about it if required and process the next one.
New parameter for exporting encountered errors in file
A new parameter called 'Export Errors' has been added.
When enabled encountered errors will be traced in a log file.
New variables are now published by tool, allowing to consult easily the result of operations: how many succeeded and how many failed.
They are all listed in the tool's description.
Allow having multiple instance of the tool in same process
All scripting actions contained in the tool have been updated to have a dynamically generated scripting connection.
This allows using multiple times the tools in the same process and also in parallel.
The Replicator now supports specific loaders for SybaseIQ and Snowflake for data loading.
They will now be used by default for these technologies instead of the generic mode.
If required, generic mode can still be used by enabling 'Force Generic Rdbms Mode'.
A new parameter named 'Split By Pattern' has been added to offer the possibility to customize the xpath expression used to find the column which is used to split source data into multiple subsets when using the split by mechanism.
As a reminder this mechanism can be used to replicate source table data into target with multiple parallel tasks.
Each task contains a number of rows calculated from the numeric column which is used to split data.
INTEGRATION Rdbms to Rdbms (no load)
The 'INTEGRATION Rdbms to Rdbms (no load)', which has the specificity to integrates source data directly in the target without creating any temporary work table, is now available in more situations.
It was previously displayed in Mappings when integrating data on Excel and Google Spreadsheet as they are technologies which requires not using temporary objects and has now been expended to more cases.
It will now be available when integrating data in a target database as soon as the source is also a database, offering the possibility to perform direct integration in more situations.
Note that this applies only for technologies working through JDBC like databases, or files (which uses or own JDBC driver).
- Generated queries for Primary Keys and Alternate Keys were incorrect for composite keys
TOOL Ldap Extractor (search)
- Fix undefined variable error which is thrown when using the tool