How to connect Crystal Reports to the KACE SMA database (4316595)

1. Download the MySQL Connector J jar file. Tha download should contain a jar file that looks something like:
2. mysql-connector-java-3.1.14-bin.jar
3. Add the location of your newly downloaded jar file to the Classpath, as defined in CrystalReports CRConfig.xml file. On a Windows machine, the config file will be located somewhere like:
   C:\Program Files\Business Objects\Common\3.5\java\CRConfig.xml
4. Once you have altered your CRConfig.xml, close and reopen Crystal Reports.
5. From the menu: File > New > Standard Report
6. In the Available Data Sources list, double-click to expand Create New Connection.
7. Double-click to expand JDBC (JNDI)
8. Double-click Make New Connection
9. Connection URL: jdbc:mysql://db.example.com/dbname (Use your own database host name and db name).
10. Database Classname: com.mysql.jdbc.Driver
11. Click Next
12. Enter a database user/password combination when prompted.
13. You should now be able to inspect the tables/columns in the database to begin reporting.

If the connection is not allowed, make sure you are granted access settings in MySQL, allowing you to connect from wherever you are. Try connecting using the vanilla MySQL command line client.

NOTE: This is not supported by KACE Technical Support but has been reported to work. This information is provided as a How To only.