We are in official beta.

SQL Server

A SQL Server or Azure SQL database, with a SQL login.

Databases and Dataverse · type sqlserver

Connect it

Open Portal → Connections, choose Add, then SQL Server, and fill in its settings and its credential. The portal sends the one request every type uses, with "type": "sqlserver". The credential goes in credential.secret; for this type it is the password.

The settings, the credential and a ready example body, from the public type catalog (no key needed):

GET https://api.docbutterfly.com/api/connection-types/sqlserver
GET https://api.docbutterfly.com/api/connection-types/sqlserver/schema

Operations

Each operation is an API call that names the connection. Reads bring data in from SQL Server; writes send data or files out to it.

Read

SqlListTables SQL: List Tables
SqlQueryRows SQL: Query Rows
TableWatchPoll Table: Poll Watcher

Write

SqlInsertRows SQL: Insert Rows

All connection types