Drivers and data sources in Spotfire

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.

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.

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.

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.

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.
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.

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.