If any client needs to store data on their server along with files, there is an option to install database on local server as follows. StrategicERP Cloud will work as normal but it will save data on the remote database. Cost is 4 days of devops team support for one time setup and paid support in future for any issue.

We can link your hosted PostgreSQL database to the StrategicERP Cloud application and provide a secure URL for your team to access this specific database over the internet via StrategicERP cloud.

Infrastructure Required:

• CPU: 8 Core
• RAM: 16 GB
• HDD: 10 GB SSD
• Internet: 10 Mbps (not needed if server on cloud)
• 256 Bit Encryption SSL Certificate
• Static IP with 1 backup IP (not needed if server on cloud)

Software Required:

• Linux Ubuntu 22.04
• PostgreSQL 14.22
• SSH for Remote Access

Scope (what we will do)

• Configure a secure connector from StrategicERP Cloud to your remote PostgreSQL instance.

• Set up the data source in the application and publish a dedicated access link for this backup database.

• Validate connectivity and basic read access for dashboards/reports as required.

• Store credentials encrypted at rest and restrict access to authorized users only.

Prerequisites from your side (please provide)

• DB Host (Public IP/FQDN): [ ]

• Port: [ ] (default 5432)

• DB Name (backup DB): [ ]

• Read-only Username: [ ]

• Password: [ ]

• IP allowlist (if your firewall restricts inbound): please allow our cloud IP 103.101.58.44

Deliverables

• Unique URL for accessing this backup database within the application.