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. |
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.