How do I automatically send Pagar.me transaction data to Redshift without writing code?

Kondado provides a direct integration that connects your Pagar.me account to Redshift through an intuitive interface. You authenticate your Pagar.me credentials, enter your Redshift connection details, and select which pipelines to replicate. The platform handles the data extraction and loading automatically on your configured schedule.

What specific payment data from Pagar.me gets replicated to Redshift?

Kondado offers eight distinct pipelines including Customers, Charges, Orders, Receivables, Balance Operations, and Recipients, totaling 344 available fields. This covers transaction amounts, payment statuses, customer contact information, card details, and outstanding receivables with due dates. You can select specific pipelines based on your analytical requirements rather than replicating all data.

How frequently can I schedule Pagar.me data updates in my Redshift warehouse?

Kondado supports configurable update intervals ranging from every 5 minutes to daily, depending on your business needs and data freshness requirements. You can set different schedules for different pipelines, updating critical transaction data every 15 minutes while refreshing customer reference data hourly. This flexibility ensures your Redshift analytics reflect current payment activity without overwhelming your warehouse resources.

Can I merge Pagar.me customer data with other sources in Redshift?

Yes, Kondado enables you to combine Pagar.me data with sources like BigQuery , PostgreSQL , or Google Sheets within the same Redshift environment. By replicating customer and transaction data alongside marketing campaign information from other platforms, you can build comprehensive SQL queries that analyze customer lifetime value and attribution. This unified approach eliminates data silos and provides complete visibility into the customer journey.

What schema format does Pagar.me data use when stored in Redshift?

Kondado maintains the original Pagar.me API structure when loading data into your Redshift cluster, preserving field names and data types for consistency. Each pipeline creates separate structures with columns corresponding to the 344 available fields such as customer emails, charge amounts, and order statuses. The data arrives ready for SQL querying and can be joined with existing business data in your warehouse.

Is it possible to replicate both Pagar.me charges and receivables to the same Redshift database?

Absolutely, you can enable both the Charges and Receivables pipelines simultaneously to track completed transactions alongside future expected payments. This combination allows finance teams to monitor current cash position while forecasting incoming revenue streams through unified SQL queries. The data loads into separate but related structures that support comprehensive financial reporting and cash flow analysis.

How do I connect my existing AWS Redshift cluster to Pagar.me using Kondado?

In your Kondado dashboard, add Redshift as your destination by providing your cluster endpoint, database name, username, and password credentials. Then select Pagar.me as your data source and authenticate with your API keys to establish the connection. Once both endpoints are configured, you can map specific pipelines and set your preferred update schedule to begin automated replication.

Send data from Pagar.me to Redshift

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Send Pagar.me Data to Redshift Automatically

Kondado provides a direct integration between Pagar.me and Amazon Redshift, allowing you to replicate payment data without writing code. Simply connect your Pagar.me account as a data source, configure your Redshift cluster as the destination, and select which pipelines you want to replicate. The platform handles the data transfer automatically on your chosen schedule, ensuring your data warehouse always contains fresh transaction information for comprehensive financial analysis and business intelligence reporting.

Kondado replicates Pagar.me data to Redshift on a configurable schedule, supporting eight distinct pipelines including Customers, Charges, Orders, and Receivables, with 344 total fields available for analysis.

Once configured, Kondado maintains your Redshift environment with automated updates every 5 minutes, 15 minutes, hourly, or daily based on your business requirements. This enables analysts to build custom reports tracking payment conversion rates, monitor cash flow through balance operations, and analyze customer purchasing patterns directly within their existing data warehouse. Teams can eliminate manual CSV exports and focus on deriving actionable insights from unified payment data.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

With Kondado, you can replicate the Customers pipeline to segment your buyer base by location and contact information, while the Charges pipeline delivers detailed transaction records including amounts, dates, and status updates directly into your Redshift cluster. The Receivables pipeline provides outstanding payment data with due dates and amounts, enabling cash flow forecasting and financial planning when combined with Balance Operations data. These pipelines empower analysts to create SQL queries that track revenue trends, identify at-risk payments, and generate automated financial reports without leaving their Redshift environment.

Try out all the features for free for 14 days

Pagar.me data available for Redshift

available pipelines

344

extractable fields

Available integrations

Integration	Description
Customers	Includes information such as customer name, email, and status, along with address and phone data like area code and number.
Customers: Cards	Records card details including brand, expiration date, and status, along with cardholder name and card digits.
Customers: Addresses	Contains address data such as city, state, and country, along with creation date and address status.
Charges	Includes information on charges made, such as amount, date, and status, along with details of the associated customer.
Balance Operations	Records operations related to balance, including operation type, amount, and transaction date.
Orders	Contains details of orders placed, such as total amount, status, and creation date, along with customer information.
Recipients	Includes information about recipients, such as name, document, and status, along with creation and update data.
Receivables	Contains information about receivables, including amount, due date, and status, along with details of the associated customer.

Customers

Includes information such as customer name, email, and status, along with address and phone data like area code and number.

Customers: Cards

Records card details including brand, expiration date, and status, along with cardholder name and card digits.

Customers: Addresses

Contains address data such as city, state, and country, along with creation date and address status.

Charges

Includes information on charges made, such as amount, date, and status, along with details of the associated customer.

Balance Operations

Records operations related to balance, including operation type, amount, and transaction date.

Orders

Contains details of orders placed, such as total amount, status, and creation date, along with customer information.

Recipients

Includes information about recipients, such as name, document, and status, along with creation and update data.

Receivables

Contains information about receivables, including amount, due date, and status, along with details of the associated customer.

See all available data →

Try out all the features for free for 14 days

How to send Pagar.me data to Redshift

Sync data automatically — no code, no manual exports.

Connect Your Pagar.me Account

Add Pagar.me as a data source in your Kondado dashboard by entering your API credentials to authenticate your account. This establishes the connection to your payment data without requiring any custom code or technical configuration.

Configure Redshift Destination

Enter your AWS Redshift cluster connection details including the endpoint, database name, and credentials to set up your data warehouse destination. Kondado supports standard Redshift authentication and connects directly to your existing cluster without additional infrastructure.

Select Pipelines and Schedule

Choose which Pagar.me pipelines to replicate, such as Customers, Charges, or Orders, and set your preferred update frequency from 5 minutes to daily. You can also route this same data to Power BI, Looker Studio, or Google Sheets simultaneously for additional analysis capabilities.

Try out all the features for free for 14 days