Informatica to AWS Glue Migration Path

0

Hi,

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.

asked 5 years ago1603 views
1 Answer
0
Accepted Answer

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.

AWS
answered 5 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions