Real-time Odoo to Snowflake Pipeline.
The secure data pipeline for Odoo. Incremental sync, RSA Key Pair auth, and auto-flattening of complex Odoo schemas.
Why Engineering Teams Choose Niyu
Stop building fragile Python scripts.
Manual exports break. Generic ETL tools are slow. Our connector installs inside Odoo and pushes data natively to Snowflake. Zero maintenance required.
Incremental Sync. Save Snowflake Credits.
Stop burning compute credits on full-load syncs. We track the `write_date` and `id` to sync only the records that changed, keeping your warehouse costs to a minimum.
- ✓Reduces Warehouse runtime by up to 90%.
- ✓Syncs millions of records in minutes.
- ✓Zero impact on Odoo production performance.
Privacy by Design. You control the Schema.
Don't leak PII to your data warehouse. Select exactly which tables and columns to export using native Odoo domain filtering.
- ✓Filter specific records (e.g., 'Confirmed' Orders only).
- ✓Exclude sensitive columns (Salaries, Passwords).
- ✓Auto-maps Odoo 'Selection' fields to VARCHAR.
One-Click connection to PowerBI & Tableau.
Once data is in Snowflake, your BI tools work instantly via native drivers. No CSV exports, no manual refresh, no 'out of memory' errors.
- ✓Native Snowflake integration.
- ✓Works with Looker, Sigma & Metabase.
- ✓Supports multi-company/multi-currency reporting.
Intelligent Schema Mapping.
Odoo data is messy. We flatten complex JSON and Relational fields into clean SQL tables automatically, so you don't have to parse JSON in Snowflake.
- ✓Handles relational (Many2one) IDs automatically.
- ✓Converts ISO dates for time-series analysis.
- ✓Auto-heals schema changes if you add Odoo fields.
Enterprise Specs
Optimized for Snowflake Architecture.
Leverage Key Pair Authentication for security and Batch Processing for throughput. Our connector respects your warehouse credits and security policies.
Technical Capabilities
The only Redshift connector that handles S3 Staging and Deduplication natively.
Key Pair Auth
Supports RSA 2048-bit Key Pair authentication for Enterprise security.
Odoo.sh Ready
Fully compatible with Odoo.sh, On-Premise, and Cloud hosting.
No Row Limits
Tested on databases with 10M+ records. Built for volume.
Audit Logs
Full traceability of every sync job directly in the Odoo backend.
Error Handling
Auto-retries failed batches without breaking the pipeline.
Multi-Version
Supports Odoo v12 to v19 (Community & Enterprise).
Case Studies
Trusted by Data Teams
We switched from a generic ETL tool to Niyu. The Key Pair auth support finally allowed us to pass our InfoSec compliance audit.
Data Lead, FinTech Corp
The incremental sync is brilliant. We only run our Snowflake warehouse for 10 minutes a day now.
Analytics Engineer, Retail Chain
It flattened our Odoo product variants into a clean table automatically. Saved me weeks of SQL wrangling.
CTO, Manufacturing Group
Start Your Pipeline.
Connect Odoo to Snowflake today. Secure, scalable, and built for engineers.