MySQL Connector Post-Upgrade Tasks
When the 32-bit Secure Agent upgrades to 64-bit in version 33.0, the timestamp value of the MySQL source in existing tasks modifies.
For example, if the MySQL source has a timestamp value of "01/01/1970 05:30:01", you can view the following timestamp values before and after the upgrade:
- •Before the upgrade, the timestamp value of the MySQL source reads as "01/01/1970 00:00:01" in tasks with the 32-bit Secure Agent.
- •After the upgrade, the timestamp value of the MySQL source reads as "01/01/1970 05:30:01" in tasks with the 64-bit Secure Agent.
To retain the timestamp value in existing tasks after the upgrade, perform the following tasks:
- 1. In the Informatica Cloud home page, click Configuration > Runtime Environments.
- 2. Select the Secure Agent for which you want to add a custom flag to set the timestamp value, and click Edit.
- 3. In the Custom Configuration Details section, add a custom property with the following configurations:
- - Service: Data Integration Server
- - Type: DTM
- - Name: OdbcMySQLConnectionOptions
- - Value: 3;initstmt = set time_zone = '+00:00'
- 4. Click OK.