Installing Crystal Reports 2020 and MySQL Connector/ODBC 9.1.0

Install SAP Crystal Reports 2020 on a different computer from the Vocera Analytics Server. To connect from Crystal Reports to your Vocera Analytics Server, you need to install the MySQL Connector/ODBC 9.1.0 driver and set up an ODBC data source.

1. Download the MySQL Connector/ODBC 9.1.0 driver from the following location:
   https://dev.mysql.com/downloads/connector/odbc/

   Note: Vocera Analytics Server requires MySQL Connector/ODBC 9.1.0 driver or later.
2. Install the MySQL Connector/ODBC 9.1.0 driver or later.
3. Following are the steps for installing MYSQL ODBC 8.4 Unicode Driver.
4. Set up an ODBC data source to connect to your Vocera Analytics Server.
   1. Open the ODBC Data Source Administrator, which is usually found under Start > Programs > Administrative Tools > ODBC Data Sources (64-bit), or Start > Settings > Control Panel > ODBC Data Sources (64-bit) or Start > ODBC Data Sources (64-bit). The ODBC Data Source Administrator dialog box opens.
   2. Click the System DSN tab.
   3. Click Add. The Create New Data Source dialog box opens.
   4. Select MySQL ODBC 8.4 Unicode Driver from the list.

      

   5. Click Finish.
   6. The Connector/ MySQL ODBC 8.4 Unicode Driver dialog box opens with the Login tab selected.

      Enter the following information:

      Field	Value
      Data Source Name	Vocera_analytics
      Description	Vocera Analytics Server connection
      Server	[IP address of the Vocera Analytics Server machine]
      User	analyticsuser
      Password	Password used for Visualization server
      Database	vocera_analytics

      Note: The User and Password values are the default values for Vocera Analytics Server. If you had changed the User and Password on the Vocera Analytics Server, use those values instead.
      
   7. Click OK to save the connection and close the Connector/ MySQL ODBC 8.4 Unicode Driver dialog box.
5. Install SAP Crystal Reports 2020. For detailed instructions, see the separate Crystal Reports documentation.
6. When prompted, restart the computer.
7. After the computer restarts, run SAP Crystal Reports 2020.
8. Log on to the vocera_analytics data source:
   1. Choose File > Log On or Off Server. The Data Explorer dialog box opens.
   2. Expand the Create New Connection folder, and then expand the ODBC (RDO) folder. The ODBC (RDO) dialog box opens.
   3. Ensure the Select Data Source radio button is selected. In the Data Source Name list, select vocera_analytics.
   4. Click Next.

      

   5. Enter the UserID and Password.
      Note: The User and Password values are the default values for Vocera Analytics Server. If you had changed the User and Password on the Vocera Analytics Server, use those values instead.
   6. Click Finish.