To integrate Max with Microsoft Azure Synapse, you will need to establish a connection. This allows Max to access and interact with your Azure-hosted databases. Here’s how to set up a new Azure connection:

Step-by-Step Guide

1. Navigate to the Data Page: Access the Data page within Max where all connections are managed.

2. Initiate New Connection:

   • Click the + button in the bottom left of the connections left panel to start the process of creating a new connection.

3. Fill in Connection Details:

   • Connection Name: Enter a unique name for the connection to help identify it within Max.
   • Description (optional): Provide a brief description of what this connection will be used for.
   • Connection Type: Select Microsoft Azure from the dropdown menu.

4. Database Details:

   • Database Host: Enter the host name of the database server in Azure you wish to connect to.
   • Database Name: Specify the database name on the Azure server that Max should connect to.
   • Database Schema: Enter the target schema within the database that you want to query.
   • Port: If necessary, enter the port number used for the database connection.

5. Authentication:

   • Database User: Provide the username that Max will use to access the database.
   • Password: Enter the password associated with the database user.

6. Test and Create:

   • Click the Test Connection button to verify that Max can connect to the Azure database with the provided settings.
   • If the test is successful, click the Create button to finalize the connection.

Important Notes

• Ensure that all connection details, especially the host, database name, and credentials, are entered correctly to avoid issues with connectivity.
• The password for the connection will need to be re-entered if the connection settings are edited or if Max requires reauthentication in the future.
• Table and column names are assumed to contain “normal” characters; i.e. letters, numbers, and underscores.

Setting up this connection allows Max to perform data operations directly on your Microsoft Azure databases, enabling real-time data processing and analytics.