Skip to Content

Database Connector

by , ,
Odoo

$ 2.03

v 18.0 Third Party 1
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 2421
Technical Name ylhc_database
LicenseOPL-1
Websitehttps://www.ylhctec.com
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 2421
Technical Name ylhc_database
LicenseOPL-1
Websitehttps://www.ylhctec.com

💾 Yuanli Database Manager

Database Connection & Management for Yuanli Dashboard

Connect to external databases and manage multiple database connections seamlessly. Execute queries across different databases and integrate external data into your Odoo dashboards.

🔗 Multi-Database Support
🔒 Secure Connections
⚡ High Performance

ℹ️ Advanced Extension Module

This module extends Yuanli Dashboard with external database connectivity. Install it to query and integrate data from multiple database sources.

💎 Connect to Any Database

Break down data silos by connecting your Odoo dashboards to external databases. Whether it's your legacy ERP, data warehouse, or third-party systems, Yuanli Database Manager makes it easy to access and visualize data from anywhere.

🔗

Multiple Databases

Connect to PostgreSQL, MySQL, SQL Server, Oracle, and more. Manage all connections in one place.

🔐

Secure & Encrypted

All credentials are encrypted. SSL/TLS support ensures secure connections to your databases.

⚡

Connection Pooling

Efficient connection pooling reduces overhead and improves query performance.

📊 Supported Databases

Yuanli Database Manager supports a wide range of popular database systems. Connect to both SQL and NoSQL databases with native drivers for optimal performance.

🐘 PostgreSQL

Full support for PostgreSQL including advanced features like JSONB, arrays, and custom types. Optimized for Odoo's native database.

🐬 MySQL / MariaDB

Connect to MySQL and MariaDB databases. Support for stored procedures, functions, and complex queries.

📊 Oracle Database

Enterprise-grade Oracle database connectivity. Support for Oracle-specific features and data types.

💾 Microsoft SQL Server

Full SQL Server integration including T-SQL support, stored procedures, and Windows authentication.

🔷 SQLite

Connect to SQLite databases for local data storage and lightweight applications.

🍃 MongoDB

NoSQL database support for MongoDB. Query JSON documents and integrate unstructured data.

🔌 Custom Drivers: Need support for other databases? Our extensible architecture allows you to add custom database drivers.

🔧 Connection Management

Comprehensive connection management interface makes it easy to configure, test, and maintain database connections. All from within Odoo's familiar interface.

  • 📝 Connection Profiles: Save and manage multiple database connections
  • 🔍 Connection Testing: Test connections before saving with detailed error messages
  • 🔐 Credential Encryption: All passwords and sensitive data are encrypted at rest
  • 📊 Connection Monitoring: Track active connections and query performance
  • ⏱️ Timeout Configuration: Set connection and query timeout limits
  • 🔄 Auto Reconnect: Automatic reconnection on connection failures

🚀 Query Execution

Execute SQL queries against external databases directly from your dashboards. Built-in query editor with syntax highlighting and auto-completion makes query writing a breeze.

📝 Query Features
  • SQL syntax highlighting
  • Auto-completion support
  • Query parameter binding
  • Multiple query execution
🛡️ Safety Features
  • Query validation
  • Read-only mode option
  • Query timeout protection
  • Transaction support

📊 Data Integration

Seamlessly integrate external database data into your Odoo dashboards. Use external data alongside Odoo data for comprehensive business intelligence.

🔗 Join External Data

Combine data from multiple databases in a single query. Create comprehensive reports that span across different systems.

🔄 Data Synchronization

Schedule automatic data synchronization between external databases and Odoo. Keep your dashboards always up-to-date.

💾 Import/Export

Bulk import data from external databases into Odoo or export Odoo data to external systems.

🧹 Data Transformation

Transform and clean external data before visualization. Apply filters, aggregations, and calculations.

🔒 Security Features

Enterprise-grade security ensures your database connections and data remain safe. Multiple layers of protection keep your sensitive information secure.

  • 🔐 Encrypted Credentials: All database passwords are encrypted using industry-standard encryption
  • 🔒 SSL/TLS Support: Secure encrypted connections to remote databases
  • 📝 Access Control: Role-based permissions for database connections
  • 📊 Audit Logging: Complete audit trail of all database operations
  • 🚫 IP Whitelisting: Restrict database access to specific IP addresses
  • 🔍 Query Inspection: All queries are logged and can be reviewed
⚠️ Best Practice: Always use read-only database users for dashboard connections to prevent accidental data modifications.

⚡ Performance Optimization

Advanced performance features ensure fast query execution and efficient resource utilization, even when working with large datasets across multiple databases.

💾 Caching
  • Query result caching
  • Configurable cache TTL
  • Smart cache invalidation
  • Cache statistics
🔗 Connection Pooling
  • Reusable connections
  • Pool size configuration
  • Connection lifecycle management
  • Pool monitoring

📦 Installation & Requirements

This module extends the base Yuanli Dashboard with external database connectivity. It requires additional Python database drivers depending on which databases you want to connect to.

✅ Requirements:
  • Yuanli Dashboard (base module)
  • Yuanli Data Source (for advanced features)
  • Odoo 18.0 or higher
  • Python database drivers (psycopg2, pymysql, cx_Oracle, etc.)
💻 Installation Note: Database drivers must be installed separately using pip. See documentation for driver installation instructions.

❓ Frequently Asked Questions

Yes, as long as the database is accessible from your Odoo server. Use SSL/TLS connections for secure communication over the internet. Ensure proper firewall rules and VPN connections if needed.
Yes! All database credentials including passwords are encrypted at rest using industry-standard encryption. Only authorized users with proper permissions can view or modify connections.
Yes, but it's not recommended for dashboard connections. We strongly suggest using read-only database users for dashboards to prevent accidental data modifications. Write operations should be handled through proper APIs or dedicated integration modules.
There's no hard limit on the number of connections. However, consider your server resources and database licensing when creating multiple connections. Connection pooling helps manage resources efficiently.
The module includes automatic reconnection logic. If a connection fails, it will retry according to configured settings. Dashboard blocks using unavailable connections will show error messages without affecting other blocks.
Absolutely! This module works seamlessly with the Data Source module. You can use database connections as data sources for dashboard blocks, combining the power of both modules.

Download Information 

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

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.