Database Management Guide for Alliance Business Suite

Introduction

Welcome to the database management guide specifically designed for Alliance Business Suite (ABS). In this guide, we'll go through how ABS integrates with various database providers and how Vault is used for automated credential rotation.

Supported Database Providers

• MySQL
• MS SQL
• PostgreSQL (PGSQL)
• Oracle

Using Vault for Secure Credential Rotation

About Vault in ABS

Alliance Business Suite leverages Vault for securing and rotating database credentials. The Vault server is hosted at https://vault.absuite.net.

Initial Configuration Steps

1. Access the Vault Server: Open your web browser and navigate to https://vault.absuite.net:8200/.

2. Login to Vault: Use your Corporate credentials to log in. If you don't have them, please contact your system administrator.

3. Navigate to the ABS Secrets Engine: Once logged in, find the section dedicated to Alliance Business Suite.

4. Configure ABS to Use Vault: In your Alliance Business Suite configurations, set the Vault server URL to https://vault.absuite.net.

Automated Credential Rotation

Once Vault is set up, ABS will automatically perform credential rotations at intervals defined in your Vault policies. This ensures that your database credentials remain secure without manual intervention.

Configuring Database Providers

ABS uses the suitesettings.json file to configure database providers. You don't need to install any additional providers.

Here's an example configuration for each supported provider:

MySQL

{
  "DatabaseProviders": {
    "MySQL": {
      "ConnectionString": "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"
    }
  }
}

MS SQL

{
  "DatabaseProviders": {
    "MsSQL": {
      "ConnectionString": "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"
    }
  }
}

PostgreSQL

{
  "DatabaseProviders": {
    "PGSQL": {
      "ConnectionString": "Host=myServerAddress;Database=myDataBase;Username=myUsername;Password=myPassword;"
    }
  }
}

Oracle

{
  "DatabaseProviders": {
    "Oracle": {
      "ConnectionString": "User Id=myUsername;Password=myPassword;Data Source=myOracleDB;"
    }
  }
}

Conclusion

This guide provides an overview of database management in the Alliance Business Suite, with specific emphasis on Vault for credential management. For more advanced configurations or troubleshooting, please refer to the official documentation.

By adhering to this guide, you are ensuring a more secure and robust database management system for your applications running on Alliance Business Suite.