Multi-Database Support

The application is designed with robust multi-database support, allowing seamless integration with various relational database management systems. Supported databases include:

  • Microsoft SQL Server
    Suitable for on-premises deployments, offering comprehensive SQL Server capabilities and enterprise-grade performance.

  • Azure SQL Database
    A scalable, fully managed cloud database service with high availability and native integration within the Azure ecosystem.

  • PostgreSQL
    A powerful, open-source,Free and standards-compliant database engine, ideal for both cloud-based and on-premises deployments.

  • Oracle Database
    An industry-leading relational database system known for its reliability, scalability, and strong support for complex transactional workloads.

This multi-database flexibility ensures the application can be deployed across a wide range of environments and meet diverse organizational requirements related to performance, licensing, and infrastructure.

How to Configure the Database in Planvisage SCM Tool

  1. Log in to the System Admin section of the Planvisage SCM tool.

  2. On the Admin Dashboard, check the current Database Connection Status.

  3. Click the Configure button to open the database configuration interface.

  4. The Database Configuration screen will appear, where you can enter or update the connection details such as:

  5. Database Type (e.g., SQL Server, Oracle, PostgreSQL)
  6. Login Credenatial or ADO.NET Connection String

img