Connector for MySQL
On this page, you find information about downloading and installing the drivers you need to be able connect to data sources with the connector for MySQL in Spotfire.
Preparations
Before downloading and installing any driver software for use with this connector, read the system requirements for the connector for your version of Spotfire. Make sure that your database version and driver version is supported in your version of Spotfire.
Remember that additional requirements and third party dependencies might apply for using the drivers. Refer to the official documentation from the driver vendor for more information.
Supported data sources
You can use the Spotfire Connector for MySQL to connect to the following data source types:
-
Oracle MySQL
-
MariaDB (Spotfire 10.3 and later)
-
SingleStore (Spotfire 10.3 and later)
-
MongoDB Connector for BI (Spotfire 10.3 and later)
-
Amazon Aurora (Spotfire 10.8 and later)
-
Amazon RDS for MySQL (Spotfire 10.8 and later)
-
Microsoft Azure Database for MySQL (Spotfire 10.8 and later)
-
Microsoft Azure Database for MariaDB (Spotfire 10.8 and later)
-
Google Cloud SQL for MySQL (Spotfire 11.0 and later)
Oracle MySQL
Spotfire 10.3 and later
To be able to access data from Oracle MySQL, install the MySQL Connector/ODBC driver.
-
The MySQL Connector/ODBC driver is available on the MySQL web page.
Spotfire 10.2 and earlier
To use the MySQL connector, you must install the MySQL Connector/Net driver on your computer.
-
The MySQL Connector/Net driver is available on the MySQL web page.
MariaDB
To be able to access data from MariaDB, install the MariaDB ODBC driver.
-
The MariaDB ODBC driver is available on the MariaDB web page.
MongoDB Connector for BI
To be able to access data from MongoDB Connector for BI, install the MongoDB ODBC Driver for BI Connector.
-
The MongoDB ODBC Driver is available on the MongoDB downloads page.
MemSQL
-
Version 5.3 of the MySQL Connector/ODCB driver is available on the MySQL web page.
What to do next?
If you want to learn more about how to use this connector, see the Spotfire User Guide. There you can find everything from basic instructions to detailed information about how you can load and analyze data in Spotfire.