Released: September 2022
This release contains the following new features:
API updates include:
The creation of custom services for SQL import and export. A custom script task can be created and used in workflows.
All triggers and blocking constraints can be turned off when running add-on services.
During a data integration operation, valid records are persisted in EBX®, whereas invalid records are skipped and listed in an error file after the operation. In the file, a column is added that shows the relevant error message for each record.
If there is invalid data found during an import, a new option enables the download of a file containing the invalid data. A column is added that shows the relevant error message for each record.
A connection with TIBCO Data Virtualization can be created to integrate data between TDV views and a TIBCO EBX® data model.
Custom date and date/time patterns can now be created and used with CSV import and export services.
Additional information about data integration services is now included in the add-on's logs.
Error log performance is improved.
When using a custom workflow script task:
The Template parameter now accepts the template's UUID or name as valid input.
When using a template with a custom workflow script task, transformation function parameters can be overridden.
This release contains no changes in functionality.
This release contains no changes to third-party libraries.
This release contains the following closed issues:
[DINT-3161] Excel file cells are incorrectly formatted when exporting numeric fields.
[DINT-3397] The database connection test does not work when the URL contains a special character.
[DINT-3405] The Transform table shows all cross reference transformations as having an error.
[DINT-3427] Add-on services do not work if a connection is created with a TIBCO Data Virtualization server view that has no schema.
[DINT-3431] When importing Excel at the dataset level, the execution order is not consistent with the Excel sheet order.
[DINT-3441] A template created from a temporary dataspace cannot be used.
This release contains the following known issues:
When exporting to SQL with TDV, if any error occurs, the operation is cancelled.
Due to a limitation in Excel, long fields with the number data type display all numbers past the 16th place as a 0.
Importing and exporting SQL: Read and write is not possible with the Timestamp data type with MS SQL Server.
Configuring a schema using the JNDI configuration in your web server is not supported.
When creating a custom transformation function, you must use a predefined data type for its input and output fields.