Open Jaspersoft Studio 6 and click on File | New | Data Adapter Wizard. You will see the following screen:
File name should be MYSQL_DATAADAPTER.xml
, and then you can click Next >.
Next, we will need to choose the type of database adapter. There are several options, such as Cassandra, MongoDB, HBase, JSON file, and so on.
We need to pick Database JDBC Connection and click Next >.
Now, we will need to configure the connection details.
The fields should be completed as follows:
Name:
MySQL
JDBC Driver:
com.mysql.jdbc.Driver
JDBC Url:
jdbc:mysql://localhost/RWS_DB?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
Username:
root
Password:
This needs be blank, or put the password if you are using one.
We will also need to configure the driver into the Jaspersoft Studio classpath. As we are running the application in the same box, we already have the MySQL driver download...