7.1 Connecting Viewpoint reporting to the Moab database

To connect Viewpoint reporting to the Moab database

1. Open the reporting.xml file, located in the Viewpoint home directory.
2. Configure the MySQL database connection in Moab by modifying the <database-connection> element in the reporting.xml file.
   1. Set the <url> to the JDBC database connection URL to either your own database or Moab's ODBC database.
   2. Set the <username> and <password> elements to the username and password to the Moab ODBC database.
   3. Set <driver> to the MySQL JDBC driver that you’re using. Place the driver in the Viewpoint application WEB-INF/lib directory.

   <database-connection type="mysql-jdbc">
      <url>jdbc:mysql://localhost/Moab</url>
      <username>root</username>
      <password>root</password>
      <driver>com.mysql.jdbc.Driver</driver>
   </database-connection>

Related topics

• Specifying available reports
• Adding permissions to individual reports
• Configuring Viewpoint to run the Events report
• Configuring Viewpoint to communicate with your DBMS
• Configuring reports

© 2012 Adaptive Computing