topic Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge in Data Engineering

Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

chirag_nagar — Mon, 21 Jul 2025 09:08:11 GMT

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?

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

MariuszK — Mon, 21 Jul 2025 09:21:50 GMT

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

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

Elyas — Tue, 02 Sep 2025 09:47:34 GMT

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 activities. Please share the experience if anyone used the code repo for migration.

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

thelogicplus — Thu, 11 Sep 2025 15:43:42 GMT

@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.

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

dinshows15 — Wed, 05 Nov 2025 09:41:41 GMT

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.

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

thelogicplus — Wed, 05 Nov 2025 10:44:49 GMT

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 .

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

dinshows15 — Wed, 05 Nov 2025 12:06:20 GMT

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

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

AnnaKing — Tue, 02 Dec 2025 05:15:52 GMT

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

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

dinshows15 — Tue, 02 Dec 2025 07:03:12 GMT

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

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

AnnaKing — Tue, 02 Dec 2025 09:41:30 GMT

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.

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

dinshows15 — Tue, 02 Dec 2025 10:19:22 GMT

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.

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

AnnaKing — Mon, 15 Dec 2025 05:39:16 GMT

Hi @dinshows15. Kanerika;s Informatica->Databricks using FLIP can handle BDE Mappings as well. It covers both PowerCenter as well as Informatica Developer (BDE/Java Designer) repositories. Let us know if you would like to setup a separate session for one-on-one discussion with our Solution architect.

Re: Seeking Guidance on Migrating Informatica PowerCenter Workflows to Databricks using Lakebridge

Kalyan4 — Mon, 15 Dec 2025 14:44:12 GMT

Hi, Currently there’s no mature tool that can fully convert Informatica BDM mappings into PySpark. Most converters (like Lakebridge) support PowerCenter only, since BDM is metadata-driven and its XML structure is very different. BDM → PySpark typically needs partial automation plus manual refactoring. Sharing the BDM complexity (pushdown, CDC, mapping types) can help identify the best approach.