MySQL

Introduction

MySQL is an open-source relational database management system (RDBMS).It organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. MySQL works with an operating system to implement a relational database in a computer’s storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

Read more about its features and how to get started with the popular platform here.

Step By Step Guide

Step 1: Click on Data Warehouses tab in the left side bar navigation to reach the Data Warehouses Module as shown below.
Step 2: Click on Add New to add an additional Data Warehouse to your account.
Step 3: Select MySQL from the Storage Type drop down options.
Step 4: Enter the details about your MySQL in the form and click on Save to add the warehouse. An explanation of each of the fields in the form has been given below.

Field	Description
Data Warehouse Name	*Required* Provide a name for your warehouse. It needs to be unique across your account. This can be accessed from the Warehouses Tab.
Host Name	*Required* Provide a host name for your warehouse. MySQL hostname defines the location where your MySQL database is hosted. You need to specify the MySQL hostname so that DataChannel knows where to connect.
Username	*Required* Provide a username which will be used to create the tables and load data. This user needs to have all rights on the database, datawarehouse(only usage), and the schema you intend to use. In case you are creating a dedicated schema for the data from DataChannel (which is recommended,then this user can be the schema owner.
Password	*Required* Provide the password for the username entered above.
Port	*Required* Provide the port number.
DB Name	*Required* Provide the name of the database you have created in your MySQL instance.

Field

Description

Data Warehouse Name

Required

Provide a name for your warehouse. It needs to be unique across your account. This can be accessed from the Warehouses Tab.

Host Name

Required

Provide a host name for your warehouse. MySQL hostname defines the location where your MySQL database is hosted. You need to specify the MySQL hostname so that DataChannel knows where to connect.

Username

Required

Provide a username which will be used to create the tables and load data. This user needs to have all rights on the database, datawarehouse(only usage), and the schema you intend to use. In case you are creating a dedicated schema for the data from DataChannel (which is recommended,then this user can be the schema owner.

Password

Required

Provide the password for the username entered above.

Port

Required

Provide the port number.

DB Name

Required

Provide the name of the database you have created in your MySQL instance.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.