The following topics provide information about tasks that you might need to perform before or after an upgrade of Data Integration Connectors. Post-upgrade tasks for previous monthly releases are also included in case you haven't performed these tasks after the previous upgrade.
Post-upgrade tasks for the July 2024 release
Perform the following tasks after your organization is upgraded to the July 2024 release.
Oracle Connector
If you run a mapping with an Oracle connection to write data to a column with nVarchar2 datatype, and the source data length exceeds the precision set for the target object, the rows are rejected with a warning message. Previously, these records were written to the target after truncating the data as per the precision set for the target object. This issue occurs because the base drivers for Oracle Connector is upgraded to the following versions:
•JDBC: 6.0.0.001165
•ODBC: 08.02.3072
To resolve this issue, perform one of the following actions:
•You can increase length of column in Oracle database and resync the target before running the mappings.
•To retain the old behavior, you can use the older version of the driver available in the EBF folder. Perform the following steps to use the drivers from the EBF folder:
1Log in to Informatica Intelligent Cloud Services.
2In Administrator, select Runtime Environments.
3Select the Secure Agent that runs the mapping, and click Edit.
4In the Custom Configuration Details section, select Data Integration Server as the service.
5Select the applicable Data Integration Server type and add the following custom properties based on the JDBC or ODBC driver that you want to use for your connector.
Driver
Type
Custom Property
Value
Oracle JDBC
Tomcat
ORACLE_JDBC_DRIVER_JARNAME
'dworacle-ebf.jar'
Oracle ODBC
DTM
DD_CLOSED_ORACLE_DRIVER
'DataDirect CLOSED 8.0 Oracle Wire Protocol for Informatica - EBF'