Ir para conteúdo principal Pular para conteúdo complementar

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.

Nota informativaCertifique-se de que a conta que você usa tenha acesso de leitura às tabelas que deseja buscar.

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

Para obter mais informações, consulte Conectando-se a aplicativos SAP.

  1. Preencha as propriedades de conexão obrigatórias.
  2. Forneça um nome para a conexão em Nome da conexão.

  3. Selecione Abrir metadados de conexão para definir metadados para a conexão quando ela for criada.

  4. Clique em Criar.

Connection settings
SettingDescription
Data gateway

Selecione um Gateway Data Movement se for necessário para seu caso de uso.

Nota informativa

Esse campo não está disponível com a assinatura do Iniciante do Qlik Talend Cloud, pois esta não é compatível com o Gateway Data Movement. Se você tiver outro nível de assinatura e não quiser usar o Gateway Data Movement, selecione Nenhum.

Para obter informações sobre os benefícios do Gateway Data Movement e casos de uso que exigem isso, consulte Qlik Data Gateway - Movimentação de dados.

Start Date

Digite a data, no formato MM/DD/YYYY, a partir da qual os dados devem ser replicados da fonte de dados para o destino.

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

Nota informativa

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

Esta página ajudou?

Se você encontrar algum problema com esta página ou seu conteúdo – um erro de digitação, uma etapa ausente ou um erro técnico – avise-nos!