What do I need before connecting Stripe to IBM Cognos Analytics?

Review the Stripe source page, have your Stripe account details ready, and decide which business questions you want to answer first, such as payment health, subscription revenue, or dispute follow-up. In Kondado, add Stripe as a data source, choose the matching pipelines, and set IBM Cognos Analytics as the destination. This planning keeps your first IBM Cognos Analytics dashboard focused on the KPIs your team will use.

Which dashboards can I build with Stripe data in IBM Cognos Analytics?

You can build custom dashboards for payment volume, refunds, failed charges, subscription revenue, dispute status, payout timing, and customer activity. For example, combine Charges and Payment intents to monitor payment health, or use Subscriptions and Invoices to review recurring revenue. IBM Cognos Analytics lets you arrange these views for finance, operations, and marketing teams.

How often does Kondado update Stripe data in IBM Cognos Analytics?

You choose the update frequency in Kondado, with options such as every 5 minutes, every 15 minutes, hourly, or daily. The schedule controls how often Stripe data is replicated into IBM Cognos Analytics, so reports reflect updated data at the cadence you set. You can adjust the frequency as your reporting needs change.

Which Stripe KPIs should I track in IBM Cognos Analytics?

Common KPIs include gross payment volume, net revenue after refunds, failed payment rate, refund rate, subscription churn signals, dispute count, average invoice value, and payout timing. You can calculate these from pipelines such as Charges, Refunds, Subscriptions, Invoices, and Payouts. Build a dashboard that groups the KPIs by customer segment, product, or period so teams can act on trends.

Can I share IBM Cognos Analytics dashboards built from Stripe data?

Yes, you can share IBM Cognos Analytics dashboards with colleagues who need payment, finance, or customer insights. You can also export summary views to Google Sheets for teams that work in spreadsheets. Share the views that match each team's role, such as finance, operations, or marketing.

Do I need technical skills to visualize Stripe data in IBM Cognos Analytics?

No, Kondado is designed for business users, marketing teams, and operations teams. You select the Stripe pipelines you want and set IBM Cognos Analytics as the destination, then build dashboards with familiar drag-and-drop tools in IBM Cognos Analytics. No code is required for the Kondado setup.

What Stripe pipelines are available for IBM Cognos Analytics dashboards?

Kondado offers 51 Stripe pipelines and 1,971 fields, covering areas such as Charges, Payment intents, Customers, Subscriptions, Invoices, Disputes, Payouts, Products, Coupons, and Checkout sessions. You can choose the pipelines that match your questions and combine them in IBM Cognos Analytics for a complete payment view. Start with the metrics you need most, then add more pipelines as your reporting grows.

Kondado: Connect Stripe to IBM Cognos Analytics: Dashboards in Minutes

Subscription schedules

Registry of subscription schedules, with id, customer, subscription, status, creation, cancellation, completion and release dates, current phase, billing mode, default settings, end behavior, and live-mode flag.

Early fraud warnings

Record of early fraud warnings, with id, actionable flag, related charge and PaymentIntent, creation timestamp, fraud type, and live/test mode.

Tax rates

Tax rate record with identifier, active status, country, state and jurisdiction, display name, percentage and effective percentage, flat amount and currency, inclusive flag, rate type and tax type, creation timestamp, and live mode.

Subscriptions

Subscription record with identifier, customer, status, collection method, currency, billing cycle and anchor, creation, start, cancellation and end dates, fee amounts and percentages, discounts, thresholds, invoice and trial settings, plus schedule and pending updates.

Subscriptions - Details - Subscription items

Subscription items, with id, associated subscription and price, quantity, billing and trial periods, usage thresholds, and price attributes such as currency, unit amount, recurring interval, and usage type.

Customers

Stripe customer records, with identifier, name/business, email, address, balance and currency, invoice settings, tax data, shipping, discount, cash balance, and creation timestamp.

Customers - Details - Tax IDs

Registry of each customer's tax IDs (CNPJ, CPF, VAT, etc.), with country, type, value, verification status, creation timestamp, and customer, account, and owner references.

Customers - Details - Payment methods

