How to connect MySQL database?
Article ID: KB0076501
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.0,13.2,13.3 |
Description
In order to access MySQL database, installing separate instance of MySQL driver (5.3 or above) is required. Using that driver with the Microsoft OLE DB Provider for SQL Server allows MySQL use in Data Configurations.
Issue/Introduction
This article talks about how to access MySQL database in Statistica.
Resolution
1. After MySQL driver is installed, open Statistica Enterprise Manager to create a data connection to the MySQL database
2. Create a data configuration based on the data connection above.
More instructions of how to create a data connection and a data configuration can be found here.
2. Create a data configuration based on the data connection above.
More instructions of how to create a data connection and a data configuration can be found here.
Additional Information
Information about how to set up System DSN can be found in the following articles:
https://help.syncfusion.com/report-platform/report-server/how-to/create-dsn-for-mysql
https://support.microsoft.com/en-us/help/965049/how-to-set-up-a-microsoft-sql-server-odbc-data-source
Instructions to point Statistica enterprise to another DSN can be found here:
https://support.tibco.com/s/article/How-to-point-Statistica-to-another-environment
https://support.tibco.com/s/article/How-to-find-the-metadatabase-in-Statistica-Enterprise-Installation
https://help.syncfusion.com/report-platform/report-server/how-to/create-dsn-for-mysql
https://support.microsoft.com/en-us/help/965049/how-to-set-up-a-microsoft-sql-server-odbc-data-source
Instructions to point Statistica enterprise to another DSN can be found here:
https://support.tibco.com/s/article/How-to-point-Statistica-to-another-environment
https://support.tibco.com/s/article/How-to-find-the-metadatabase-in-Statistica-Enterprise-Installation
Feedback
Yes
No
Powered by
