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]

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

[Hubert-Dudek · Accepted solution]

Hi yes you can the best is to create sql endpoint in premium workspace and just write to delta lake as to sql.

This is community forum not support. You can contact databricks via https://databricks.com/company/contact or via AWS, Azure if you have support plan there (is the fastest)