Payment methods linked to customers, with identifiers, billing details, card details (brand, expiry, last four digits, checks), bank accounts, and digital wallets.

Customers - Details - Customer balance transactions

Each row is a customer credit balance transaction, with id, customer_id, amount, ending_balance, currency, type, created, description, livemode, and related IDs for checkout_session, credit_note, customer, customer_account, and invoice.

Charges

Stripe charge records with id, amount, captured and refunded amounts, currency, creation date, status, paid/captured/refunded/disputed flags, customer, PaymentIntent, payment method, balance transaction, risk outcome, and billing/shipping details.

Billing credit grants

Registry of billing credit grants issued to customers for consumption-based billing, with id, customer/account, monetary amount and currency, type, category, priority, price scope, effective/expiration/void timestamps, live/test mode, and creation/update timestamps.

Connected accounts (Connect)

Registry of connected accounts (Connect), with identifier, business profile (name, MCC, type, estimated annual and monthly revenue, estimated worker count), support details, and payment capability statuses.

Disputes

Stripe dispute records, with id, disputed amount, currency, related charge and PaymentIntent, reason, status, creation and evidence due dates, plus evidence and eligibility details.

Coupons

Registry of discount coupons, with identifier, name, amount or percentage off, currency, duration and duration in months, redemption limits and count, redemption deadline, validity status, livemode flag, and creation timestamp.

Promotion codes

Registry of promotion codes customers enter to apply a coupon, with identifier, code, active status, customer, expiration, redemption limits and count, promotion type, and minimum-amount and first-transaction restrictions.

Events

Record of Stripe account events, with id, account, API version, context, creation time, livemode, pending webhooks, request details, event type, and the affected object's id and type.

Invoices

Registry of invoices, with identifier, customer, currency, amounts due/paid/remaining, creation and due dates, collection method, billing reason, and automatic tax status.

Invoices - Details - Invoice line items

Each row represents a Stripe invoice line item, with invoice, subscription, and parent identifiers, plus amount, subtotal, currency, quantity/quantity_decimal, period_start/period_end, description, discountable, livemode, parent_type, and pricing details (price, product, pricing_type).

Entitlement features

Registry of features that can be granted to customers by product, with unique identifier, active status, live-mode flag, lookup key, and name.

Setup intents

Each row records a SetupIntent, with id, customer, status, usage, created, payment_method, cancellation_reason, last_setup_error fields, automatic_payment_methods, mandate, latest_attempt, and livemode.

Payment intents

Payment intent records, with id, amount and amount received, currency, status, creation date, customer, payment method, capture and confirmation method, cancellation reason, latest charge, and transfer data.

Invoice items

Record of an invoice item, with id, amount and currency, linked customer and invoice, date, description, quantity, discount and proration flags, period, and pricing/subscription details.

Payment links

Registry of payment links, with identifier, active status, URL, currency, post-purchase behavior, tax, invoice, PaymentIntent, subscription, application fee, transfer amount, and session restriction settings.

Payment links - Details - Line items

Line items of payment links, with payment_link_id, id, quantity, description, currency, discount, subtotal, tax and total amounts, plus price data (id, type, billing scheme, recurring interval and unit amount) and adjustable quantity limits.

Radar value lists

Each row represents a Radar value list, with id, alias, name, item type, creator, creation timestamp, and live mode indicator.

Radar value lists - Details - Items

Item in a Radar value list, with its own and parent list identifiers, value, creation timestamp, creator, and live-mode indicator.

Billing meters

Registration of usage billing meters for consumption-based billing, with id, display_name, event_name, default_aggregation_formula, customer_mapping_type, event_time_window, status, livemode, and creation, update, and deactivation timestamps.

Credit notes

Credit notes issued or voided, with identifier, customer, invoice, status, reason, currency, amounts (subtotal, total, tax, shipping and payment amounts), creation/effective/void dates, and PDF link.

Credit notes - Details - Line items

Each row represents a credit note line item, with credit note and item IDs, amount, description, discount amount, linked invoice line item, livemode flag, quantity, type, and unit amounts.

Quotes

