ePrivacy and GPDR Cookie Consent by Cookie Consent

Connector MySQL

The SQL Server connector enables to connect to Microsoft SQL Server data sources.

Data In/Data Out

Data In N/A
Data Out CSV files in the out/tables folder.

Learn more: about the folder structure please go to this article. 

Parameters

DB

MySQL 01.png

Host (required) Name of server that hosts the database.
Port (required) The port number you want to access. 
Database (required) Name of database.
Username (required) Account name. 
Password (required) Account password.

SSH

MySQL 02.png

Enabled (optional)

Checked if SSH required to connect to database. 

Private (optional) Private key. 
Public (optional) Public key.
SSH Host (optional) Name of SSH Host.

 

Table

MySQL 03.png

Table ID (required) ID of the table. The ID of the table should be an integer.
Name (required) Name of the table.
Query (required)  A query is a request to access data from a database to manipulate it or retrieve it.
Output Table (required)  The name of the output table you want to load the query. 
Enabled(optional)  Enabled for this table to be pulled from the database.