BTG Parceiros is a financial services platform designed for BTG Partners, which are offices or consultancy firms that offer and manage BTG products for their clients. It provides tools for financial data management, reporting, and client portfolio tracking for investment and wealth management services.

This source is available for BTG Partners only. Partners are offices or consultancy firms that offer and manage BTG products for their clients. This connector is not meant to be used for PJ or PF BTG accounts.

Configuring BTG Parceiros as a Source

In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the BTG Parceiros option from the list of connectors. Click Next and you’ll be prompted to add your access and configurations.

1. Add account access

You will need to provide the following credentials:

Client ID: the client ID of the BTG Parceiros developer account.
Client secret: the client secret of the BTG Parceiros developer account.

These credentials can be generated from the Developer Partner portal.

Go to Autorização, then click on Gerar novas chaves
Store the new keys safely and use them to fill the required fields at Nekt

Besides generating the credentials, you’ll have to configure a webhook URL on the Webhooks -> Manutenção section. Please get in touch with Nekt support to get the webhook URL that should be used there. Once you’re done, click Next.

2. Select streams

The next step is letting us know which streams you want to bring. You can select entire groups of streams or only a subset of them.

Tip: The stream can be found more easily by typing its name.

The streams available bring D-1 reports.

If you don’t see a stream you were expecting to find, please check if your access key has access to it. If that’s not the issue, then it’s probably because we still haven’t implemented it. Feel free to get in touch and request it!

Select the streams and click Next.

3. Configure data streams

Customize how you want your data to appear in your catalog. Select the desired layer where the data will be placed, a folder to organize it inside the layer, a name for each table (which will effectively contain the fetched data) and the type of sync.

Layer: choose between the existing layers on your catalog. This is where you will find your new extracted tables as the extraction runs successfully.
Folder: a folder can be created inside the selected layer to group all tables being created from this new data source.
Table name: we suggest a name, but feel free to customize it. You have the option to add a prefix to all tables at once and make this process faster!
Sync Type: depending on the data you are bringing to the lake, you can choose between INCREMENTAL and FULL_TABLE. Read more about Sync Types here.

Once you are done configuring, click Next.

4. Configure data source

Describe your data source for easy identification within your organization. You can inform things like what data it brings, to which team it belongs, etc. To define your Trigger, consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times). Optionally, you can define some additional settings (if available):

Configure Delta Log Retention and determine for how long we should store old states of this table as it gets updated. Read more about this resource here.
Determine when to execute an Additional Full Sync. This will complement the incremental data extractions, ensuring that your data is completely synchronized with your source every once in a while.

When you are ready, click Next to finalize the setup.

5. Check your new source

You can view your new source on the Sources page. Now, for you to be able to see it on your Catalog, you have to wait for the pipeline to run. You can now monitor it on the Sources page to see its execution and completion. If needed, manually trigger the pipeline by clicking on the refresh icon. Once executed, your new table will appear in the Catalog section.

For you to be able to see it on your Catalog, you need at least one successful source run.

If you encounter any issues, reach out to us via Slack, and we’ll gladly assist you!

Streams and Fields

Available streams

The table below details the available streams you can sync from BTG Parceiros.

Stream	Slug	Description
Asset Allocation	`reports_asset_allocation`	Asset allocation report (Relatório de Alocação de Ativos): one row per account.
Closed Fund Reserve	`reports_closed_fund_reserve`	Closed fund reserve report (Reservas de Fundos Fechados): one row per reservation in a fund offering.
Pension Campaign	`reports_pension_campaign`	Pension campaign report (Campanha de Previdência): one row per pension operation in the campaign.
Subscription	`reports_subscription`	Subscription report (Relatório de Subscrição): one row per account and subscription right.
Trade Idea	`reports_trade_idea`	Trade idea report (Recomendação de Operação): fixed income positions with premium/discount and a recommended operation, one row per position and recommendation.

Depending on your BTG Parceiros access, you may also see other report streams available (such as Account Base, Banking, Commission, Operations, etc.).

Fields by stream

Asset Allocation

Asset allocation report (Relatório de Alocação de Ativos): one row per account.Key Fields:

