Configuring Nomus as a Source
In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the Nomus option from the list of connectors. Click Next and you’ll be prompted to add your access.1. Add account access
You need two things from your Nomus system:- Nomus URL: the address you open Nomus with, for example
https://yourcompany.nomus.com.br/yourcompany. You can also type only your company identifier (yourcompany). If your Nomus is installed outside nomus.com.br, use its full https address. - Integration Key: the REST integration key of your Nomus (“Chave de integração REST”). A Nomus administrator finds it in the general system configuration (“Configurações gerais do sistema”). Paste it exactly as Nomus shows it.
- Start Date: the earliest creation or change date read by the incremental tables (see the list below) on the first sync and on full syncs. The other tables are always read whole.
- Re-read Window (days): sales orders issued in the last N days are read again on every sync, so item statuses that change when an order is invoiced stay up to date. When the option below is on, accounts receivable and payable due from N days ago on are re-read too. Default: 30. Use 0 to turn it off.
- Re-read Open Receivables and Payables: on by default. Every sync reads again all accounts receivable and payable due from Re-read Window days ago on, including every title due in the future, so a payment that Nomus records without updating the title’s change date still shows up. With many open titles this is the heaviest part of a sync (receivables can also carry the bank slip PDF, which Nomus always sends and the connector discards). Turn it off to make syncs lighter and rely on the weekly Additional Full Sync to catch those payments.
2. Select streams
Choose which data streams you want to sync. For faster extractions, select only the streams that are relevant to your analysis. You can select entire groups of streams or pick specific ones.Tip: The stream can be found more easily by typing its name.Product Suppliers and Stock Balances are not selected by default: they make one request per product, which can take long on large catalogs. Select them if you need them. 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: Sales Orders, Sales Order Items, NF-e Invoices, Accounts Receivable, Accounts Payable, Payments, Receipts, Customers and Products can be Incremental: each sync reads only what was created or changed since the previous one. Every other stream is Full table: each sync reads the whole list from Nomus and replaces the table.
4. Configure data source
Describe your data source for easy identification within your organization, not exceeding 140 characters. 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 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. We recommend an Additional Full Sync once a week for the incremental tables: it removes rows deleted in Nomus (for example items removed from an order) and catches changes Nomus did not mark (see Data Quality Considerations). Once you are ready, click Next to finalize the setup.5. Check your new source
You can view your new source on the Sources page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.Streams and Fields
Available streams
The table below lists every stream, its slug (the exact identifier to pass when creating the source via API), its sync type and a short description.Fields by stream
Accounts Payable
Accounts Payable
contasPagar.Table: accounts_payable · Primary key: id · Sync: Incremental (by ultima_alteracao)Accounts Receivable
Accounts Receivable
contasReceber.Table: accounts_receivable · Primary key: id · Sync: Incremental (by ultima_alteracao)Activities
Activities
atividades.Table: activities · Primary key: id · Sync: Full tableBank Accounts
Bank Accounts
contasBancarias.Table: bank_accounts · Primary key: id · Sync: Full tableBank Slips
Bank Slips
boletos.Table: bank_slips · Primary key: id · Sync: Full tableBill of Materials Components
Bill of Materials Components
componentesListaMateriais.Table: bill_of_materials_components · Primary key: id · Sync: Full tableBills of Materials
Bills of Materials
listasMateriais.Table: bills_of_materials · Primary key: id · Sync: Full tableCompanies
Companies
empresas.Table: companies · Primary key: id · Sync: Full tableContacts
Contacts
contatos.Table: contacts · Primary key: id · Sync: Full tableCost Centers
Cost Centers
centrosCusto.Table: cost_centers · Primary key: id · Sync: Full tableCustom Fields
Custom Fields
camposPersonalizados.Table: custom_fields · Primary key: id · Sync: Full tableCustomer Credit Notes
Customer Credit Notes
notasCreditoCliente.Table: customer_credit_notes · Primary key: id · Sync: Full tableCustomers
Customers
clientes.Table: customers · Primary key: id · Sync: Incremental (by ultima_alteracao)Delivery Routes
Delivery Routes
rotas.Table: delivery_routes · Primary key: id · Sync: Full tableEmployees
Employees
funcionarios.Table: employees · Primary key: id · Sync: Full tableInspection Results
Inspection Results
resultadosInspecao.Table: inspection_results · Primary key: id · Sync: Full tableInventories
Inventories
inventarios/listar.Table: inventories · Primary key: id · Sync: Full tableLots and Series
Lots and Series
lotesSerie.Table: lots_series · Primary key: id · Sync: Full tableMaterial Allocations
Material Allocations
empenhos.Table: material_allocations · Primary key: id_empenho · Sync: Full tableMovement Types
Movement Types
tiposMovimentacao.Table: movement_types · Primary key: codigo · Sync: Full tableNF-e Invoices
NF-e Invoices
nfes.Table: invoices · Primary key: id · Sync: Incremental (by ultima_alteracao)NFS-e Service Invoices
NFS-e Service Invoices
nfses.Table: service_invoices · Primary key: id · Sync: Full tableOutgoing Document Items
Outgoing Document Items
itensDocumentoSaida.Table: outgoing_document_items · Primary key: id · Sync: Full tablePayment Methods
Payment Methods
formasPagamento.Table: payment_methods · Primary key: id · Sync: Full tablePayment Terms
Payment Terms
condicoesPagamentos.Table: payment_terms · Primary key: id · Sync: Full tablePayments
Payments
pagamentos.Table: payments · Primary key: id · Sync: Incremental (by ultima_alteracao)People
People
pessoas.Table: people · Primary key: id · Sync: Full tablePerson Attributes
Person Attributes
atributosPessoa.Table: person_attributes · Primary key: id · Sync: Full tablePhones
Phones
telefones.Table: phones · Primary key: id · Sync: Full tablePrice Table Items
Price Table Items
tabelasPreco/ID/itens per record of tabelasPreco.Table: price_table_items · Primary key: id_tabela_preco, id_produto · Sync: Full tablePrice Tables
Price Tables
tabelasPreco.Table: price_tables · Primary key: id · Sync: Full tableProblem Causes
Problem Causes
causasProblemas.Table: problem_causes · Primary key: id · Sync: Full tableProcesses
Processes
processos.Table: processes · Primary key: id · Sync: Full tableProduct Attributes
Product Attributes
atributosProduto.Table: product_attributes · Primary key: id · Sync: Full tableProduct Families
Product Families
familiasProduto.Table: product_families · Primary key: id · Sync: Full tableProduct Groups
Product Groups
gruposProduto.Table: product_groups · Primary key: id · Sync: Full tableProduct Routing Operations
Product Routing Operations
operacoesRoteiroProduto.Table: product_routing_operations · Primary key: id · Sync: Full tableProduct Routings
Product Routings
roteirosProduto.Table: product_routings · Primary key: id · Sync: Full tableProduct Suppliers
Product Suppliers
fornecedoresProduto/ID per record of produtos.Table: product_suppliers · Primary key: id_produto, id_fornecedor · Sync: Full tableProduct Types
Product Types
tiposProduto.Table: product_types · Primary key: id · Sync: Full tableProduction Order Operations
Production Order Operations
operacoesRoteiroOrdem.Table: production_order_operations · Primary key: id · Sync: Full tableProduction Orders
Production Orders
ordens.Table: production_orders · Primary key: id · Sync: Full tableProduction Reports
Production Reports
apontamentos.Table: production_time_entries · Primary key: id · Sync: Full tableProducts
Products
produtos.Table: products · Primary key: id · Sync: Incremental (by ultima_alteracao)Proposal Items
Proposal Items
itensProposta list of each record of propostas.Table: proposal_items · Primary key: id · Sync: Full tableProposals
Proposals
propostas.Table: proposals · Primary key: id · Sync: Full tablePurchase Order Items
Purchase Order Items
itensPedidoCompra list of each record of pedidoscompra.Table: purchase_order_items · Primary key: id_pedido_compra, item · Sync: Full tablePurchase Orders
Purchase Orders
pedidoscompra.Table: purchase_orders · Primary key: id · Sync: Full tablePurchase Requests
Purchase Requests
solicitacoesCompras.Table: purchase_requests · Primary key: codigo · Sync: Full tableQuote Requests
Quote Requests
solicitacoes.Table: quote_requests · Primary key: id · Sync: Full tableReceipts
Receipts
recebimentos.Table: receipts · Primary key: id · Sync: Incremental (by ultima_alteracao)Received NF-e (Destinadas)
Received NF-e (Destinadas)
nfesDestinadas.Table: received_invoices · Primary key: id · Sync: Full tableResources
Resources
recursos.Table: resources · Primary key: id · Sync: Full tableSales Order Items
Sales Order Items
itensPedido list of each record of pedidos.Table: sales_order_items · Primary key: id · Sync: Incremental (by ultima_alteracao)Sales Orders
Sales Orders
pedidos.Table: sales_orders · Primary key: id · Sync: Incremental (by ultima_alteracao)Sales Representatives
Sales Representatives
representantes.Table: sales_representatives · Primary key: id · Sync: Full tableSellers
Sellers
vendedores.Table: sellers · Primary key: id · Sync: Full tableService Contracts
Service Contracts
contratosServico.Table: service_contracts · Primary key: id · Sync: Full tableService Sale Documents
Service Sale Documents
documentosVendaServico.Table: service_sale_documents · Primary key: id · Sync: Full tableStock Balances
Stock Balances
saldosEstoqueProduto/ID per record of produtos.Table: stock_balances · Primary key: id_produto, id_empresa · Sync: Full tableStock Document Items
Stock Document Items
itensDocumentoEstoque list of each record of documentosEstoque.Table: stock_document_items · Primary key: id · Sync: Full tableStock Documents
Stock Documents
documentosEstoque.Table: stock_documents · Primary key: id · Sync: Full tableStock Movements
Stock Movements
movimentacoesEstoque.Table: stock_movements · Primary key: codigo, discriminador · Sync: Full tableStock Sectors
Stock Sectors
setorEstoque.Table: stock_sectors · Primary key: id · Sync: Full tableSupplier Credit Notes
Supplier Credit Notes
notasCreditoFornecedor.Table: supplier_credit_notes · Primary key: id · Sync: Full tableUnits of Measure
Units of Measure
unidadesMedida.Table: units_of_measure · Primary key: id · Sync: Full tableUser Groups
User Groups
grupoUsuarios.Table: user_groups · Primary key: id · Sync: Full tableUsers
Users
usuarios.Table: users · Primary key: id · Sync: Full tableWork Centers
Work Centers
centrosTrabalho.Table: work_centers · Primary key: id · Sync: Full tableImplementation Notes
Data Quality Considerations
- Column names follow Nomus. Field names are the Nomus API names in snake_case (
idPessoaClientebecomesid_pessoa_cliente); each field’s description says the original name. Every table also has anextra_fieldscolumn (JSON) with any field Nomus sent that has no column of its own, so nothing is dropped. - Numbers and dates are converted. Nomus sends amounts as text, sometimes formatted in Brazilian Portuguese (
1.068,33) and sometimes as plain decimals (5.000000). The connector converts both to exact numbers. A value with a single dot followed by exactly three digits and no comma (1.500) can mean one thousand five hundred or one and a half: it is read as thousands only in the columns that Nomus formats for display (amounts, prices, quantities and percentages of orders and their items, proposals, purchase order items, stock documents and movements, lots, receivables, payables, payments, receipts, bank slips, credit notes, price tables, stock balances, bills of materials, production orders and their operations, production reports and purchase requests). In any other column such a value is left empty, kept as sent inextra_fields, and the sync log says how many values were affected. Dates (13/10/2026 16:21:55, always day first) become ISO dates and times in Brasília time (2026-10-13T16:21:55-03:00). Any other value that cannot be converted is also left empty and kept as sent inextra_fields. - How incremental tables work. Each sync reads the records created and the records changed since one day before the previous sync, and
ultima_alteracao(the later of the creation and change dates) tracks progress. Receipts have no change date in Nomus, so only new receipts are read incrementally. A record that changes without Nomus updating its change date is only seen again on a full sync; this is why Sales Orders re-read the orders issued in the last 30 days and Accounts Receivable and Payable re-read the titles due from 30 days ago on, future ones included (both configurable; the second one can be turned off), and why a weekly Additional Full Sync is recommended. - Rows deleted in Nomus stay in incremental tables. An incremental sync only adds and updates rows. A record deleted in Nomus, or an item removed from a sales order, is never sent again, so its last version stays in the table (for example in Sales Order Items) until a full sync rewrites it. The weekly Additional Full Sync takes care of this.
- A table is never half updated. The connector reads all the data of a table before writing any of it. If Nomus fails or refuses part of a table, the connector sends nothing for that table and the sync shows it as failed. On BigQuery (GCP and Nekt Express) the table then keeps its previous content. On AWS, a Full table stream that ends a sync without data can be written as an empty table; if that happens, run the sync again once Nomus answers.
- A table that suddenly comes back empty is not sent. If Nomus returns no rows for a Full table stream that had rows in the previous sync, the sync fails for that table instead of sending an empty table. On BigQuery the table keeps its rows; on AWS the same caveat as above applies. If the data really was removed in Nomus, run a full sync of the source to accept the empty table.
- Records deleted during a sync. Nomus lists are read page by page. If a record is deleted in Nomus while a list is being read, the record right after it can be skipped by that read. For the incremental tables, any read that spans more than one page is done twice and combined, so nothing is lost. A Full table stream can miss that record in that sync and gets it back on the next one.
- Items have their own tables. Sales Order Items, Proposal Items, Purchase Order Items and Stock Document Items have one row per item; the parent tables also keep the items as JSON.
- Time zone. Nomus does not say which time zone its dates are in; they are read as Brasília time. If your Nomus runs in another time zone, the times are shifted by the difference, but no record is missed.
API Limits & Performance
- Nomus limits how many requests an integration may send. When the limit is reached, Nomus tells how long to wait; the connector waits that long and the sync log says the sync is slower because of it. Other integrations using your Nomus count toward the same limit.
- The connector sends one request at a time. Lists come in pages, so large tables (stock movements, outgoing document items) can take a while on the first sync.
- Product Suppliers and Stock Balances make one request per product; Price Table Items, one per price table (more when a table has more items than fit in one page).
- On the first sync, incremental tables with many records are read twice (see Records deleted during a sync), so the first sync takes longer than the next ones. The re-read of recent orders and open titles is read once.
- Accounts Receivable is usually the heaviest table: Nomus sends the bank slip PDF inside each title that has one (there is no option to leave it out; the connector discards it), and with Re-read Open Receivables and Payables on, every open title is read again on every sync. If syncs take too long, turn that option off.