System requirements

Supported database: mySQL 4.x/5.x

To enable use of mySQL Cache Providers you need to add the .Net provider to the Analyze PRO installation.

Manual installation:
In an Analyze PRO distribution you have a folder called "Providers" which have all necessary files to use for the mySQL .Net provider.

Copy all files from the folder \Providers\mySQLto the Analyze PRO bin-folder.

MySql.Data.dll

If you are going to use the Data Sync solution you should also copy the mySQL.dll to the folder of the data sync service.

Example: C:\Program Files (x86)\Business Analyze\Analyze PRO Data Sync

Setup in Data Central

The provider use the mySQL Data Provider for .NET.

Select the Provider: "mySQL Cache Provider for 4.x,5.x+.

Type in a name of the new datasource.

Data Source should consist of a name or IP-adresse of the server.

Database should consist of a name of the database.

Add User Id and Password.

Example: