Contents

Cancel

Recommended Articles

  1. unify-apps

    Indexing

    Unify AI

    Transform raw content into searchable knowledge through AI-powered indexing and vector embeddings

  2. unify-apps

    Quentn

    Unify Integrations

    Integrate your app with Quentn to automate marketing campaigns, manage contacts, and optimize customer engagement.

  3. unify-apps

    JobNimbus

    Unify Integrations

    Integrate your application with JobNimbus to manage leads, track jobs, and streamline your workflow processes efficiently

  4. unify-apps

    IMAP

    Unify Integrations

    Integrate your app with IMAP to enable seamless email synchronization, real-time access, and enhanced communication workflows.

  5. unify-apps

    Preview Your Work

    Unify Automations

    Effortlessly review & monitor your automation’s performance

  6. unify-apps

    QuickBooks

    Unify Integrations

    Integrate your app with QuickBooks to streamline accounting, automate invoicing, and manage finances effortlessly

  7. unify-apps

    FTP/FTPS

    Unify Integrations

    Connect your app with FTP/FTPS to automate secure file transfers and streamline data exchange across systems.

  8. unify-apps

    Filters

    Unify Applications

    Enable users to refine, search, and sort data effortlessly across dashboards and datasets

  9. unify-apps

    Insided

    Unify Integrations

    Integrate your app with Insided to enhance customer engagement, streamline community management, and drive self-service support.

  10. unify-apps

    Reverse Polling

    Unify Data

    Reverse Polling technique efficiently retrieves recent data from APIs that return results in chronological order (oldest first), optimizing pagination and data processing strategies when working with time-ordered data sources.

  11. unify-apps

    Facebook Ads

    Unify Integrations

    Connect your app with Facebook Ads to automate campaign management, optimize ad performance, and track marketing success.

  12. unify-apps

    Gainsight

    Unify Integrations

    Integrate your app with Gainsight to enhance customer success, automate engagement workflows, and drive retention

  13. unify-apps

    Livestorm

    Unify Integrations

    Integrate your app with Livestorm to streamline webinar hosting, automate event management, and enhance audience engagement.

  14. unify-apps

    Snowflake

    Unify Automations

    Connect to Snowflake for fast, scalable cloud data warehousing and analytics

  15. unify-apps

    Pipeline CRM

    Unify Integrations

    Integrate your app with Pipeline CRM to streamline sales processes, automate lead management, and enhance customer relationships

  16. unify-apps

    Cognito Forms

    Unify Integrations

    Integrate your app with Cognito Forms to create custom forms, automate data collection, and streamline workflows

  17. unify-apps

    Button

    Unify Applications

    Create interactive elements with ease using buttons

  18. unify-apps

    Baserow

    Unify Integrations

    Integrate your app with Baserow to create collaborative databases, automate data workflows, and streamline project management

  19. unify-apps

    BambooHR

    Unify Automations

    Integrate your app with BambooHR to streamline HR management, automate employee data processing, and enhance onboarding workflows

  20. unify-apps

    Polling Techniques

    Unify Data

    Essential strategies for efficiently extracting data from source systems with optimal performance and reliability

Unify Integrations
Logo
Microsoft Azure database

Microsoft Azure database

Logo

2 mins READ

The Microsoft Azure Database connector integrates seamlessly with Azure SQL, enabling efficient management and interaction with your database. By integrating Azure databases with your application, you can leverage the power of cloud-hosted database services for real-time processing and efficient data management.

Authentication

Before integrating your Azure database, ensure you have the following information:

  • Connection Name: Assign a descriptive name to your Azure database connection for easy identification, such as "MyAzureDBConnection."

  • Server Name: Your Azure SQL server's fully qualified domain name (e.g., <name>.database.windows.net).

  • Port Number: The port number for Azure SQL databases. Default: 1433.

  • Username: The username used to authenticate with the Azure SQL database.

  • Password: The password associated with your Azure SQL database user account.

  • Database Name: The Azure SQL database you want to connect to.

  • Connection Type: Specify the connection type as Direct.

  • Schema Name: This represents the schema or user namespace within the database containing tables, views, and other objects.

  • Connect through SSH: Enable this option to connect to Unifyapps using an SSH tunnel instead of directly connecting to your Azure database host. This provides additional security to your database by not exposing your Azure database setup to the public.

  • SSH Host: Enter the hostname or IP address of the SSH server that acts as the gateway to your database. Example: ssh.example.com or 203.0.113.1.

  • SSH Port: Specify the port number on which the SSH server listens. The default is usually 22, but it may differ for security reasons.

  • SSH User: Provide the username for authenticating with the SSH server. This is typically the user account on the remote server with the necessary permissions.

  • RSA Private Key: Provide the RSA private key corresponding to the public key stored on the SSH server.

  • Client Certificate: Obtain a valid client certificate from a trusted Certificate Authority (CA). This certificate authenticates your client to the database server.

  • SSL Certificate Key: This private key corresponds to your client's certificate.

  • Server Certificate: Obtain the database server's SSL certificate. This certificate verifies the server's identity to your client. Often provided by your database administrator or hosting service.

Actions 

Actions

Description

Insert row

Insert a row into a table in Microsoft Azure Database

Update rows

Update rows in a table in Microsoft Azure Database

Upsert rows

Upsert rows in a table in Microsoft Azure Database

Delete rows

Delete rows in a table in Microsoft Azure Database

Execute a SQL statement

Executes a SQL statement in Microsoft Azure Database