Braintree

Braintree is an online and in-app payment platform.

Braintree integration replicates data using the Braintree API.

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

对这个连接器进行高级查看，包括有用的链接和支持的特性。

特性/功能	支持详情
支持的 Qlik Talend Data Integration 项目	仅 Replication 项目。不支持数据管道项目。
目标更新方法	复制任务：应用更改存储更改在数据湖任务中登陆数据：更改数据捕获 (CDC)
管理元数据	无需手动生成元数据。
模式演变	只支持更改列数据类型操作。
复制 LOB 列（NCLOB、CLOB 和 BLOB）	不支持
已计划 CDC	必填字段。这就是目标与源的更改保持同步的方式。有关复制任务，请参阅计划任务有关湖登陆任务，请参阅为湖登陆任务调度 CDC
通知	部分支持设置操作更改通知
监视	仅 CDC，因为满负载与此连接器无关。监视单个数据任务
JSON 列有效载荷的自动解密	不支持不会自动在目标上删除源数据集中的 JSON 列有效负载。

Preparing for authentication

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

请确保您使用的帐户对要获取的表具有读取权限。

To set up your Braintree account, you need:

Super Admin and API Access permissions in Braintree. This is required to create the API access token. For more information, see Braintree user roles and permissions.
Additionally, Braintree replicates transactions for the default merchant account in your Braintree instance.

To retrieve your private key:

Log into your Braintree account.
Click Account > My User.
Scroll down to the API Keys, Tokenization Keys, Encryption Keys section.
Click View Authorizations.
In the API Keys section, click Generate New API Key.
After the key has been generated, click the View link in the Private Key column.
The Client Library Key page is displayed with your Braintree API credentials.

Creating the connection

有关更多信息，请参阅连接到 SaaS 应用程序。

填写所需的连接属性。
在连接名称中提供连接的名称。
选择打开连接元数据以定义创建连接时的元数据。
单击创建。

Connection settings
Setting	Description
Data gateway	如果您的用例需要，请选择一个数据移动网关。信息注释此字段不适用于 Qlik Talend Cloud Starter 订阅，因为它不支持数据移动网关。如果您有另一个订阅层并且不想使用数据移动网关，请选择无。有关数据移动网关的优势和需要它的用例的信息，请参阅Qlik 数据网关 - 数据移动。
Start Date	按格式 `MM/DD/YYYY` 输入必须将数据从源复制到目标的日期。
Merchant ID	Merchant ID.
Private Key	Private key.
Public Key	Public key.
Environment	Enter a value: Development, QA, Sandbox, Production, or All. If left empty, Production is set as default.

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 1.

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

transactions

The transactions table contains info about the transactions in your Braintree account, including the transaction’s status.

Note: Our Braintree integration will only replicate transactions for the default merchant account in your Braintree instance. You can verify the merchant account set as the default by going to Settings > Processing > Merchant Accounts when signed into Braintree.

Replication Method	CDC
Primary Key	id
Replication Key	created_at
Useful links	Braintree documentation

amount

NUMBER

created_at

DATE-TIME

credit_card_details

OBJECT

This is a nested data structure:

card_type: STRING
customer_location: STRING

currency_iso_code

STRING

customer_details

OBJECT

This is a nested data structure:

email: STRING
id: STRING

disbursement_details

OBJECT

gateway_rejection_reason

STRING

merchant_account_id

STRING

order_id

STRING

payment_instrument_type

STRING

paypal_details

OBJECT

plan_id

STRING

processor_authorization_code

STRING

processor_response_code

STRING

processor_response_text

STRING

recurring

BOOLEAN

refunded_transaction_id

STRING

service_fee_amount

NUMBER

settlement_batch_id

STRING

status

STRING

subscription_details

OBJECT

This is a nested data structure:

billing_period_end_date: DATE-TIME
billing_period_start_date: DATE-TIME

subscription_id

STRING

type

STRING

updated_at

DATE-TIME

本页面有帮助吗？

如果您发现此页面或其内容有任何问题 – 打字错误、遗漏步骤或技术错误 – 请告诉我们！

在此处留下您的反馈