評価

4.9

事前構築済み

150+

統合

合計

100+

アクティブユーザー

平均

2分

接続まで

カスタム接続

利用可能

HTTPコネクター経由で利用可能

主要企業が Workato を活用

  • monday.svg
  • box.svg
  • hp-2.svg
  • atlassian.svg
  • cisco.png

SQL Serverを自動化すべき理由

Migrate data
  • Migrate data
  • Build data pipelines
  • Automate backups
  • Transform and export data
  • Why these integrations and automations matter:

    Easily move large amounts of data between applications by integrating SQL Server with your other applications. Automatically sync data between applications to eliminate manual uploads.
  • Sync databases.

    Integrate SQL Server with CRMs like Salesforce and Zoho CRM or ERPs like NetSuite or SAP ERP to automatically migrate data from your customer and financial database into SQL Server.
  • Share data.

    Integrate SQL Server with another application to share data and tasks across systems. You could, for example, automatically generate a new deal in ServiceNow and project in Workday every time you add an entry to a deal sheet stored in SQL Server. You could also generate a shared Box folder for any related documents.

SQL Server との統合連携を効率化

  • SQL Serverと自社製品を接続したいですか?

    Workato Embedded プラットフォームを活用し、1200以上の事前構築済みコネクターへアクセス可能です。
    詳しく見る

強力なワークフローを迅速に構築

Triggers

When this happens…

SQL Server
  • New row
    New row in a table in SQL Server
  • New rows Batch
    New batch of rows in a table in SQL Server
  • New rows via custom SQL Batch
    New batch of rows via custom SQL in SQL Server
  • Scheduled query Batch
    Scheduled query using custom SQL in SQL Server
  • New/updated row
    New/updated row in a table in SQL Server
  • New/updated rows Batch
    New/updated batch of rows in a table in SQL Server
  • New/updated rows via custom SQL Batch
    New/updated batch of rows via custom SQL in SQL Server
  • Any other trigger you can think up

Actions

Do this…

SQL Server
  • Bulk load from an on-prem file
    Bulk load rows into a table in SQL Server from an on-prem file
  • Delete rows Batch
    Delete rows in a table in SQL Server
  • Execute stored procedure Batch
    Execute stored procedure in SQL Server
  • Export query result
    Export query result as a CSV file in SQL Server
  • Insert row
    Insert row in a table in SQL Server
  • Insert rows Batch
    Insert batch of rows in a table in SQL Server
  • Replicate schema
    Replicate table schema in SQL Server
  • Run custom SQL Batch
    Run custom SQL in SQL Server
  • Run long query using custom SQL
    Run long query using custom SQL in SQL Server
  • Select rows Batch
    Select rows in a table in SQL Server
  • Select rows using custom SQL Batch
    Select rows using custom SQL in SQL Server
  • Replicate rows Batch
    Replicate batch of rows to table in SQL Server
  • Get table schema
    Get table schema for SQL Server
  • Update rows
    Update rows in a table in SQL Server
  • Update rows Batch
    Update batch of rows in a table in SQL Server
  • Upsert row
    Upsert row in a table in SQL Server
  • Upsert rows Batch
    Upsert batch of rows in a table in SQL Server
  • Any other action you can think up

単一のプラットフォーム

  • 強力
  • 俊敏性
  • スピード
  • 革新

SQL Server との統合連携を効率化

関連ソリューション・コンテンツ

SQL Serverとの統合について

Microsoft SQL Server is a relational database management system that stores and retrieves data for transaction processing, business intelligence, and analytics applications. It helps your business manage, organize, and apply data across many different business programs.

SQL Serverとの統合方法

  • Build and alter database structures
  • Search, manipulate, and transform data
  • Control database security and back up data