Data Adapter

Create a connection between Jaspersoft Studio and MySql Server

For Jasper reports to be compatible with Mambu, they must be built considering the structure of Mambu DB.
This is achieved by having the database as a data source during the development process.
To create and configure a Data Adapter:

1. Go to Jaspersoft Studio, Repository Explorer view

2. Right click on the Data Adapters root node and choose Create Data Adapter

3. Go with the Database JDBC Connection wizard

4. Then as part of the Adaptor configuration:

   • Name: Set a name for the adapter that relates to the database schema

   • Database Location tab:

     • JDBC Driver: com.mysql.jdbc.Driver

     • JDBC Url: jdbc:mysql://[your connection string].
       Example: jdbc:mysql://localhost:3306/local_mambu_database

     • Username: The username set up during the MySql Server installation

     • Password: The password set up during the MySql Server installation

   • Driver Classpath tab:

     • Add a link to the mysql connector jar file (JDBC Driver for MySQL).
       Example: [local_path]/mysql-connector-java-8.0.13-bin.jar

Video Tutorial

Check out our video tutorial for creating and configuring a Data Adapter here.