Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

[chirag_nagar]

Hi everyone,

I hope you're doing well.

I'm currently exploring options to migrate a significant number of Informatica PowerCenter workflows and mappings to Databricks. During my research, I came across Lakebridge, especially its integration with BladeBridge, which appears to support automated conversion of Informatica logic into Databricks-native formats such as SQL, PySpark, and notebooks.

While the office documentation has been very helpful, I was hoping to get some additional insights or real-world experiences from the community to help guide our next steps.

I would truly appreciate your inputs on the following questions:
1. Has anyone here successfully migrated Informatica PowerCenter workflows using Lakebridge + BladeBridge

2. How was your experience regarding:

• Code quality
• Accuracy of transformations
• Workflow and orchestration logic coverage

3. Does BladeBridge support complex transformations and control flow logic in PowerCenter workflows?
Or is it primarily geared toward mapping conversions?

4. What does the licensing or pricing model look like for using BladeBridge via Lakebridge?
Is it included as part of Databricks support or offered separately?

5. Are there any demos or walkthroughs available that showcase the process of converting PowerCenter .xml files to Databricks code?

[MariuszK]

Good questions, I'm also curious. In the past, I supported this kind of migration using a custom solution to convert IPC to PySpark.

[Elyas]

 I'm also curious. Looking forward for the answers with a same kind of questions. And also I could see there is a code repo shared by databricks for the lakebridge GitHub - databrickslabs/lakebridge: Accelerates migrations to Databricks by automating key migration.... Please share the experience if anyone used the code repo for migration.

[thelogicplus]

@chirag_nagar You should definitely check out Travinto Tools—it's one of the most reliable and effective solutions for migrating Informatica (PowerCenter/IDMC) workloads to Databricks. I've been using it for the past three years during my time at Deloitte, and it's consistently delivered great results.

[dinshows15]

Dear all , 

Is there any tool can convert Informatica BDM mappings to Pyspark code. 

Lakebridge is not able to do it , it has limitation and it can work only for Powercenter mappings. 

Down the line they may come up but as of now only till Power center. 

While compairng xmls of powercenter and BDM its huge diff in format and overall structure of xml.

Informatica made it quite complex to make it difficult to get converted to other tech like Pyspark by using these kind of tools. 

[thelogicplus]

Hi @dinshows15  You can use Travinto Technologies Code converter tool. They have very good tool and it supports informatica BDM as well as.  Please check with Travinto .

Lake bridge(Blade bridge) is the worst tool that I have used .

[dinshows15]

Thansk for the update @thelogicplus  I will have look and try to connect with team of Travinto.

[AnnaKing]

Hi Chirag. At Kanerika Inc,, we've built a migration accelerator that automates 80% of the Informatica to Databricks migration process, saving you significant time, effort, and resources. You can check out the demo video of the same here - https://www.youtube.com/watch?v=Fc46f1LzV-4
You can also explore  - https://kanerika.com/services/migration/informatica-to-databricks/
To discuss about the solution, please reach out to us at https://kanerika.com/meet

[dinshows15]

Thankyou for your update. 

How can we convert the informatica bdm or dei mappings or workflows by using any tool like Flip to Pyspark to migrate business logic written in informatica to Databricks.

Pl let me know.

Thanks 

Dinesh 

[AnnaKing]

While I check this for DEI Mappings, would it be possible to give me more info regarding your current setup and BDM workflows? I am sure our migration tool can be enhanced to process BDE logic.

[dinshows15]

Thanks @AnnaKing , we are having informatica bdm mappings and workflows. dei is just new name given to bdm by informatica. My question is which tool can convert these bdm mappings in pyspark code.as we know lakebridge tool only can convert from powercenter not from bdm.