Odoo PostgreSQL Data Offloading | External Database Archiving Storage Management
by Techultra Solutions Private Limited https://www.techultrasolutions.com/$ 48.38
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 604 |
| Technical Name |
external_archive_manager |
| License | OPL-1 |
| Website | https://www.techultrasolutions.com/ |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 604 |
| Technical Name |
external_archive_manager |
| License | OPL-1 |
| Website | https://www.techultrasolutions.com/ |
| Versions | 16.0 17.0 18.0 19.0 |
Odoo PostgreSQL Data Offloading | External Database Archiving & Storage Management
Odoo PostgreSQL Data Offloading is a powerful database optimization solution that allows businesses to offload selected fields from Odoo records to an external PostgreSQL database. Administrators can configure specific models and fields for archival based on business requirements. The module securely stores offloaded data externally while retaining record references within Odoo for seamless access. When needed, archived data can be automatically retrieved and restored to the original record. This helps reduce the size of the primary database, improve system performance, optimize storage usage, and support long-term data retention and compliance requirements.
Odoo PostgreSQL Data Offloading | External Database Archiving & Storage Management
Product Overview
▶ Watch Module Demo
See how Odoo PostgreSQL Data Offloading | External Database Archiving & Storage Management works
Features
Define exactly which Odoo models and fields should be offloaded to the external PostgreSQL database. This flexible configuration allows organizations to archive only the data that impacts database size and performance.
Store selected record data securely in a dedicated PostgreSQL database while maintaining reliable connections and controlled access to archived information.
Reduce the storage footprint of the primary Odoo database by moving large or infrequently accessed field data to external storage, helping maintain optimal database performance.
Support growing business databases by providing a scalable approach to storing and managing large volumes of historical or less frequently used data.
Maintain a secure reference between Odoo records and externally stored data, ensuring accurate tracking and seamless synchronization during retrieval operations.
Ensure that all offloaded and restored data remains accurate, complete, and synchronized with the original Odoo records throughout the entire lifecycle.
Configuration
Support
FAQs
User Configuration
Once you install the module goto
setting > User and Companies > user
Grant External Archive Admin access to users whose databases you
wish to
delete, and assign External Archive Manager access to users for whom
you
intend to offload and retrieve data.
Data Offload / External Archive Manager Module
Once configured, the user will be able to see the 'Data Offload / External Archive Manager' module
Database Connection
You need to configure a host, database, user, and password. Set up the databases from which you want to offload records.
Archive Model Configure
Here, we have configured a sales order model, and for offloading
field data,
we have selected the Total, Signature, and Untaxed Amount
fields.
For the offload mode, we have chosen Manual, but you can also select
Manual, Scheduled, or Manual + Scheduled. The same options apply for
the delete mode.
Delete Rules: This will delete records from your database after the
configured number of days.
Offload Schedule and Delete Schedule: You can schedule the offload
process
to run daily or at a specific time, with a customizable batch size.
The same
options apply for the delete schedule.
Sale Order
Here you can see the Offload, Retrieve and Delete button in the Sale Order.
Before Offload.
Here, you can see that the signature field contains data before the offload process.
Before Offload Size
The 'Total Amount' and 'Amount Untaxed' fields represent the data size prior to the offload process.
After Offload
Here, you can see that after the offload, the fields you configured have been offloaded to the database.
After Offload Size
After the offload process, the configured fields will have been offloaded, and their size in the database will be cleared or empty.
Offload Database
Here, you can see that the data has been offloaded to the configured database.
Retrieve
Here, you can see that the field data has been retrieved once you click the Retrieve button.
Delete
Once you click the Delete button, a pop-up will appear. After you click 'OK', the data from the configured database will be deleted.
Database Record Delete
Here, you can see that the record has been deleted from the database.
Multiple Offload, Retrieve and Delete
If you want to offload, retrieve, or delete multiple records, you can do by selecting multiple record and used External Offload, External Retrieve, and External Delete as per you requirement.
- We provide 90 days bug-free support related to our module.
- We provide 5 hours of free configuration support. Additional configuration or customization is billable.
- The support team is available from Monday to Friday 10:00 AM to 07:00 PM (IST).
- To create a ticket, send an email to support@techultra.in.
The module enables the offloading of selected fields from your main application database to an external PostgreSQL database. This helps improve database performance by reducing the size of the primary database, archiving old or inactive data, and complying with data retention policies.
You can configure specific models and fields to be offloaded. Once set, the goto record in that will see offload and retrieve that you want to transfers these fields data to the external PostgreSQL database while maintaining a reference in the original record. You can retrieve the offloaded data or delete it as needed.
You can select specific fields from any model that supports the module. The offloading is flexible, allowing you to choose individual fields based on their size, frequency of access, or relevance to business operations. Except required, one2many and many2many field.
Offloaded data can be retrieved using the integrated buttons in the record views. You can also set up manual or automated retrieval processes to bring back specific data when necessary.
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