DEV Community

Cover image for Data Warehouse and Lakehouse Ecosystem
Mahmoud Rabie
Mahmoud Rabie

Posted on

Data Warehouse and Lakehouse Ecosystem

The ๐™ฅ๐™–๐™ง๐™ฉ๐™ฃ๐™š๐™ง๐™จ๐™๐™ž๐™ฅ between:
(1) Oracle and
(2) Informatica
brings together two industry leaders in database and data management to deliver a comprehensive enterprise ๐™™๐™–๐™ฉ๐™– ๐™ฌ๐™–๐™ง๐™š๐™๐™ค๐™ช๐™จ๐™š ๐™–๐™ฃ๐™™ ๐™ก๐™–๐™ ๐™š๐™๐™ค๐™ช๐™จ๐™š ๐™š๐™˜๐™ค๐™จ๐™ฎ๐™จ๐™ฉ๐™š๐™ข.

This ๐™ง๐™š๐™›๐™š๐™ง๐™š๐™ฃ๐™˜๐™š ๐™–๐™ง๐™˜๐™๐™ž๐™ฉ๐™š๐™˜๐™ฉ๐™ช๐™ง๐™š shows how Informatica ๐™„๐˜ฟ๐™ˆ๐˜พ ๐™Ž๐™š๐™˜๐™ช๐™ง๐™š ๐˜ผ๐™œ๐™š๐™ฃ๐™ฉ operates in Oracle ๐˜พ๐™ก๐™ค๐™ช๐™™ ๐™„๐™ฃ๐™›๐™ง๐™–๐™จ๐™ฉ๐™ง๐™ช๐™˜๐™ฉ๐™ช๐™ง๐™š (๐™Š๐˜พ๐™„)
(1) Data is ๐™š๐™ญ๐™ฅ๐™ค๐™ง๐™ฉ๐™š๐™™ from Oracle ๐™€-๐˜ฝ๐™ช๐™จ๐™ž๐™ฃ๐™š๐™จ๐™จ ๐™Ž๐™ช๐™ž๐™ฉ๐™š and
(2) ๐™ž๐™ข๐™ฅ๐™ค๐™ง๐™ฉ๐™š๐™™ data into an Oracle ๐˜ผ๐™ช๐™ฉ๐™ค๐™ฃ๐™ค๐™ข๐™ค๐™ช๐™จ ๐˜ฟ๐™–๐™ฉ๐™–๐™—๐™–๐™จ๐™š
to be consumed by either analytics or data science processes.

In general, the architecture includes the following ๐™ก๐™ค๐™œ๐™ž๐™˜๐™–๐™ก ๐™™๐™ž๐™ซ๐™ž๐™จ๐™ž๐™ค๐™ฃ๐™จ:
(1) ๐˜ฟ๐™–๐™ฉ๐™– ๐™ง๐™š๐™›๐™ž๐™ฃ๐™š๐™ง๐™ฎ
(2) ๐˜ฟ๐™–๐™ฉ๐™– ๐™ฅ๐™š๐™ง๐™จ๐™ž๐™จ๐™ฉ๐™š๐™ฃ๐™˜๐™š platform (curated information layer)
(3) ๐˜ผ๐™˜๐™˜๐™š๐™จ๐™จ ๐™–๐™ฃ๐™™ ๐™ž๐™ฃ๐™ฉ๐™š๐™ง๐™ฅ๐™ง๐™š๐™ฉ๐™–๐™ฉ๐™ž๐™ค๐™ฃ

๐˜ฟ๐™š๐™ฅ๐™ก๐™ค๐™ฎ ๐™–๐™ฃ ๐™–๐™ฃ๐™–๐™ก๐™ฎ๐™ฉ๐™ž๐™˜๐™จ ๐™ฅ๐™ก๐™–๐™ฉ๐™›๐™ค๐™ง๐™ข ๐™›๐™ค๐™ง ๐™„๐™ฃ๐™›๐™ค๐™ง๐™ข๐™–๐™ฉ๐™ž๐™˜๐™– ๐™„๐˜ฟ๐™ˆ๐˜พ ๐™ค๐™ฃ ๐™Š๐™ง๐™–๐™˜๐™ก๐™š ๐˜พ๐™ก๐™ค๐™ช๐™™
https://docs.oracle.com/en/solutions/informatica-on-oci/img/informatica-oci.png

๐™Ž๐™ฉ๐™–๐™ฎ ๐™ฉ๐™ช๐™ฃ๐™š๐™™ ๐™—๐™ฎ ๐™›๐™ค๐™ก๐™ก๐™ค๐™ฌ๐™ž๐™ฃ๐™œ
https://www.linkedin.com/feed/hashtag/?keywords=did_you_know_that

Image description

https://www.linkedin.com/posts/mahmoudrabie2004_didabryouabrknowabrthat-oracle-oracleace-activity-6936549119607910400-ViJ4?utm_source=linkedin_share&utm_medium=member_desktop_web

Top comments (0)