Post-Upgrade Tasks for Lookups Configured in Amazon Redshift and Microsoft Azure SQL Data Warehouse Connectors
Earlier versions of Amazon Redshift Connector and Microsoft Azure SQL Data Warehouse Connector do not support advanced options for lookup in Data Synchronization tasks. You could, however, perform a lookup through the JDBC query.
After the upgrade, you can configure a lookup for Amazon Redshift and Microsoft Azure SQL Data Warehouse objects in the Data Synchronization task. You must specify the mandatory properties in the Field Lookup dialog box to save and run tasks successfully.
To use existing tasks from previous versions that were configured for lookup through the JDBC query, perform the following tasks after the upgrade:
- •If you edit existing tasks, you must specify the mandatory properties required for lookup to save and run the task successfully.
- •If you do not edit existing tasks, you can continue to run the tasks successfully.