Field	Type	Description
`nr_conta`	String	BTG account number
`total_fin`	Number	Total financial amount (BRL) of the account
`asset_total`	Number	Total number of assets held in the account
`dt_referencia`	Date	Reference date of the positions in the report
`profitability_mtd`	Number	Account profitability month to date
`profitability_last_12_months_accumulated`	Number	Account profitability accumulated over the last 12 months
`profitability_last_6_months_accumulated`	Number	Account profitability accumulated over the last 6 months
`profitability_last_3_months_accumulated`	Number	Account profitability accumulated over the last 3 months
`profitability_ytd`	Number	Account profitability year to date
`score_desenquadramento`	Number	Score of how far the portfolio deviates from the account’s suitability profile
`modelo_rentabilidade`	String	Profitability classification of the account, e.g. ‘Rentabilidade Acima do CDI’
`score_exposicao_risco`	Number	Risk exposure score of the portfolio
`liquidez`	Number	Liquidity indicator of the portfolio

Asset Classes Breakdown:The report breaks the portfolio into multiple asset classes: pos_fixado (post-fixed income), inflacao (inflation-linked), pre_fixado (pre-fixed income), retorno_absoluto (absolute return), renda_variavel (equities), internacional (international), alternativo (alternative investments), and nao_classificado (unclassified).For each class, the following fields are returned:

Field Pattern	Type	Description
`<class>_fin`	Number	Financial amount (BRL) allocated to the asset class
`<class>_allocation`	Number	Share of the account’s total financial amount allocated to the asset class (0 to 1)
`<class>_asset_total`	Number	Number of assets held in the asset class
`<class>_margem`	Number	Gap (BRL) between the amount allocated to the asset class and the account’s target allocation (Not available for `nao_classificado`)

(Standard common report properties are also included in this stream).

Closed Fund Reserve

Closed fund reserve report (Reservas de Fundos Fechados): one row per reservation in a fund offering.

Field	Type	Description
`nr_conta`	String	BTG account number
`cod_oferta`	String	Code of the fund offering
`vl_oferta`	Number	Amount (BRL) reserved in the offering
`dt_solicitacao`	DateTime	When the reservation was requested
`flag_investflex`	String	Whether the reservation uses InvestFlex (‘Sim’/‘Não’)
`flag_vinculo_pessoa`	String	Whether the investor is a related party of the offering (‘Sim’/‘Não’)
`condicao_oferta`	String	Condition the investor set for the reservation, e.g. placement of the total offering amount
`vl_condicao`	Number	Amount (BRL) tied to the reservation condition
`status_oferta`	String	Status of the offering request, e.g. ‘Solicitada’
`flag_operacao`	String	Whether the reservation generated an operation, as sent by BTG
`tx_motivo`	String	Reason attached to the reservation status, as sent by BTG
`tipo_oferta`	String	Type of the offering, as sent by BTG
`cge_fundo`	String	CGE code of the fund, as sent by BTG
`dt_liquidacao`	DateTime	Settlement date of the offering
`nm_fundo`	String	Name of the fund being offered
`status_reserva`	String	Status of the reservation, e.g. ‘Reserva Aprovada’
`boletim`	String	Status of the subscription form sent to the investor, e.g. ‘Enviado com sucesso’
`id_control`	String	Control identifier of the reservation; its meaning is given by `id_control_desc`
`id_control_desc`	String	What `id_control` identifies, e.g. ‘Id Operação’
`dt_aprovacao`	DateTime	When the reservation was approved

(Standard common report properties are also included in this stream).

Pension Campaign

Pension campaign report (Campanha de Previdência): one row per pension operation in the campaign.

