Low-code orchestration
Connect, compose and ship AI features faster.
Microsoft SQL Server - Table Integrations
MS SQL Server is a relational database management system (RDBMS) developed by Microsoft.
Multi-tenant deployment
Isolate customer credentials and configurations at scale.
Governed access
Apply policies, field controls and audit trails across usage.
Embedded experience
Deliver workflows natively inside your product.
CONNECTOR OVERVIEW
Create automations with our Microsoft SQL Server - Table connector
Cyclr enables SaaS platforms to integrate their application with hundreds of other platforms. Use Cyclr’s low code integration builder to integrate your application with Microsoft SQL Server – Table, so you can provide in-app Microsoft SQL Server – Table integrations for your end users.
PRODUCT USE CASES
Top Use Cases for Microsoft SQL Server - Table Integrations
Quickly create integrations between your SaaS application and Microsoft SQL Server - Table with Cyclr's low code integration builder. Publish your Microsoft SQL Server - Table integration into your application using Cyclr's white label embedded integration marketplace.
Developer Tools
- Enhance your data with third-party data and keep tables automatically up to date
- Validate data in populated database records with additional tools
Data Tools
- Update data tool from new or updated rows in database
DevOps
- Add new or updated issues to database as new rows
ORCHESTRATION
How Microsoft SQL Server - Table works with Cyclr
Cyclr sits between your SaaS product and Microsoft SQL Server - Table to handle authentication, govern access and orchestrate every API call per customer, at scale.
- 1
Your SaaS product
Your app requests an action for a specific customer.
- 2
Cyclr orchestration
Cyclr authenticates, applies policies and routes the request.
- 3
Microsoft SQL Server - Table
Microsoft SQL Server - Table processes the request and returns a response to your app.
Customer-specific authentication · Governed data movement · Centralized visibility and audit
CONNECTOR COVERAGE
Available connector capabilities
Explore Microsoft SQL Server - Table methods you can orchestrate through Cyclr.
Tables1
List Tables
ActionLists the tables in the database.
Enhanced Tables8
Add Row
ActionAdds a new row to table.
Get Rows
ActionGet rows from a table.
Update Row(s)
ActionUpdates existing row(s).
Update Row(s) By Column
ActionUpdates existing row by Column.
Update Row
ActionUpdates existing row by primary key column.
Get Columns
ActionGets the columns for the table.
Add Multiple Rows
ActionAdds rows to table.
Get Row
ActionGet row from a table by primary key.
Custom Object Methods3
Delete Row
ActionDeletes existing row by the primary key column.
Delete All Rows
ActionDeletes all rows.
Delete Row(s)
ActionDeletes existing row bases on where clause.
TECHNICAL DETAILS
Microsoft SQL Server - Table integration and API details
Review the sourced authentication and API behaviour used when configuring customer-facing Microsoft SQL Server - Table integrations in Cyclr.
API and authentication
- API host
Not specified- Authentication
- See Connector in Console
- Credentials
Review the connector installation fields in Cyclr Console.
- Method categories
See available methods
Pagination and rate limits
Pagination
Method-specific behavior should be confirmed before implementation.
Rate limits
Refer to the vendor API documentation for current limits.
IMPLEMENTATION
Authentication at a glance
Authentication requirements and any available connection options are shown when installing this connector in Cyclr Console.
- Authentication method
- See Connector in Console
- Credential required
Review the connector installation fields in Cyclr Console.