Availability |
Odoo Online
Odoo.sh
On Premise
|
Lines of code | 379 |
Technical Name |
looker_connector |
License | OPL-1 |
Website | https://techfinna.com/looker-odoo-connector/ |
Versions | 12.0 13.0 14.0 15.0 16.0 17.0 18.0 |

Verified by Google Looker Studio
Odoo Looker Connector by TechFinna Odoo Looker Connector by TechFinna
Seamlessly Search "Odoo" directly on Looker Studio Data sources
Looker Studio Verified: Our Odoo Looker Connector is officially verified by Looker Studio and can be seamlessly integrated into your Looker Studio environment.

Features:
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. Schedule automatic data refresh feature is added in this module from 20 Jan 2024. (If you have an older version, please download the new version for free)
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.
Custom SQL Query Execution
Execute Custom SQL Query and display your data on Google Looker Studio for comprehensive and selective table selection and analysis. Visit ( https://techfinna.com/looker-sql-connector/ ) to view add-on module

How to Connect:

Select the Odoo Connector by TechFinna
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.


Enter Credentials from Odoo
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.


Select Your Odoo Table
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.


Verify Table Schema
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.


Explore and Create Reports
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.

Data Refresh
Schedule Refresh
Set data freshness for a data source
Looker Studio automatically refreshes all the cached data for each data source used by your report at certain intervals. To change the default data refresh rate:
🔹 Edit the data source. You can do this from within a report or from the Data Sources home page.
🔹 At the top, click Data freshness.
🔹 Under Check for fresh data, select a new refresh option, if available.
🔹 Click Set Data Freshness.

Manual Refresh
🔹 If you want your data up to date, we will find data refresh at the top right corner.
🔹 Tab on data refresh, and you will find your data updated every time.

Premium Features:
A premium feature is available for users who require SQL queries to import data from Odoo to lookers.
For Feature Requests or Customizations:
If you have feature requests or need customizations for the connector, feel free to contact us at
Similar Products

Odoo Power Bi Connector
Unique Odoo to Power BI Desktop connector
- 🔹fetch data from Odoo to Power BI Desktop
- 🔹Refresh data with a single click
- 🔹No need for a paid Power BI license
- 🔹Fetch multiple tables at once

Google BigQuery Connector
Achieve seamless sync between Odoo and Google BigQuery.
- 🔹Effortless Data Synchronization
- 🔹Table Selection to Export
- 🔹Seamless Data Visualization
- 🔹Robust Security Measures

Tableau Desktop Connector
Integrate Odoo data into Tableau Desktop in one click.
- 🔹Easy Connection Setup
- 🔹No Additional Setup Required
- 🔹Long-Term Support with WDC 3.0
- 🔹Automatic Schema Consistency
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedEasy to set up!!
I recommend this module for those who want to connect their Odoo to Looker Studio.
Works like charm. Loved the simplicity of use.
my sale order line model has around 100k records, all fetched correctly in looker. Nice. Schema of columns is also correct. So far, fully satisfied.
There are no comments yet!