Welcome Guest! Log in

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.



Fix several issues for Oracle SQL*Loader data loading

Two issues happening when loading data into Oracle through SQL*Loader have been fixed.

There were some cases where generated CTL file was not containing the defining of columns, which was causing issues, and which is now fixed.

There was also an issue with the record delimiter used to export source data into files which could be different than the one used by SQL*Loader which could also lead to issue and bad data loading, and which has also been fixed.


New truncate table parameter

A new additional parameter for removing data on target table before the replication has been added: 'Truncate Tables'.

Refer to parameter documentation for further information.



Snowflake loading updated

Snowflake specific loading has been updated to take into account the changes which have been implemented on Snowflake Connector from templates.snowflake.2019-04-17.

Data loading will now be more efficient and match connector updates.


Generated target table name was incorrect for Microsoft SQL Server when using prefix parameter

Replication on a target Microsoft SQL Server database using "Target Object Prefix" parameter was not working properly.

Specified prefix was not included into the delimiters which surround generated target table but outside, which was causing issues.

This has been fixed, prefix is now placed properly in generated table name.


Replicator Xml to Rdbms
Ability to use technology specific loaders

XML Replicator now supports using technology specific loaders.

A new parameter named "Load Method" has been added to enable specific loading.

Refer to parameter documentation for further information.



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 statistics

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


You have no rights to post comments


Suggest a new Article!