flowground for Business Customers
MS SQL Server
Connector for

MS SQL Server

The MsSQL connector is an integration connector for the Microsoft SQL Server. The connector supports dynamic inbound metadata. Once your query is complete, it is analyzed and incoming metadata is generated accordingly.

Functions and use cases

Database queries in an integration workflow

As a developer of an integration workflow I would like to access specific data of a Microsoft SQL Server database in order to use it in the further workflow.

Updating the database from an integration workflow

As a developer of an integration workflow, I want to perform database operations such as UPDATE or INSERT on a Microsoft SQL Server database to keep data consistent between different systems.

Specifications
  • Category: Developer Tools
  • Provider: elastic.io GmbH
  • Used API: Microsoft Corporation
  • Managed: MANAGED
  • License: Apache 2.0
  • Programmed with: javascript
Prices

For productive use you need a project room, which is subject to a fee.

Prices and Editions
Changelog

Version number: 1

Last change 09/11/2018

Technical Specifications

selectTrigger

Executes a SELECT statement that fetches potentially multiple database rows from the database

OnInit
./lib/actions/select.js
OnStartup
-
OnClose
-

Attributes

-

insert

Executes a single SQL statement that causes database data update and returns a number of affected records, like INSERT, UPDATE or DELETE

OnInit
./lib/actions/insert.js
OnStartup
-
OnClose
-

Attributes

-

selectAction

Executes a SELECT statement that fetches potentially multiple database rows from the database

OnInit
./lib/actions/select.js
OnStartup
-
OnClose
-

Attributes

-

No data available for terms

No data available for environment