We have hundreds of ETL process (Informatica) with a lot of logic pulling various data from applications into a relational db (Target DB). Can we use Delta Lake as the Target DB?

Disney
New Contributor II

‎01-19-2022 10:52 AM

Hi DB Support,

Can we use DB's Delta Lake as our Target DB? Here's our situation...

  • We have hundreds of ETL jobs pulling from these Sources. (SAP, Siebel/Oracle, Cognos, Postgres) .
  • Our ETL Process has all of the logic and our Target DB is an MPP system.
  • We have MSTR and Tableau for reporting.

Can we use Databrick's Delta Lake to replace our "Target DB"? We have over a thousand tables and views on top so a conversion tool is great to have? Does Databrick have an easier way to replace our MPP "Target DB"? Target DB can be a redshift, postgre, sqlserver or other mpp db.

Can you advise? Please send reply via email.

Thank you!

-william

Labels: