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.
Downloading the MySQL ODBC driver
The MySQL Connector/ODBC driver is available on the MySQL web page.
Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.
Spotfire 10.2 and earlier
To use the MySQL connector, you must install the MySQL Connector/Net driver on your computer.
Downloading the MySQL Connector/Net driver
The MySQL Connector/Net driver is available on the MySQL web page.
Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.
MariaDB
To be able to access data from MariaDB, install the MariaDB ODBC driver.
Downloading the MariaDB ODBC driver
The MariaDB ODBC driver is available on the MariaDB web page.
Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.
MongoDB Connector for BI
To be able to access data from MongoDB Connector for BI, install the MongoDB ODBC Driver for BI Connector.
Downloading the MongoDB ODBC Driver for BI Connector
The MongoDB ODBC Driver is available on the MongoDB downloads page.
Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.
MemSQL
To be able to access data from MemSQL, install the MySQL Connector/ODBC driver.
Note: For MemSQL, Spotfire requires that you use version 5.3 of the MySQL Connector/ODBC driver. For details, see the Spotfire System Requirements.
Downloading the MySQL Connector/ODBC driver
Version 5.3 of the MySQL Connector/ODCB driver is available on the MySQL web page.
Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.
So, I'm all set up... What do I do now? If you want to learn more about how to use this connector, see the User Guide for Spotfire® Analyst. There you'll find everything from basic instructions to detailed information about how you can load and analyze data in Spotfire. |