Live Demo
Disclaimer:
The Odoo Looker Connector complies with the Google API Services User Data Policy including its Limited Use requirements, ensuring the secure handling of user data.
Looker Studio data sources
Techfinna proudly presents the market's first and only Odoo to Looker Studio Connector, a groundbreaking tool for streamlined data integration. This unique connector simplifies the process of syncing Odoo data with Looker Studio, offering a one-step solution for effortless access to all your Odoo tables. Just input your generated credentials, select the desired tables, and let our connector do the rest, bringing accurate schemas and data directly into Looker. With Techfinna, experience the ease of manual refreshes or elevate your data strategy with our premium scheduled refresh option. Embrace the simplicity and efficiency of Techfinna's connectors, leading the way in Odoo integrations with Looker, BigQuery, and Google Sheets
➢ Custom SQL Query Execution
➢ View Selective Data
Checkout Add-On moduleClick here
First-of-its-Kind Integration: Techfinna's Odoo to Looker Studio Connector stands as the market's premier solution, pioneering direct data integration from Odoo to Looker Studio.
One-Step Easy Setup: Our connector offers a hassle-free setup process, requiring only your Odoo-generated credentials to instantly sync with Looker Studio.
Comprehensive Table Access: Gain full access to all your Odoo tables within Looker Studio, enabling a complete overview of your data for in-depth analysis.
Manual and Scheduled Data Refresh*: Conveniently use manual refreshes for on-demand data updates. The scheduled refresh feature for automatic, timely data synchronization is available as premium feature.
Automatic Schema Mapping with Customization: The connector automatically retrieves and maps Odoo table schemas in their native data types, eliminating manual schema definitions and offering a ready-to-go, customizable, and tweakable solution for immediate data analysis.
Premium Feature: Execute Custom SQL Query and display your data on Google Looker Studio for comprehensive and selective table selection and analysis.
Click Here to view add-on module
Begin by navigating to the data sources in Looker Studio "https://lookerstudio.google.com/datasources" and selecting the 'Odoo Connector by TechFinna'. This is your gateway to integrating Odoo's comprehensive data into Looker Studio's powerful visualization tools.
Ensure you have installed the module from "https://apps.odoo.com/apps/modules/17.0/looker_connector".
On the connector setup screen, you’ll be prompted to enter the Connector URL and Token provided by Looker Connector Module installed on Odoo. These credentials are key to establishing a secure connection between Odoo and Looker Studio.
Once connected, you’ll see a dropdown list of all Odoo tables. Select the table you wish to analyze. This flexibility allows you to tailor the data integration to your specific reporting needs.
The connector will automatically load the schema of the chosen table, converting Odoo's data types into Looker Studio-friendly formats. Review and tweak if necessary to match your reporting requirements.
With the schema set, click "Explore" or "Create Report" to start crafting your reports. You can now manipulate the data, refresh it as needed, and build custom reports, just like the 'Variant Sales Trends' example.
Have a feature in mind that could enhance your Odoo to Looker Studio experience? We're all ears!
At TechFinna, we're committed to evolving alongside your business needs. Drop us a line at info@techfinna.com with your suggestions, and let's collaborate to bring your vision to life in our next update.
🔹 Navigate to the data sources in Looker Studio "https://lookerstudio.google.com/datasources". Search and select the 'Odoo Connector by TechFinna'.
🔹 Paste connector url and access token.
Connector url
Access token
🔹 You are all set.