<turbo-stream action="update" target="wiki_card"><template>

<h1>SQL Azure-Hosted Connection</h1>
<div class="trix-content"><div>Connecting to an Azure SQL Database (hosted on Microsoft Azure) can be done via Rapidi via the connection type MS-SQL.<br><br><br></div><p><strong><u>1. Prerequisites:</u></strong><strong><br></strong><br></p><ul><li><strong>Azure SQL Database</strong>: Ensure you have an Azure SQL Database set up in your Azure account.</li><li><strong>Firewall Rules</strong>: Configure firewall rules on the Azure SQL Server to allow connections from your IP address. This is set up in the Azure Portal under your SQL Database's Networking settings.</li></ul><p><strong><u>2. Get Connection Details:</u></strong><br><br>In the Azure Portal, navigate to your SQL Database and note the following details:<br><br></p><ul><li><strong>Server Name</strong>: This will be something like yourserver.database.windows.net</li><li><strong>Database Name</strong>: The name of the SQL database you want to connect to.</li><li><strong>Username and Password</strong>: Credentials for accessing the database.</li></ul><div><br></div><p><strong><u>3. Set up the connection in myrapidi.com:</u></strong><br><br></p><ul><li>Go to <strong>Connections</strong>, select <strong>MS-SQL</strong> from the drop-down list and click on<strong> New Connection;</strong></li><li>Fill in the connection details as follows:<ul><li><strong>Description</strong>: Add a clear name/description for the connection;</li><li><strong>Server Connect</strong> : Add the server name ( e.g yourserver.database.windows.net)</li><li><strong>Database</strong>: Add the SQL Database name ( e.g. RapidiAzureDemo)</li><li><strong>Username and Password</strong>;</li><li><strong>Schema</strong>: dbo</li></ul></li><li>Save the connection and click first on <strong>Test</strong> to make sure that the connection has been configured correctly. Afterwards, click on <strong>Read Design</strong> to read the SQL database tables and fields.&nbsp;</li></ul></div>
</template></turbo-stream>