Field	Type	Description
`hash_id`	String	Identifier of the operation in the report
`nr_conta`	String	BTG account number
`certificado`	String	Pension plan certificate at BTG
`certificado_extrno`	String	Pension plan certificate at the external insurer
`operacao`	String	Type of operation, e.g. ‘Portabilidade de Entrada’
`cnpj_fundo`	String	CNPJ of the pension fund
`fundo`	String	Name of the pension fund
`vlr_solicitado`	Number	Amount (BRL) requested in the operation
`vlr_liquidado_total`	Number	Total amount (BRL) settled in the operation
`status`	String	Status of the operation, e.g. ‘Finalizada’
`pontos_btg`	Number	Total BTG Pontos granted by the campaign
`pontos_primeira_parcela`	Number	BTG Pontos of the first installment
`pontos_segunda_parcela`	Number	BTG Pontos of the second installment
`beneficio`	String	Type of benefit granted, e.g. ‘BTG_PONTOS’
`seguradora_externa`	String	External insurer the plan was transferred from
`dt_solicitacao`	Date	Date the operation was requested
`dt_liquidacao`	Date	Date the operation was settled
`elegibilidade`	String	Eligibility classification of the operation, e.g. ‘SEM_ENTRADA_ELEGIVEL’
`motivo_perda_segunda_parcela`	String	Why the second installment was lost, e.g. ‘MOVIMENTOU_APOS_AGOSTO’
`flag_conta_ativa`	String	Whether the account is active (‘Sim’/‘Não’)
`flag_tem_entrada_elegivel`	String	Whether the account has an eligible inflow (‘Sim’/‘Não’)
`flag_valor_minimo_portabilizado`	String	Whether the transferred amount reaches the campaign minimum (‘Sim’/‘Não’)
`flag_saldo_elegivel`	String	Whether the balance is eligible (‘Sim’/‘Não’)
`flag_btg_pontos`	String	Whether the benefit is paid in BTG Pontos (‘Sim’/‘Não’)
`flag_programa_no_prazo`	String	Whether the account joined the program within the deadline (‘Sim’/‘Não’)
`flag_solicitacao_no_prazo`	String	Whether the request was made within the deadline (‘Sim’/‘Não’)
`flag_conclusao_no_prazo`	String	Whether the operation was completed within the deadline (‘Sim’/‘Não’)
`flag_sem_movimentacao_apos_agosto`	String	Whether there was no withdrawal or transfer after August (‘Sim’/‘Não’)
`flag_elegivel_primeira_parcela`	String	Whether the account is eligible for the first installment of the benefit (‘Sim’/‘Não’)
`flag_elegivel_segunda_parcela`	String	Whether the account is eligible for the second installment of the benefit (‘Sim’/‘Não’)
`dt_extracao`	Date	Date BTG extracted the data for the report

(Standard common report properties are also included in this stream).

Subscription

Subscription report (Relatório de Subscrição): one row per account and subscription right.

Field	Type	Description
`nr_conta`	String	BTG account number
`nome_empresa`	String	Name of the company or fund offering the subscription
`titulo_direito`	String	Ticker of the subscription right held by the account, e.g. ‘XPLG12’
`titulo_recebido`	String	Ticker of the security received when the right is exercised, e.g. ‘XPLG13’
`quantidade_atual`	Number	Quantity of the underlying security currently held by the account
`disponivel_a_vista`	Number	Quantity of rights available to be exercised on the spot market
`perc_direito`	Number	Subscription ratio: rights granted per security held
`disponivel_btc`	Number	Quantity available under securities lending (BTC)
`solicitado_a_vista`	Number	Quantity already requested for subscription on the spot market
`preco_emissao`	Number	Issue price (BRL) of each subscribed security
`saldo_atual`	Number	Current cash balance (BRL) of the account
`valor_direito`	Number	Amount (BRL) needed to exercise the available rights
`saldo_final`	Number	Cash balance (BRL) of the account after exercising the rights
`dt_limite_para_subscricao`	Date	Last day to exercise the subscription right

(Standard common report properties are also included in this stream).

Trade Idea

Trade idea report (Recomendação de Operação): fixed income positions with premium/discount and a recommended operation, one row per position and recommendation.

