Mambu Data Lake
The Mambu Data Lake is the foundation of Mambu Insights. It provides a robust and scalable architecture for ingesting, processing, and storing your banking data, making it ready for analysis and integration.
Architecture overview
The data journey in Mambu Insights follows a structured ETL (Extract, Transform, Load) process that ensures data quality and usability.
- Mambu Core Banking Engine database: This is the single source of truth for all financial product data.
- Mambu Delta Extract: All changes from the core banking database are captured in near-real time through a Change Data Capture (CDC) stream. This process has minimal impact on the performance of your operational database. This raw, replicated data is landed in the Bronze layer of the data lake.
- Mambu Gold Standard ETL pipelines: The raw data is then cleaned, transformed, and modeled into structured, domain-aligned data products. These curated datasets reside in the Gold layer of the data lake and are ready for consumption.
- Data access: You can access the Gold Standard data products via direct object storage access (S3) or through integrations with platforms like Snowflake and Databricks Delta Share.
Base data products
Initially, Mambu Insights provides a set of Gold Standard base products. These products are modeled after Mambu's core entities and provide a comprehensive view of your deposit and lending portfolios.
- Activity
- Branch
- Client
- Credit Arrangement
- Deposit Product
- Deposit Account
- Deposit Transaction
- GL Account
- GL Journal Entry
- Group
- Loan Product
- Loan Account
- Loan Transaction
For more information on the Gold Standard product offerings and field availability, refer to the Insights Data Catalog.
These products ensure you have access to clean, reliable, and versioned data without needing to understand the complexities of Mambu's internal database schema.