Database | Driver | |
---|---|---|
Actian Matrix (formerly ParAccel) . | WINDOWS | LINUX ODBC Driver for ParAccel | MAC Actian Matrix JDBC Driver . |
Actian Vector | WINDOWS | LINUX VW ODBC Driver | MAC VW JDBC Driver |
Alation | WINDOWS | LINUX | MAC Alation | |
Amazon Athena | WINDOWS | LINUX Amazon Athena JDBC driver | MAC Amazon Athena JDBC driver |
Amazon Aurora (MySQL Compatible) | WINDOWS | LINUX MySQL ODBC driver (Unicode version) | MAC MySQL JDBC driver |
Amazon EMR | WINDOWS | LINUX MicroStrategy Hive ODBC Driver | MAC MicroStrategy Hive JDBC Driver |
Amazon Redshift | WINDOWS MicroStrategy ODBC Driver for Amazon RedShift Wire Protocol | LINUX | MAC MicroStrategy JDBC Driver for Amazon RedShift Wire Protocol |
Amazon S3 | WINDOWS | LINUX | MAC Amazon S3 | |
Apache Drill | WINDOWS | LINUX MicroStrategy Drill ODBC Driver | MAC MicroStrategy Drill JDBC Driver |
Apache Hive | WINDOWS | LINUX MicroStrategy Hive ODBC Driver | MAC MicroStrategy Hive JDBC Driver |
Apache Impala | WINDOWS | LINUX MicroStrategy Impala ODBC Driver | MAC MicroStrategy Impala JDBC Driver |
Apache Solr | WINDOWS | LINUX | MAC Apache Solr Driver | |
Apache Spark SQL | WINDOWS | LINUX MicroStrategy Spark ODBC Driver | MAC MicroStrategy Spark JDBC Driver |
Arcadia Data | WINDOWS | LINUX MicroStrategy Impala ODBC driver | MAC MicroStrategy Impala JDBC driver |
AtScale | WINDOWS | LINUX | MAC AtScale Driver | |
Box | WINDOWS | LINUX | MAC Box Driver | |
CA Technologies Rally | WINDOWS CA Technologies Rally Driver | LINUX | MAC CA Technologies Rally Driver |
Cassandra | WINDOWS | LINUX MicroStrategy Cassandra ODBC Driver | MAC MicroStrategy Cassandra ODBC Driver |
Cirro | WINDOWS | LINUX Cirro | MAC Cirro |
Cisco Data Virtualization | WINDOWS | LINUX Cisco DV ODBC Driver | MAC Cisco DV JDBC Driver |
Clipboard | WINDOWS | LINUX | MAC Clipboard | |
Cloudera CDH Hive | WINDOWS | LINUX MicroStrategy Hive ODBC Driver | MAC MicroStrategy Impala JDBC Driver |
Concur | WINDOWS | LINUX | MAC Concur | |
Cvent Data | WINDOWS | LINUX | MAC Cvent Data | |
Data.world | WINDOWS | LINUX | MAC Data.world Driver | |
DataDirect Cloud | WINDOWS | LINUX | MAC DataDirect Cloud ODBC Driver | |
Denodo | WINDOWS | LINUX PostgreSQL ODBC driver | MAC PostgreSQL JDBC driver |
Dropbox | WINDOWS | LINUX | MAC Dropbox | |
Druid | WINDOWS | LINUX | MAC Druid Driver | |
ElasticSearch | WINDOWS | LINUX | MAC ElasticSearch Driver | |
Eloqua | WINDOWS | LINUX | MAC Eloqua Driver | |
EXAsolution | WINDOWS | LINUX EXAsolution ODBC driver | MAC EXAsolution JDBC driver |
WINDOWS | LINUX | MAC Facebook | ||
Fitbit | WINDOWS | LINUX | MAC Fitbit | |
Google Analytics | WINDOWS | LINUX | MAC Google Analytics Driver | |
Google BigQuery | WINDOWS | LINUX MicroStrategy Google BigQuery ODBC Driver | MAC MicroStrategy Google BigQuery JDBC Driver |
Google Drive | WINDOWS | LINUX | MAC Google Drive | |
Hadoop | WINDOWS | LINUX | MAC Hadoop Gateway | |
Hbase via Phoenix | WINDOWS | LINUX | MAC Phoenix JDBC Driver | |
Hortonworks HDP Hive | WINDOWS | LINUX MicroStrategy Hive ODBC Driver | MAC MicroStrategy Hive JDBC Driver |
HP Vertica | WINDOWS Vertica ODBC Driver LINUX Vertica ODBC Driver | MAC Vertica JDBC Driver |
Hubspot | WINDOWS | LINUX | MAC Hubspot | |
IBM Cognos TM1 | WINDOWS | LINUX MicroStrategy MDX Cube Provider | |
IBM DB2 for i | WINDOWS | LINUX MicroStrategy ODBC Driver for DB2 Wire Protocol | MAC MicroStrategy Db2 JDBC Driver |
IBM DB2 for Linux, UNIX and Windows | WINDOWS | LINUX MicroStrategy ODBC Driver for DB2 Wire Protocol | MAC MicroStrategy Db2 JDBC Driver |
IBM DB2 for Z/OS | WINDOWS | LINUX MicroStrategy ODBC Driver for DB2 Wire Protocol | MAC MicroStrategy Db2 JDBC Driver |
IBM Informix | WINDOWS | LINUX IBM Informix ODBC Driver from the Informix Client Software Development Kit | MAC IBM Informix JDBC Driver |
IBM Informix Extended Parallel Server | WINDOWS IBM Informix ODBC Driver from the Informix Client Software Development Kit LINUX IBM Informix ODBC Driver from the Informix Client Software Development Kit MAC IBM Informix JDBC Driver | WINDOWS IBM Data Server Driver Package LINUX IBM Data Server Driver Package |
IBM Netezza/IPS | WINDOWS | LINUX Netezza ODBC Driver | MAC Netezza JDBC Driver |
Infobright | WINDOWS | LINUX MySQL ODBC driver (Unicode version) | MAC MySQL JDBC driver |
Informatica Data Services | WINDOWS | LINUX Informatica Data Source ODBC Driver | MAC Informatica Data Source JDBC Driver |
Jira | WINDOWS | LINUX | MAC Jira | |
Kognitio WX2 | WINDOWS | LINUX Kognitio ODBC Driver | MAC Kognitio JDBC Driver |
MapR Drill | WINDOWS | LINUX MicroStrategy Drill ODBC Driver | MAC MicroStrategy Drill JDBC Driver |
MapR Hive | WINDOWS | LINUX MicroStrategy Hive ODBC Driver | MAC MicroStrategy Hive JDBC Driver |
MapR Spark | WINDOWS | LINUX MicroStrategy Spark ODBC Driver | MAC MicroStrategy Spark JDBC Driver |
MariaDB | WINDOWS | LINUX MySQL ODBC Driver (Unicode version) | MAC MySQL JDBC Driver |
Marketo | WINDOWS | LINUX | MAC Marketo Driver | |
MarkLogic | WINDOWS | LINUX MarkLogic SQL ODBC Driver | |
MemSQL (3.x and 4.x only) | WINDOWS | LINUX MySQL ODBC Driver (Unicode version) | MAC MySQL JDBC Driver |
Microsoft Azure Cosmos DB | WINDOWS | LINUX Microsoft Azure Cosmos DB Driver | |
Microsoft Azure HDInsights | WINDOWS | LINUX MicroStrategy Hive ODBC Driver | MAC MicroStrategy Hive JDBC Driver |
Microsoft Azure SQL Data Warehouse | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol | MAC MicroStrategy SQLServer JDBC Driver |
Microsoft Azure SQL Database | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol | MAC MicroStrategy SQLServer JDBC Driver |
Microsoft SQL Database | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol | MAC MicroStrategy SQLServer JDBC Driver |
Microsoft SQL Server | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol | MAC MicroStrategy SQLServer JDBC Driver |
Microsoft SQL Server Analysis Services | WINDOWS | LINUX MicroStrategy MDX Cube Provider | |
Microsoft SQL Server Parallel Data Warehouse | WINDOWS | LINUX MicroStrategy ODBC Driver for SQLServer Wire Protocol | MAC MicroStrategy SQLServer JDBC Driver |
MongoDB | WINDOWS | LINUX MicroStrategy MongoDB ODBC Driver | MAC MicroStrategy MongoDB JDBC Driver |
MongoDB Connector for BI | WINDOWS | LINUX | MAC MySQL JDBC driver | |
Mulesoft | WINDOWS | LINUX | MAC Mulesoft Driver | |
MySQL | WINDOWS | LINUX MySQL ODBC driver (Unicode version) | MAC MySQL JDBC driver |
Neo4J | WINDOWS | LINUX | MAC Neo4J Driver | |
OBIEE | WINDOWS | LINUX | MAC OBIEE Driver | |
Okta | WINDOWS | LINUX | MAC Okta Driver | |
Oracle Database | WINDOWS | LINUX MicroStrategy ODBC Driver for Oracle Wire Protocol | |
Oracle Essbase | WINDOWS | LINUX MicroStrategy MDX Cube Provider | |
Paypal | WINDOWS | LINUX | MAC Paypal | |
Pivotal Greenplum | WINDOWS | LINUX DataDirect ODBC Drivers for Pivotal Greenplum | MAC DataDirect JDBC Drivers for Pivotal Greenplum |
PostgreSQL | WINDOWS | LINUX PostgreSQL ODBC driver | MAC PostgreSQL JDBC driver |
Presto | WINDOWS | LINUX | MAC Presto JDBC Driver | |
Salesforce | WINDOWS | LINUX Microstrategy ODBC driver for Salesforce | MAC Microstrategy JDBC driver for Salesforce |
SAP HANA | WINDOWS | LINUX SAP HANA HDBODBC64 ODBC Driver | MAC SAP HANA JDBC Driver |
SAP Netweaver BW | WINDOWS SAP Java Connector | LINUX SAP Java Connector |
SAP Sybase ASE | WINDOWS | LINUX MicroStrategy ODBC Driver for Sybase ASE Wire Protocol | MAC MicroStrategy Sybase ASE JDBC Driver |
SAP Sybase IQ | WINDOWS | LINUX | MAC Sybase IQ ODBC Driver | |
ServiceNow | WINDOWS | LINUX | MAC ServiceNow | |
Sharepoint Files | WINDOWS | LINUX | MAC Sharepoint Files | |
Shopify | WINDOWS | LINUX | MAC Shopify | |
Snowflake | WINDOWS | LINUX Snowflake DSII Driver | MAC Snowflake JDBC Driver |
Splunk | WINDOWS | LINUX Splunk ODBC Driver | |
Square | WINDOWS | LINUX | MAC Square | |
Stratio Crossdata | WINDOWS | LINUX | MAC Stratio Crossdata | |
SurveyMonkey | WINDOWS | LINUX | MAC SurveyMonkey | |
TapClicks | WINDOWS | LINUX | MAC TapClicks | |
Teradata | WINDOWS Teradata ODBC Driver LINUX Teradata ODBC Driver | MAC Teradata JDBC Driver |
Teradata Aster | WINDOWS | LINUX Aster ODBC Driver | MAC Aster JDBC Driver |
XML Files | WINDOWS | LINUX | MAC XML Files | |
Yellowbrick | WINDOWS | LINUX XML Files | MAC PostgreSQL JDBC driver |
Zendesk | WINDOWS | LINUX | MAC Zendesk Connector |
- Download Mysql Connector Jar File
- Sql Java Connector
- Mysql Jdbc Connector Download
- Mysql Download Connector Mac Javatpoint
Version 8.0.19 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. Version 8.0.19 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI.
MySQL JDBC for macOS
This tutorial shows how to set up a data source and connect to a MySQL® database using the Database Explorer app or the command line. This tutorial uses the MySQL Connector/J 5.1.46 driver to connect to a MySQL Version 5.5.16 database.
Step 1. Verify the driver installation.
If the JDBC driver for MySQL is not installed on your computer, find the link on the Driver Installation page to install the driver. Follow the instructions to download and install this driver on your computer.
Step 2. Set up the data source.
You set up a data source using the Database Explorer app or the command line.
Set Up Data Source Using Database Explorer
Open the Database Explorer app by clicking the Apps tab on the MATLAB® Toolstrip. Then, on the right of the Apps section, click the Show more arrow to open the apps gallery. Under Database Connectivity and Reporting, click Database Explorer. Alternatively, enter
databaseExplorer
at the command line.In the Data Source section, select Configure Data Source > Configure JDBC data source.
The JDBC Data Source Configuration dialog box opens.
In the Name box, enter a name for your data source. (This example uses a data source named
MySQL
.) You use this name to establish a connection to your database.From the Vendor list, select
MySQL
.In the Driver Location box, enter the full path to the JDBC driver file.
In the Database box, enter the name of your database. In the Server box, enter the name of your database server. Consult your database administrator for the name of your database server. In the Port Number box, enter the port number.
Under Connection Options, in the Name column, enter the name of an additional driver-specific option. Then, in the Value column, enter the value of the driver-specific option. Click the plus sign to specify additional driver-specific options.
Click . The Test Connection dialog box opens. Enter the user name and password for your database, or leave these boxes blank if your database does not require them. Click .
If your connection succeeds, the Database Explorer dialog box displays a message indicating the connection is successful. Otherwise, it displays an error message.
Click . The JDBC Data Source Configuration dialog box displays a message indicating the data source is saved successfully. Close this dialog box.
Set Up Data Source Using Command Line
Create a JDBC data source for a MySQL database.
Set the JDBC connection options. For example, this code assumes that you are connecting to a JDBC data source named
MySQL
, full path of the JDBC driver file/home/user/DB_Drivers/mysql-connector-java-5.1.17-bin.jar
, database nametoystore_doc
, database serverdbtb01
, and port number3306
.Test the database connection by specifying the user name
username
and passwordpwd
, or leave these arguments blank if your database does not require them.Save the JDBC data source.
Download Mysql Connector Jar File
After you complete the data source setup, connect to the MySQL database using the Database Explorer app or the JDBC driver and command line.
Step 3. Connect using the Database Explorer app or the command line.
Connect to MySQL Using Database Explorer App
On the Database Explorer tab, in the Connections section, click and select the data source for the connection.
In the connection dialog box, enter a user name and password, or leave these boxes blank if your database does not require them. Click .
The Catalog and Schema dialog box opens.
In the Catalog list, select the catalog. Click .
The app connects to the database and displays its tables in the Data Browser pane. A data source tab appears to the right of the pane. The title of the data source tab is the data source name that you defined during the setup. The data source tab contains empty SQL Query and Data Preview panes.
Select tables in the Data Browser pane to query the database.
Close the data source tab to close the SQL query. In the Connections section, close the database connection by clicking .
Note
If multiple connections are open, close the database connection of your choice by selecting the corresponding data source from the list.
Connect to MySQL Using JDBC Driver and Command Line
Connect to a MySQL database using the configured JDBC data source, user name
username
, and passwordpwd
.Close the database connection.
See Also
Sql Java Connector
Apps
Mysql Jdbc Connector Download
Functions
close
|configureJDBCDataSource
|database
|saveAsJDBCDataSource
|setConnectionOptions
|testConnection