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: