Data Center
  • Data Center
    • Homepage
    • Data Connectors
      • Creating a Data Connector
      • Data Connector List
        • Edit Data Connectors
        • Create Option
        • Reconnecting to a Data Connector
        • Sharing a Data Connector
        • Delete a Data Connector
      • Supported Data Connectors
        • Database Connectors
          • MySQL
          • MSSQL
          • Elastic (Beta Release)
          • Oracle
          • ClickHouse
          • Athena
          • Arango DB
          • Hive
          • Cassandra
          • MongoDB
          • MongoDB for BI
          • PostgreSQL
          • Snowflake
        • File Data Connector
        • API Connectors
          • API Connector
          • Amazon
          • App Store
          • Bing Ads
          • Dropbox
          • FTP Server
          • Facebook
          • Facebook Ads
          • Firebase DB
          • Fitbit
          • Flipkart
          • Google AdWords
          • Google Analytics
          • Google Big Query
          • Google Forms
          • Google Sheet
          • HubSpot
          • Jira
          • Lead Squared
          • Linkedin
          • Linkedin Ads
          • MS Dynamics
          • Mailchimp
          • QuickBooks
          • SalesForce
          • ServiceNow
          • Twitter
          • Twitter Ads
          • Yelp
          • YouTube
          • ZOHO Books
        • Others
          • MS Sql Olap
          • Data Store
          • OData
          • Spark SQL
          • AWS Redshift
          • SAP HANA
    • Data Sets
      • Creating a New Data Set
        • Creating a New Data Set using RDBMS Connector
        • Creating a Data Set using Arango DB Connector
        • Creating a Data Set using an API Connector
        • Creating a New FTP Data Set
        • Creating a Data Set based on an Elastic Connector
      • Data Set List
        • View Options: Data Sets List Page
        • Data Set List: Actions
          • Editing a Data Set
          • Sharing a Data Set
          • Publishing a Data Set
          • Push to VCS
          • Pull from VCS
          • Deleting a Data Set
          • Data Preparation
          • Visualize
            • Deleting a Widget
    • Data Stores
      • Creating a New Data Store
        • Data Store using an RDBMS Connector
        • Data Store using an API Data Connector
      • Data Stores List
        • Edit a Data Store
        • Refresh Data for a Data Store
        • Store Info
        • Sharing a Data Store
        • Adding Synonyms to a Data Store
        • Refresh Synonyms
        • Push to VCS
        • Pull from VCS
        • Delete a Data Store
        • Visualize
          • Deleting a Widget
    • Data Store Meta Data
      • Creating a New Meta Data Store
      • Data Store Meta Data List
        • Editing Meta Data Store
        • Store Details
        • Adding Synonyms to Meta Data Store
        • Refresh Synonyms
        • Sharing a Metadata Store
        • Deleting Meta Data Store
    • Data Sheets
      • Creating a New Data Sheet
      • Editing a Data Sheet
      • Publishing a Data Sheet
        • Entering Data
        • Applying Filter
        • Deleting a Row
      • Removing a Data Sheet
    • Data Sandbox
      • Creating a New Data Sandbox
      • Data Sandbox List
        • Upload File Status
        • Using the Data Preparation Option
        • Deleting a Data Sandbox
        • Visualize
          • Deleting a Widget
        • Create Data Store
        • Reupload
        • Preview
        • Create Datasheet
    • Data Catalog
    • Data as API
    • Data Preparation
      • Accessing the Data Preparation Option
      • Data Preparation Workspace
        • Data Preparation Landing Page
        • Profile: Summary Pane
          • Charts
          • Suggestions
          • Info: Values/Statistics
          • Pattern
        • Transforms
          • Advanced
          • Anonymization
          • Columns
          • Conversions
          • Data Cleansing
          • Dates
          • Functions
          • Integer
          • ML
          • Numbers
          • String
        • Steps
      • Data Preparation List
        • Rename
        • Edit
        • Delete
Powered by GitBook
On this page
  1. Data Center
  2. Data Connectors
  3. Supported Data Connectors
  4. Database Connectors

MySQL

PreviousDatabase ConnectorsNextMSSQL

Last updated 1 year ago

Provide the following information to create a MySQL Data Connector:

  • Data Connector Name: Provide a user-defined name to identify the data connector.

  • Description: Describe about the Data Connector.

  • Username: Enter a Username (It should be the same as given in the connection server).

  • Password: Enter the Password (It should be the same as provided in the connection server).

  • IP/Host: Enter database server details (from where the user wants to fetch data).

  • Port: Provide the server port number.

  • Database Name: Name of the database where you wish to store data.

  • SSL Type: Select SSL or Non SSL as choices.

  • Upload Key: Select a upload key using the drop-down menu.

  • Click the Save option.

Please Note:

  • The MySQL Data Connector supports multiple IP/ Host separated by commas.

  • The MySQL Data Connector supports single Port number.

  • The Upload Key field appears only if the SSL option is selected for the SSL Type.

  • A success message appears confirming the connection.

  • Another success message appears confirming the creation of the Data Connector.

  • The newly created MySQL data connector gets added to the Data Connectors list.

Please Note: The user can use the following Environment Variables instead of the actual Username and Password to create the MySQL Data Connectors.

  • Username: @ENV.MYSQLUSERNAME

  • Password: @ENV.MYSQLPASSWORD