Informatica to AWS Glue Migration Path



A customer is asking about how to migrate from on-prem Informatica to AWS Glue for ETL.

I've never used or seen Informatica so don't have a lot of insight. From what I gather, Informatica looks to be largely a proprietary visual / GUI-based ETL tool similar to SSIS. It doesn't seem like users are writing their own PySpark or Scala within Informatica... so my guess is that there's no direct migration path. The customer would need to port their Informatica ETL by manually translating the logic to PySpark or Scala code.

Just looking for confirmation on this suspicion or any other comments to share.

demandé il y a 5 ans1707 vues
1 réponse
Réponse acceptée

If by "migration path" you mean an automated migration that converts Informatica ETL jobs to Glue, then your suspicions are correct.

As you've described, they must go through their ETL jobs manually to move to Glue. I've found that customers have thousands of ETL jobs, but many of of them often produce a small filtered result as a csv for Excel viewers in a network drive. Keep an eye out for those, as the data lake and services like QuickSight and Athena and remove the need for ETL jobs like that.

répondu il y a 5 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions