VOGO Voice – Knowledge Base

MSSQL

Estimated reading time: 1 min

Database Type: SQL Database

Support: Read, Insert, Update and Delete

Introduction

MSSQL is a relational database management system developed and marketed by Microsoft. Microsoft SQL Server provides the database server functionality of storing and retrieving data as used by other applications.

The VOGO Voice MSSQL connector provides easy access to execute the READ, INSERT, UPDATE and DELETE functions.

Prerequisites

  • MSSQL database with access to connection credentials
  • Ability to whitelist IP address if the server is behind Firewall
  • Knowledge in writing SQL queries

Anatomy of Settings

Defining Settings values for adding MSSQL Connection

Name: It refers to the name assigned to the instance of the connector created.

Username: For the purpose of authentication provide the username which is a simple credential for accessing the SQL server.

Password: Password is yet another credential that ought to be provided for the purpose of authentication specific to SQL Server.

Server: Provide the hostname to connect to the database on which the MSSQL server is running.

Database: This field requires to specify the name of the database it wants to connect to when connecting to the database server.

🖍Note: The aforementioned credentials will be provided by the MSSQL account holder to setup the connector instance.

Disclaimer: The password/private information is encrypted when saved within the VOGO Voice platform for your security.

To know more about the MSSQL server visit https://www.tutorialspoint.com/ms_sql_server/index.htm

Connector Usage

Now that a connector is established it can now be used within any interaction flow. Each usage of the connector will allow different configurations to retrieve different results. Those settings can be either static or dynamic based on the needs.

Anatomy of Configuration

Defining Configuration Values for MSSQL Connector

Name: The name assigned to identify the connector and the results data. The assigned name is used every time the connector is called to action through the components in the interaction builder platform. 

Query: To query data in MSSQL, the SQL query statement syntax is used to interact with the database tables. To learn how to write SQL queries visit https://www.tutorialspoint.com/sql/sql-select-query.htm

Caching: To know about caching, click here

Tags:
Was this article helpful?
Dislike 0
Previous: MongoDB
Next: Opendatasoft