Accéder au contenu principal Passer au contenu complémentaire

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.

Note InformationsAssurez-vous que le compte que vous utilisez dispose d'un accès en lecture sur les tables à récupérer.

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.

To find the time zone information:

  1. Log into your Mambu account.
  2. Go to Administration > General Setup > Organization Details.
  3. Under Time Zone, copy the information.

Creating the connection

Pour plus d'informations, consultez Connexion à des applications SaaS.

  1. Complétez les propriétés de connexion requises.
  2. Fournissez un nom pour la connexion dans Nom de la connexion.

  3. Sélectionnez Ouvrir les métadonnées de connexion pour définir les métadonnées de la connexion lors de sa création.

  4. Cliquez sur Créer.

Connection settings
SettingDescription
Data gateway

Sélectionnez une Passerelle de déplacement des données si cela est nécessaire pour votre cas d'utilisation.

Note Informations

Ce champ n'est pas disponible avec l'abonnement Démarreur Qlik Talend Cloud, car il ne supporte pas Passerelle de déplacement des données. Si vous avez un autre niveau d'abonnement et si vous ne souhaitez pas utiliser Passerelle de déplacement des données, sélectionnez Aucune.

Pour des informations sur les avantages de Passerelle de déplacement des données et les cas d'utilisation qui la nécessitent, consultez Passerelle de données Qlik - Déplacement des données.

Start Date

Saisissez la date, au format MM/DD/YYYY, à partir de laquelle les données doivent être répliquées de votre source vers votre cible.

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

Schema

Note Informations

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

Cette page vous a-t-elle aidé ?

Si vous rencontrez des problèmes sur cette page ou dans son contenu – une faute de frappe, une étape manquante ou une erreur technique – faites-le-nous savoir.