| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 374 |
| 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.
Watch Demo:
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.
Whatsapp: +91 62309 27667
Email: info@techfinna.com
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 penalizedGreat App and Excellent on customer support
Helps to have a better Dashboard
Easy to use
Excellent in support to make it happen customer service
Works in odoo.sh with a not dedicated server?
Dear team,
We are considering this module. We wonder to know if it can be run in a Odoo.sh environment with a not dedicated server.
Thank you!
Re: Works in odoo.sh with a not dedicated server?
Hello Peter,
The module runs best with Odoo SH and on-premises hosting for both Community and Enterprise Editions. Yes, it will work well with non-dedicated (shared) hosting as well.
As of now we already have a hundreds of customers using this connector with various configurations.
We also provide free installation support for our modules. Feel free to reach out at info@techfinna.com for any questions of if assistance with installation is required.
Module works well, easy to contact tech support
Easy to use, seamlessly integrates data
Great App and Excellent on customer support
Helps to have a better Dashboard
Easy to use
Excellent in support to make it happen customer service
Odoo New version
Hi,
So, do I need to pay for new version when Odoo release a new version?
Does the fee $169 is life time payment?
Tks
Re: Odoo New version
The pricing is one time payment for a lifetime access. We constantly improve our modules with new features and you can download new release of module for free. If you upgrade your Odoo to a different version, you can use existing connector also if it is compatible. You can reach us directly at info@techfinna.com
maintenance support
Hi,
Does this purchase included the maintain during install, used, bug fix and upgrade?
Tks
Re: maintenance support
Yes, the purchase includes installation support and free future updates to the current app as well. The module is a stable release and is verified by Looker Studio (the app can be found officially supported in their data sources list). Still, if you encounter any bugs or have any suggestions for features or improvements, we are all ears. We constantly improve our products as per customer feedback.
For any other query, you can reach us directly at info@techfinna.com.
Great product.TBH i wasnt expecting this to work!
Re: Great product.TBH i wasnt expecting this to work!
Glad you liked the product. We are just one email away if you need to connect for anything.
Drop a review :)