Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Перейти к основному содержимому Перейти к дополнительному содержимому

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.

Примечание к информацииУбедитесь, что используемая учетная запись имеет доступ для чтения к таблицам, которые требуется получить.

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

Для получения дополнительной информации см. раздел Подключение к приложениям SaaS.

  1. Заполните необходимые свойства подключения.
  2. Заполните поле Имя подключения.

  3. Установите флажок Открыть метаданные подключения, чтобы определить метаданные для подключения, когда оно будет создано.

  4. Щелкните Создать.

Connection settings
SettingDescription
Data gateway

Выберите шлюз Data Movement gateway, если этого требует текущий сценарий использования.

Примечание к информации

Это поле недоступно при использовании подписки Qlik Talend Cloud Starter, так как она не поддерживает Data Movement gateway. Если используется другой уровень подписки или не требуется использовать Data Movement gateway, выберите Нет.

Для получения информации о преимуществах Data Movement gateway и о сценариях, требующих его использования, см. раздел Qlik Data Gateway — Data Movement.

Start Date

Введите дату в формате MM/DD/YYYY, начиная с которой данные должны реплицироваться из источника в цель.

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

Schema

Примечание к информации

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

Помогла ли вам эта страница?

Если вы обнаружили какую-либо проблему на этой странице и с ее содержанием — будь то опечатка, пропущенный шаг или техническая ошибка, сообщите нам об этом, чтобы мы смогли ее исправить!