Skip to main content Skip to complementary content

Mambu 

Mambu is a cloud-native, API-driven, composable banking and financial services platform.

For more information about the API, see the Mambu v2.0 and v1.0 APIs.

See the Schema section for a list of objects available for replication.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Information noteMake sure that the account you use has read access to the tables you want to fetch.

To authenticate audit trail requests you must use an API key generated by an API consumer that has the Manage Audit Trail (MANAGE_AUDIT_TRAIL) permission assigned to it. For more information, see API Consumers in Mambu documentation.

You need a Mambu account with API access. In Mambu’s app, API access can be granted to any existing user.

Creating the connection

For more information, see Connecting to SaaS applications.

  1. Fill in the required connection properties.
  2. Provide a name for the connection in Connection name.

  3. Select Open connection metadata to define metadata for the connection when it has been created.

  4. Click Create.

Connection settings
SettingDescription
Data gateway

Select a Data Movement gateway if required by your use case.

Information note

This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.

For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement.

Start Date

Enter the date, in the format MM/DD/YYYY, from which the data must be replicated from your source to your target.

SubdomainSubdomain. Example: If the subdomain is qlik.mambu.com, enter qlik .
UsernameMambu username.
PasswordMambu password.
Audit Trail API KeyAudit trail API key.

Schema

Information note

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 4.

Depending on your destination, table and column names may not appear as they are outlined below.

activities

This table contains information about activities.

Replication Method

CDC

Primary Key

encoded_key

Replication Key

timestamp

Useful links

Mambu documentation

Mambu API method

audit_trail

This table contains information about activities that have been performed in the Mambu Core Banking system.

Replication Method

CDC

Replication Key

occurred_at

Useful links

Mambu documentation

Mambu API method

branches

This table contains information about branches.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

cards

This table contains information about cards.

Note: In order to replicate this table, you must also set the deposit-account table to replicate.

Replication Method

Full Table

Primary Keys

deposit_id

reference_token

deposit-account

Useful links

Mambu documentation

Mambu API method

centres

This table contains information about centres.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

clients

This table contains information about clients.

Replication Method

Full Table

Primary Key

id

Useful links

Mambu documentation

Mambu API method

communications

This table contains information about communications.

Replication Method

CDC

Primary Key

encoded_key

Replication Key

creation_date

Useful links

Mambu documentation

Mambu API method

credit_arrangements

This table contains information about credit arrangements.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

custom_field_sets

This table contains information about custom field sets.

Replication Method

Full Table

Primary Key

id

Useful links

Mambu documentation

Mambu API method

deposit_accounts

This table contains information about deposit accounts.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

deposit_products

This table contains information about deposit (savings) products.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

deposit_transactions

This table contains information about deposit transactions.

Replication Method

CDC

Primary Key

encoded_key

Replication Key

creation_date

Useful links

Mambu documentation

Mambu API method

gl_accounts

This table contains information about general ledger accounts.

Replication Method

CDC

Primary Key

gl_code

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

gl_journal_entries

This table contains information about general ledger entries.

Replication Method

CDC

Primary Key

entry_id

Replication Key

booking_date

Useful links

Mambu documentation

Mambu API method

groups

This table contains information about groups.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

index_rate_sources

This table contains information about index rate sources.

Replication Method

Full Table

Primary Key

encoded_key

Useful links

Mambu API method

installments

This table contains information about installments for a loan.

Replication Method

CDC

Primary Key

encoded_key

Replication Key

last_paid_date

Useful links

Mambu documentation

Mambu API method

interest_accrual_breakdown

This table contains information about interest accruals.

Replication Method

CDC

Primary Key

entry_id

Replication Key

creation_date

loan_accounts

This table contains information about Loan Accounts.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

loan_products

This table contains information about loan products.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu API method

loan_repayments

This is a child table of loan_accounts, containing information exclusively about loan repayments.

Note: In order to replicate this table, you must also set the loan-account table to replicate.

Replication Method

Full Table

Primary Key

encoded_key

loan-account

Useful links

Mambu API method

loan_transactions

This table contains information about loan transactions.

Replication Method

CDC

Primary Key

encoded_key

Replication Key

creation_date

Useful links

Mambu documentation

Mambu API method

tasks

This table contains information about tasks.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

users

This table contains information about users.

Replication Method

CDC

Primary Key

id

Replication Key

last_modified_date

Useful links

Mambu documentation

Mambu API method

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!