From Bling! to Redshift: managed, scheduled, no code.
Kondado provides a direct integration between Bling! and Amazon Redshift, allowing you to replicate 30 data pipelines including Sales Orders, Products, Accounts Payable, and NFCe on a configurable schedule ranging from every 5 minutes to daily.
Replicating your Bling! ERP data to Redshift requires no coding or manual exports. Simply connect Bling! as your data source, select which pipelines you need from the 30 available options covering sales, inventory, and financial operations, and configure your preferred update frequency. Kondado handles the automated data transfer, ensuring your Redshift warehouse always contains current information from your sales orders, product catalogs, and financial records.
Once configured, your Bling! data flows directly into Redshift tables optimized for analysis. This enables your team to combine ecommerce transactions with other business data sources, build comprehensive financial reports, and power analytics dashboards without writing custom API scripts or managing complex ETL processes.
With the Sales Orders and Products pipelines replicated to Redshift, you can analyze purchasing patterns across multiple sales channels and optimize inventory allocation based on historical demand trends and customer behavior. The Accounts Payable and Cash and Banks pipelines enable automated cash flow monitoring, allowing finance teams to track outstanding obligations against available liquidity in near-real-time for accurate financial planning. By centralizing these operational datasets in your Redshift warehouse, you create a single source of truth for cross-functional analytics that connects your ecommerce operations with broader business intelligence initiatives and supports complex SQL-based reporting across your organization.
Try out all the features for free for 14 days
Replicated to Redshift
Bling! data available for Redshift
Tables Kondado writes into your Redshift, on a schedule you control.
30
available pipelines
1528
extractable fields
Redshift
Destination
API Version: V3
Available integrations
Cash and Banks: Transactions
Transaction records include fields such as id, date, amount, and description, enabling detailed financial control.
Categories: Stores
Information about categorized stores includes id, name, and description, facilitating organization and analysis.
Categories: Products
Data about categorized products includes id, name, and description, allowing efficient portfolio management.
Categories: Revenues and Expenses
Information about revenues and expenses includes id, name, and type, aiding in financial analysis.
Accounts Payable
Accounts payable data includes id, contact_id, amount, and due date, allowing control of financial obligations.
Accounts Receivable
Accounts receivable information includes id, contact_id, amount, and due date, facilitating the management of receivables.
Accounting Accounts
Accounting account data includes id, name, and type, essential for financial organization.
Contacts
Contact information includes id, name, email, and phone, facilitating communication and relationship management.
Deposits
Deposit records include id, date, amount, and account, allowing control of financial inflows.
Payment Methods
Data about payment methods includes id, name, and description, essential for managing financial transactions.
Product Groups
Table contains information about product groups, including fields such as id, name, and description, enabling efficient categorization of items.
Custom Field Information
Table provides details about custom fields, including id, name, and type, allowing data customization according to user needs.
Logistics
Table encompasses logistics information, with fields such as id, description, and status, facilitating the management of logistics processes.
Reverse Logistics
Table contains data on reverse logistics, including id, reason, and status, allowing tracking of returns and exchanges.
NFCe
Table gathers information on Electronic Consumer Invoices, with fields such as id, date, and total value, essential for fiscal management.
NFSe
Table covers data on Electronic Service Invoices, including id, date, and value, fundamental for service accounting.
Incoming NFe
Table contains information on Incoming Invoices, with fields such as id, date, and supplier, essential for inventory control.
Outgoing NFe
Table gathers data on Outgoing Invoices, including id, date, and customer, fundamental for sales management.
Nature of Operations
Table presents information on nature of operations, with fields such as id, description, and type, essential for fiscal categorization.
Production Orders
Table contains data on production orders, including id, product, and quantity, fundamental for manufacturing control.
Purchase Orders
Contains information about purchase orders, including id, associated contact, and order status.
Sales Orders
Includes details about sales orders, such as id, sale date, total, and order status.
Products
List of available products, including id, name, and associated categories.
Products: Stock
Information about product stock, including id, available quantity, and storage location.
Products: Structures
Details about product structures, including id and associated components.
Products: Suppliers
List of suppliers for products, including product id and supplier id.
Products: Stores
Information about stores selling products, including product id and store id.
Products: Variations
Details about product variations, including id and attributes of the variations.
Module Statuses
Contains information about module statuses, including id and status description.
Sellers
List of sellers, including id, name, and contact details.
Sync data automatically — no code, no manual exports.
1
Connect Bling! to Kondado
Authenticate your Bling! account by providing your API credentials in the Kondado interface. The platform automatically detects available pipelines including Sales Orders, Products, and financial records.
2
Configure Redshift Destination
Enter your Redshift cluster connection details including host, port, database name, and credentials. Kondado validates the connection and prepares the schema structure for incoming Bling! data.
3
Select Pipelines and Schedule
Choose which of the 30 available pipelines to replicate and set your preferred update frequency from 5-minute intervals to daily updates. Activate the configuration to begin automated data transfers.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending Bling! data to Redshift automatically
How does Kondado replicate Bling! data to Redshift without coding?▼
Kondado connects directly to the Bling! API and automatically structures the data into Redshift-compatible schemas. You authenticate your Bling! account through the interface, select your desired pipelines from the 30 available options, and Kondado manages the schema creation and data loading processes without requiring SQL scripts or engineering resources.
Which Bling! financial pipelines can I replicate to Redshift for accounting analysis?▼
You can replicate Accounts Payable, Accounts Receivable, Cash and Banks transactions, and NFCe invoices directly to Redshift. These pipelines include fields like transaction IDs, amounts, due dates, and fiscal classifications, enabling you to build custom financial reports and track cash flow alongside your operational metrics.
How often can I update Bling! data in my Redshift warehouse?▼
Kondado supports configurable update schedules ranging from every 5 minutes to daily intervals. You can set different frequencies for different pipelines, such as updating Sales Orders every 15 minutes for near-real-time inventory tracking while refreshing accounting data hourly for end-of-day reconciliation processes.
What format does Bling! data take when it arrives in Redshift?▼
Data arrives as structured tables with preserved relationships between entities, maintaining foreign keys from your Bling! ERP. Each pipeline becomes a separate table with standard PostgreSQL data types, allowing you to query Sales Orders, Products, and Contacts using standard SQL without additional transformation layers.
Can I combine Bling! data with other sources in the same Redshift instance?▼
Yes, you can replicate data from multiple sources into the same Redshift warehouse alongside your Bling! pipelines. This allows you to join Bling! sales information with marketing data from Google Sheets or BigQuery, creating unified analytics that span your entire business ecosystem.
Are there pre-built dashboards available for Bling! Redshift data?▼
Yes, Kondado offers ready-made report templates including the Bling! Looker Studio Report and Bling! Power BI Report. These templates connect directly to your Redshift tables and provide immediate visualizations of sales performance, inventory levels, and financial metrics without requiring dashboard configuration from scratch.
What happens when Bling! data structures change or new fields are added?▼
Kondado automatically detects schema changes in your Bling! account and updates the corresponding Redshift table structures. New fields appear as additional columns in your tables, ensuring your analytics queries continue to function while capturing the latest data points from your evolving ERP configuration.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
