All release notes
Related information
Version 4.5.5
New features
This release contains no changes in new features.
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
Known Issues
This release contains the following known issues:
-
A JNDI data source cannot be configured when EBX is deployed on a WebLogic, or JBoss server.
-
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.
Version 4.5.4
New features
This release contains no changes in new features.
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
This release contains the following closed issues:
Known Issues
This release contains the following known issues:
-
A JNDI data source cannot be configured when EBX is deployed on a WebLogic, or JBoss server.
-
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.
Version 4.5.3
Released: April 2023
New features
This release contains the following new features:
-
The API now supports record filters on TIBCO EBX® tables when using a
TemplateSpec. -
The number of updated and skipped records is now included in the import and transfer service results summary.
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
This release contains the following closed issues:
Known Issues
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.
Version 4.5.2
Released: February 2023
New features
This release was updated to ensure compatibility with TIBCO EBX® Add-ons Bundle version 5.6.1.
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
The Excel-streaming-reader library was upgraded to version 4.0.4.
Closed Issues
This release contains no closed issues.
Known Issues
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.
Version 4.5.1
Released: November 2022
New features
This release contains no new features.
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
The Excel-streaming-reader library was upgraded to version 4.0.4.
Closed Issues
This release contains no closed issues.
Known Issues
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.
Version 4.5.0
Released: September 2022
New features
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.
-
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
This release contains the following closed issues:
Known Issues
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.
Version 4.4.1
Released: July 2022
New features
When defining a custom cross reference transformation via the API or script task, the
Ignore lookup failure parameter can be defined.
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
Known Issues
This release contains the following known issues:
-
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.
Version 4.4.0
Released: June 2022
New features
This release contains the following new features:
-
You can save templates for SQL import and export operations.
-
When importing SQL, you can import from configured database views.
-
When exporting to Excel or CSV at the table level, you can include data from related tables.
-
You can include Primary Key, Foreign Key and Enumeration labels when exporting to CSV, Excel and SQL. Excel export also allows you to export Static Enumeration labels.
-
You can specify the Date and Date/time formats when importing CSV.
-
You can use the API to create custom transformation functions. These transformation functions will be available for business users to add to mappings in the user interface.
-
Support is now included for data model variants for the TIBCO EBX® Match and Merge Add-on in the Export SQL service.
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
Known Issues
This release contains the following known issues:
-
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.
Version 4.3.2
Released: April 2022
New features
This release contains the following new features:
-
The performance for SQL export was improved.
-
You can now use the API to:
-
Configure import, export, and transfer operations on any table or dataset that is based on the same data model.
-
Execute the template API at the dataset level.
-
Configure the template API on any dataset based on the same data model.
-
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
This release contains no closed issues.
Known Issues
This release contains the following known issues:
-
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.
Version 4.3.1
Released: March 2022
New features
You can now use import, export, and transfer functionality in workflow services and perspective actions. The add-on specific services and actions begin with
[ebx-addon-dint]. There are two options for each import, export and transfer type—one to apply to tables and one for datasets.
Changes in Functionality
This release contains the following changes in functionality:
-
When saving a template, the position of tables, transformation functions, and links in the Mapping screen are now stored. When the template is loaded, the components display according to the state of the most recent save.
-
Template names must now be unique.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
This release contains no closed issues.
Known Issues
This release contains the following known issues:
-
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.
Version 4.3.0
Released: February 2022
New features
This release contains the following new features:
-
You can now import from and export to SQL databases. An administrator must configure the connection to the database and connection between the database and data model. See the User Guide for more information.
-
The cross-reference transformation function contains the new Ignore lookup failure option. When enabled, records are imported and exported even when the cross-reference lookup does not find a corresponding value. If left disabled, records these records are not imported.
Changes in Functionality
This release includes the following changes in functionality:
-
Behavior during import at the table level was updated to ensure consistency when importing an empty file.
-
Templates are now available for use on tables from the same data model, regardless of their location.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
This release contains no closed issues.
Known Issues
This release contains the following known issues:
-
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.
Version 4.2.1
Released: December 2021
New features
This release includes no new features.
Changes in Functionality
This release includes no changes in functionality.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
Known Issues
This release contains no known issues.
Version 4.2.0
Released: November 2021
New features
This release includes:
-
Support for multi-table import, export and transfer operations at the dataset level. Additionally, when exporting from a dataset, you can now add target tables. This allows you to export data from one table to multiple locations. See the User Guide for more information about this feature.
-
When importing or exporting with Excel, the new List separator option allows you to define a separator for lists.
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
This release contains no changes to third-party libraries.
Closed Issues
This release contains no closed issues.
Known Issues
This release contains no known issues.
Version 4.1.1
Released: September 2021
New features
This release includes no new features.
Changes in Functionality
This release contains no changes in functionality.
Changes to third-party libraries
The Apache Streaming Excel Reader library was upgraded to version 3.1.1.
Closed Issues
Known Issues
This release contains no known issues.
Version 4.1.0
Released: July 2021
New features
This release includes the following new features:
-
You can now transfer data between EBX® tables.
-
When exporting, you can now add, edit, and remove target fields in the Mapping screen.
-
When working with templates, you can now:
-
Set user permissions to view, modify and delete templates.
-
Save copies of templates.
-
-
The new Digital asset UUID lookup transformation function allows you to perform a bulk import operation to attach digital assets to records. Note that instructions for this process are contained in the TIBCO EBX® Digital Asset Manager Add-on documentation.
-
A public API has been provided that allows you to import, export and transfer data. See the Java API documentation for more information.
-
Tables in the Mapping screen now display data type and cardinality next to each field.
Changes in Functionality
This release contains no changes in functionality.
Closed Issues
This release contains no closed issues.
Known Issues
This release contains no known issues.
Version 4.0.1
Updates
Released: June 2021
This release contains the following updates:
-
The First row contains header label was changed to Include column headers for Excel export and Includes column headers for Excel import. When selecting Yes for this option during import, you are now prompted to enter the starting location of table data.
-
When exporting Excel the two rows at the beginning of the file were removed.
-
The following library updates were made:
-
The Apache Commons BeanUtils library was upgraded to version 1.9.4.
-
The Apache CFX and HttpClient libraries were removed.
-
Bug Fixes
Version 4.0.0
New features
Released: March 2021
The TIBCO EBX® Data Exchange Add-on (New) allows you to integrate data from a source location into a target. Additionally, it can transform the data to meet business and technical requirements of disparate applications and systems.
This release allows you to import and export using CSV and Excel formats at the TIBCO EBX® table level. No configuration is required to initiate an import or export operation. The add-on provides the following graphical elements and features to support import and export:
-
Automatic mappings are generated between source and target fields. Data mappings display as lines between source and targets. Where possible, the add-on generates these automatically and adds basic transformations if required. It will also alert you visually to possible errors or warnings.
-
Drag and drop functionality to create mappings and transformations when required.
-
Pop-up editors to define transformation functions. The add-on includes several built-in transformation functions to cover common use cases.
-
Templates that save mappings and other configuration options for reuse.
The following list provides links to additional topics and tasks:
|
Introduction to the add-on
|
For a more in-depth overview of the add-on and your potential interaction with it, see About the add-on
|
|
Importing
|
For an introduction to the import process, see Import overview.
For instructions on importing, see Importing to a table.
|
|
Exporting
|
For an introduction to the export process, see Export overview.
For instructions on exporting, see Exporting a table.
|
|
Mapping and transformations
|
Map and transform overview provides a look at how the add-on implements the concepts of mappings and transformations.
Mapping interface reference highlights the user interface used for mapping and transformation tasks during data integration. Additionally, it provides an example of using a transformation function.
You can refer to Transformation function reference to see a list and description of the add-on's built-in transformation functions.
|