1. Home »
  2. Analytics AI »
  3. User guide »
  4. Connections »
  5. Database »
  6. MySQL

MySQL

Transfer your data from mysql to bizstats AI analytical platform and start doing the search based analytics. 

Steps to create Mysql connection 

Step 1: Select Mysql data source

  1. Go to Project details page
  2. From the subsection "Connection" 
  3. Click add 
  4. You will be landed in the select source page ( selected Filter category : All )
  5. Change the filter category to Database
  6. Select Mysql (JDBC) source from the list 

Step 2:  Give your credential details

  1. Pop-up appears with Create new connection form 
  2. Connection name
    1. Fill the connection name 
      1. This field is for your future reference so give any meaningful name.
  3. Credentials details
    1. Fill the following details
      1. Database name
      2. Username and password for database  
  4. Test connection
    1. After giving your credential information click test connection button
    2. This will verify your connection and show the success message
      1. In case of any issues test connection fails. in this case please verify your credential info and try again 
  5. Save connection
    1. On success of test connection, save the connection

Step 3:  Explore your source tables or files 

  1. Now newly created connection listed in the project details page.
  2. Click the explore icon. 
  3. Pop-up will show the list of tables.
  4. Choose one or more table(s) 
logo