1) Get the Data Repository View (if it is not displayed)

Select Menu: Window/Show View/Other...

In the Show View window, find Jaspersoft Studio/ Repository Explorer.

The Explorer Window will be displayed in the Application Window.

In the Repository Window, right-click Data Adapters/Create Data Adapter.

Select Database JDBC Connection.

Get ready with MySql Connector.jar file

Get ready with MySql Server

(you can use usbwebserver application to provide web and mysql access. Extract the zip file to C:\MYSQL )

Run the server before you start connecting to the mysql server.

If the Apache light turns red, it could be that the web port has been acquired by other application. Perhaps Jasper Server is running on that port.

Change the Apache port to 8081

Both lights must be in green color.

Add the MySQL connector jar file.

Enter the driver, url, username and password. And then click Test button.

You may want to choose password recovery option to protect your master password recovery.

Rename your Data Adapter.

Basic Steps