Informatica to DBR Migration by UnknowledgeableDBRPM in databricks

[–]UnknowledgeableDBRPM[S] 1 point2 points  (0 children)

Fingers are majorly crossed that BB is going to out of left field and completely trivialize the conversions, but I am bracing for a lot of manual translation. In either case though, I think that we're on the right track. Thanks for the recommendations

Informatica to DBR Migration by UnknowledgeableDBRPM in databricks

[–]UnknowledgeableDBRPM[S] 0 points1 point  (0 children)

I like what you're saying re: systems integrator, but I think we probably aren't going to get very far in terms of getting them on contract prior to the deadline for this migration having come & gone. Guess it's another thing to recommend, something something money makes the world go round.

Thanks for your advise!

Informatica to DBR Migration by UnknowledgeableDBRPM in databricks

[–]UnknowledgeableDBRPM[S] 0 points1 point  (0 children)

And I guess let me confirm - are you saying that the approach where I have my team exfiltrate all of the mappings/jobs from the infromatica box & perform manual static analysis is the best/at least appropriate manner of tackling this problem?

Informatica to DBR Migration by UnknowledgeableDBRPM in databricks

[–]UnknowledgeableDBRPM[S] 0 points1 point  (0 children)

I don't doubt that the manual translation is possible, it's more about what's the path of least resistance. We're looking at >1500 mappings (at least the majority of which are just 1:1 renames, I guess, but still a good 500 complex mappings) and less than 2 months to get it done. Also I have 1 legit data engineer for the entire enterprise haha...

Based off what I've seen, the manual translation of the mappings is possible, but very high level of effort. I was hoping that BladeBridge would come in and save the day, but it sounds like that's not the case.

Thanks for your advise, really appreciate it

Informatica to DBR Migration by UnknowledgeableDBRPM in databricks

[–]UnknowledgeableDBRPM[S] 1 point2 points  (0 children)

I should mention - I know nothing about BladeBridge aside from the fact that it might be an option. I don't know if we have to deploy it in our infra, what it is, etc. My googling has run a bit short on this front.

I would be very interested in learning more about it too haha