Microsoft Azure SQL Database
Build apps that scale with managed and intelligent SQL database in the cloud.
Go to siteMicrosoft Azure SQL Database API Integrations
Build and run workflows using the Microsoft Azure SQL Database API. Use 1000s of source-available triggers and actions across 2,000+ apps. Or write custom code to integrate any app or API in seconds.
Overview#
The Microsoft Azure SQL Database API allows you to manage and interact with your SQL databases hosted on Azure directly from Pipedream. It provides a serverless way to run SQL queries, manage tables, and handle database management tasks. You can create, read, update, and delete database records, execute stored procedures, and perform a variety of other SQL operations. Leveraging this API on Pipedream enables you to automate workflows, respond to database events in real-time, and integrate with countless other apps and services.
import sql from "mssql"
export default defineComponent({
props: {
azure_sql: {
type: "app",
app: "azure_sql",
}
},
async run({steps, $}) {
const { host, username, password, port, database, encrypt } = this.azure_sql.$auth
const config = {
user: username,
password,
server: host,
port,
database,
authentication: {
type: 'default'
},
options: {
encrypt
}
}
await sql.connect(config);
return await sql.query`SELECT GETDATE()`
},
})
Choose an API to Connect with Microsoft Azure SQL Database API#
1-24of2,000+apps by most popular
Example Use Cases#
Automated Data Backups: Create a workflow that triggers at regular intervals to back up specific tables or the entire database. Store the backups in Azure Blob Storage or integrate with another storage solution like Amazon S3.
Real-Time Data Synchronization: Sync data between Azure SQL Database and third-party services like Salesforce, Shopify, or QuickBooks. Whenever a new record is inserted or updated in the Azure SQL Database, the corresponding data is automatically updated in the other service.
Event-Driven Notifications: Set up a workflow that sends notifications via email, Slack, or SMS when specific database events occur, such as a new row being added to a table, or a particular threshold being reached on a key performance metric.
Popular Microsoft Azure SQL Database Integrations#
Popular Microsoft Azure SQL Database Actions#
Executes a SQL query and returns the results. See the documentation
Inserts a new row in a table. See the documentation
Authentication#
Microsoft Azure SQL Database uses API keys for authentication. When you connect your Microsoft Azure SQL Database account, Pipedream securely stores the keys so you can easily authenticate to Microsoft Azure SQL Database APIs in both code and no-code steps.
Before you connect to your Microsoft Azure SQL database from Pipedream, please make sure your database is either:
- Accessible from the public internet (You may need to add a firewall rule on 0.0.0.0/0 on port 1433), or
- Accessible from a static IP that you've configured from a VPC in Pipedream, and enabled the workflow to connect through that VPC