VOGO Voice – Knowledge Base

MySQL

Estimated reading time: 1 min

Database Type: SQL

Connector Supports: Read / Write

Introduction

MySQL is a widely used open-source relational database management system (RDBMS). MySQL connector is compatible with MySQL 5.5 and subsequent versions. Owing to its on-demand scalability, reliability and high performance this popular open-source database has become a preferred choice, especially among those developing websites and database-driven web applications.

The VOGO Voice MySQL connector instances provide easy access to execute any singular SQL query for SELECT, UPDATE, INSERT, and DELETE. 

Prerequisites

  • MySQL 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 MySQL Account

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

Host: Provide the hostname on which MySQL server is running.

Username: For the purpose of authentication provide the username associated for the needed access.

Password: The associated password used for authentication.

Database: Furnish the exact name of the database as it is specified on the MySQL server.

Port: Enter the port for MySQL. Leave it as default if unsure.

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

Anatomy of Configuration

Defining Configuration Values for a MySQL Connector

Name: The name assigned to identify the connector linked to a specific MySQL database. The assigned name is used every time the connector is called to action through the components in the interaction builder platform. 

Query: SQL statement syntax is used to interact with the database tables. Any results will be returned in the connector results object. To learn how to write SQL queries visit https://dev.mysql.com/doc/refman/5.5/en/sql-syntax.html

Caching: To know about caching, click here.

Tags:
Was this article helpful?
Dislike 0
Previous: Google Sheet
Next: PostgreSQL