Field	Type	Description
`nr_conta`	String	BTG account number
`tipo`	String	Type of the fixed income asset held, e.g. ‘CRA, CRI’
`emissor`	String	Issuer of the asset held
`ativo`	String	Code of the asset held
`indexador`	String	Index of the asset held, e.g. ‘100% CDI+‘
`taxa_compra`	Number	Rate at which the asset was bought
`dt_emissao`	Date	Issue date of the asset
`dt_aquisicao`	Date	Date the account acquired the asset
`dt_vencimento`	Date	Maturity date of the asset
`quantidade`	Number	Quantity of the asset held
`vl_pu_custo`	Number	Unit cost (BRL) of the asset
`vl_total_custo`	Number	Total cost (BRL) of the position
`vl_pu_curva`	Number	Unit value (BRL) of the asset on the yield curve
`vl_total_curva`	Number	Total value (BRL) of the position on the yield curve
`vl_pu_mercado`	Number	Unit market value (BRL) of the asset
`vl_total_mercado`	Number	Total market value (BRL) of the position
`tipo_cotacao`	String	Source of the market quote, e.g. ‘Cotação Anbima’
`taxa_mercado`	Number	Current market rate of the asset
`duration`	Number	Duration of the asset
`agio_desagio`	String	Whether the position trades at a premium (‘Ágio’) or a discount (‘Deságio’)
`vl_agio_desagio`	Number	Premium (positive) or discount (negative) amount (BRL) of the position
`percent_agio_desagio`	Number	Premium or discount as a percentage of the position
`vl_acumulado_proventos`	Number	Accumulated income (BRL) paid by the asset
`vl_carrego_cdi`	Number	Amount (BRL) the position would earn if held to maturity at CDI
`rentabilidade`	Number	Profitability (BRL) of the position
`percent_rentabilidade`	Number	Profitability of the position as a percentage
`percent_carrego_cdi`	Number	Carry of the position as a percentage of CDI
`carrego_acima_cdi`	String	Whether the carry of the position is above CDI (‘Sim’/‘Não’)
`id`	String	Identifier of the position in the report
`write_timestamp`	DateTime	When BTG wrote the row
`tipo_recomendacao`	String	Type of recommended operation, e.g. ‘Troca’
`oferta_recomendacao`	String	Type of asset recommended, e.g. ‘CRI’
`emissor_recomendacao`	String	Issuer of the recommended asset
`indexador_recomendacao`	String	Index of the recommended asset, e.g. ‘CDI’
`taxa_indexador_recomendacao`	Number	Percentage of the index paid by the recommended asset
`taxa_adicional_recomendacao`	Number	Additional rate paid by the recommended asset on top of the index
`vencimento_recomendacao`	String	Maturity of the recommended asset, as sent by BTG (the example has a day count, e.g. ‘1825’)
`roa_indicativa`	Number	Indicative return on assets of the recommended operation
`receita_indicativa`	Number	Indicative revenue (BRL) of the recommended operation
`last_updated`	DateTime	When the recommendation was last updated
`estimated_recovery`	Number	Estimated recovery (BRL) of the recommended operation
`carrego_proventos_cdi`	Number	Carry of the accumulated income relative to CDI
`percentual_carrego_sem_carrego_proventos`	Number	Carry of the position as a percentage, excluding the carry of the accumulated income
`percentual_sem_carrego_proventos`	Number	Profitability of the position as a percentage, excluding the carry of the accumulated income
`rentabilidade_sem_carrego_proventos`	Number	Profitability (BRL) of the position, excluding the carry of the accumulated income
`is_stvm`	String	Whether the asset is held in custody at BTG’s broker-dealer (STVM), as sent by BTG
`vl_carrego_ipca`	Number	Amount (BRL) the position would earn if held to maturity at IPCA
`percent_carrego_ipca`	Number	Carry of the position as a percentage of IPCA
`carrego_acima_ipca`	String	Whether the carry of the position is above IPCA (‘Sim’/‘Não’)

(Standard common report properties are also included in this stream).

Implementation Notes

Primary Keys: The connector safely handles records with missing composite primary key fields by generating a reliable hash ID (record_id). This ensures data integrity and prevents pipeline failures when the source API omits certain fields for specific reports.
Report Parsing and Delimiter Detection: To prevent row loss caused by HTTP streaming chunk issues, report files are fully downloaded to a temporary location before being parsed. The connector dynamically detects the appropriate CSV delimiter (, or ;) based on the report header to safely adapt to varying BTG formatting standards. Additionally, the connector safely folds surplus column values back into expected free-text columns when BTG’s source contains unquoted delimiters that split them unexpectedly, ensuring columns stay perfectly aligned.

Skills for agents

Download BTG Parceiros skills file

BTG Parceiros connector documentation as plain markdown, for use in AI agent contexts.

Get started

Context

Activate

Workspace

Resources

BTG Parceiros as a data source

Configuring BTG Parceiros as a Source

1. Add account access

2. Select streams

3. Configure data streams

4. Configure data source

5. Check your new source

Streams and Fields

Available streams

Fields by stream

Implementation Notes

Skills for agents

Download BTG Parceiros skills file

​Configuring BTG Parceiros as a Source

​1. Add account access

​2. Select streams

​3. Configure data streams

​4. Configure data source

​5. Check your new source

​Streams and Fields

​Available streams

​Fields by stream

​Implementation Notes

​Skills for agents

Download BTG Parceiros skills file

Configuring BTG Parceiros as a Source

1. Add account access

2. Select streams

3. Configure data streams

4. Configure data source

5. Check your new source

Streams and Fields

Available streams

Fields by stream

Implementation Notes

Skills for agents