Record of quotes with id, status, customer, invoice and subscription, currency, subtotal/total amounts and computed recurring and upfront totals, discount, shipping and tax details, creation/expiration/status-transition dates, and invoice and subscription settings.

Quotes - Details - Line items

Each row represents a quote line item, with quote_id and id, description, quantity, currency, discount, subtotal, tax, and total amounts, plus price details (id, type, unit amount, recurrence, product) and adjustable quantity limits.

Invoice payments

Payments applied to invoices, with id, related invoice, paid and requested amounts, currency, status, payment type and originating payment references, default flag, livemode, and creation, payment, and cancellation timestamps.

Plans

Registry of recurring price plans, with id, active status, amount and currency, billing scheme, interval and interval count, product, nickname, tiers mode, usage type, trial days, meter, usage transformation, creation timestamp, and live/test mode.

Prices

Registry of product prices (one-time or recurring), with id, active status, currency, unit amount, billing scheme, recurring interval, associated product, and tier and tax settings.

Products

Stripe catalog product record, with identifier, name, description, active status, default price, package dimensions, tax code, unit label, URL, and creation and update timestamps.

Top-ups

Record of each balance top-up, with id, amount and currency, status, creation time, balance transaction, payment method, initiator, failure code/message, expected availability date, description, statement descriptor, source ID, and transfer group.

Refunds

Each row represents a Stripe refund, with id, amount, currency, status, reason, creation date, links to charge, customer, and PaymentIntent, plus balance transaction, destination, failure/pending, and presentment details.

Payouts

Each row is a payout, with id, amount, currency, status, creation and arrival dates, method, destination, balance transaction, failure code/message, and reversal references.

Payouts - Details - Payout transactions

Each row is a balance transaction linked to a payout, with identifier, gross amount, fee, net amount, currency, status, type, reporting category, availability and creation dates, source, and exchange rate.

Radar reviews

Each row represents a Radar review, with its identifier, associated charge and PaymentIntent, open/closed status and reasons, creation timestamp, IP and location data, session details, and live-mode flag.

Current balance

Current Stripe account balance per balance type and currency, with amount, portions from cards, bank accounts, and FPX, production/test mode flag, and read timestamp.

Checkout sessions

Checkout sessions, with unique id, creation and expiration timestamps, currency, subtotal and total amounts, customer, invoice, and PaymentIntent references, plus address, tax, branding, and consent data.

Checkout sessions - Details - Line items

Line items of a checkout session, with session and item identifiers, quantity, description, currency, discount, subtotal, tax and total amounts, plus price details such as product, type, recurrence, tax behavior and unit amount.

Identity verification sessions

Each row represents an identity verification session, with id, client_reference_id, created, status, type, livemode, document/email/phone and matching options, provided details, latest error, redaction_status, related customer/person, verification_flow, and verified outputs (address, date of birth, email, name, ID number, phone, and sex).

Shipping rates

Each row represents a shipping rate, with id, active status, creation time, display name, delivery estimate minimum/maximum unit and value, fixed amount and currency, livemode, tax behavior, tax code, and calculation type.

Application fees

Each row represents a Stripe application fee, with its identifier, account, application, related charge and balance transaction, amount and amount refunded, currency, creation time, fee source, live mode, and full-refund indicator.

Terminal readers

Registry of terminal readers, with id, label, serial number, device type and software version, IP address, location, network status, last seen, livemode, and action details such as type, status, API errors, refund, display, print, and processing configurations.

Terminal locations

Registry of physical locations for Stripe Terminal readers, with id, address (including kana/kanji variants), display name, configuration override, phone, and live-mode flag.

Balance transactions

Each row is a Stripe balance transaction, with id, gross amount, fee, net impact, currency, exchange rate, creation and availability dates, balance type, reporting category, source, status, and transaction type.

Transfers

Stripe transfer record with identifier, amount and reversed amount, balance transaction, creation timestamp, currency, description, destination account, destination payment, live mode, reversal status, source charge, source type, and transfer group.

Transfers - Details - Reversals

Transfer reversals, with id, reversed transfer, amount, currency, creation timestamp, balance transaction, and linked source/destination payment refunds.