Zu Hauptinhalt springen Zu ergänzendem Inhalt springen

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.

InformationshinweisVergewissern Sie sich, dass das verwendete Konto Lesezugriff auf die Tabellen hat, die Sie abrufen möchten.

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

Weitere Informationen finden Sie unter Herstellung einer Verbindung zu SaaS-Anwendungen.

  1. Füllen Sie die erforderlichen Verbindungseigenschaften aus.
  2. Geben Sie einen Namen für die Verbindung in Verbindungsname ein.

  3. Wählen Sie Verbindungsmetadaten öffnen aus, um nach der Erstellung Metadaten für die Verbindung zu definieren.

  4. Klicken Sie auf Erstellen.

Connection settings
SettingDescription
Data gateway

Wählen Sie ein Data Movement Gateway aus, wenn dies für Ihren Anwendungsfall erforderlich ist.

Informationshinweis

Dieses Feld ist für das Qlik Talend Cloud Starter-Abonnement nicht verfügbar, da dieses Abonnement Data Movement Gateway nicht unterstützt. Wenn Sie eine andere Abonnementstufe haben und Data Movement Gateway nicht verwenden möchten, wählen Sie Keine.

Weitere Informationen zu den Vorteilen von Data Movement Gateway und den Anwendungsfällen, in denen es erforderlich ist, finden Sie unter Qlik Data Gateway – Datenbewegung.

Start Date

Geben Sie das Datum im Format MM/DD/YYYY ein, ab dem die Daten von der Quelle zum Ziel repliziert werden müssen.

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

Informationshinweis

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

Hat diese Seite Ihnen geholfen?

Wenn Sie ein Problem mit dieser Seite oder ihrem Inhalt feststellen, sei es ein Tippfehler, ein ausgelassener Schritt oder ein technischer Fehler, informieren Sie uns bitte!