Connecting to Azure Database

Overview

Azure Database is a managed database service provided by Microsoft Azure. It allows you to deploy, operate, and scale relational databases in the cloud. In this guide, we'll walk you through the steps to connect your Outerbase application to an Azure Database instance.

Prerequisites

Before you begin, make sure you have the following:

  • An active Microsoft Azure account.
  • An Azure Database instance already set up with the necessary database engine (e.g., SQL Database, MySQL, PostgreSQL, etc.).
  • Access credentials for the database (username and password).
  • The connection information for your Azure Database instance.
  • Outerbase application environment details.

Step 1: Configure Database Firewall

To allow your Outerbase application to communicate with your Azure Database instance, you need to configure the database firewall rules.

  1. Log in to the Azure Portal.
  2. Navigate to your Azure Database instance.
  3. In the left menu, under the "Security + networking" section, click on Firewalls and virtual networks.
  4. Under the "Firewall rules" tab, add the following IP addresses to the allowed IP list:
    • 44.205.184.114
    • 54.172.85.237
  5. Save the changes to update the firewall rules.

Step 2: Obtain Connection Details

Before you can connect to your Azure Database instance from Outerbase, you'll need to gather the following information:

  • Server Name: This is the network address of your Azure Database instance.
  • Port: The port number through which the database listens for incoming connections.
  • Username and Password: The credentials you set up for accessing the database.
  • Database Name: The name of the specific database you want to connect to.

Step 3: Connect from Outerbase

Now that you have the necessary information, you can configure your Outerbase application to connect to your Azure Database instance.

  1. Open your Outerbase application's configuration.
  2. Locate the database configuration section.
  3. Enter the Azure Database server name as the database host.
  4. Enter the port number.
  5. Use the provided username and password for authentication.
  6. Specify the database name you want to connect to.
  7. Save the configuration changes.

Conclusion

You have successfully connected your Outerbase application to your Azure Database instance. This enables your application to interact with the managed database service provided by Microsoft Azure.

Remember to keep your credentials and connection details secure, and regularly update your security settings as needed.

For more detailed information and troubleshooting, refer to the Azure Database documentation.

Happy coding!

Next
What is Outerbase?