I am frequently tasked with migrating data from a redshift datamart to a MySQL transactional db. The current flow I use for doing so is to write a query to download from redshift, transform the data then do uploads to MySQL. I was wondering if it would be possible to develop something that would perform the transaction entirely in the cloud, saving me network latency. Please let me know if Talend offers components for doing so.
Talend is having cloud offering i.e. Talend 7.0 Cloud which is running over AWS.
It will be an excellent idea to use Talend cloud for your use case and please refer the product details below.