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.