Developer Center

Data Adapter

Last Updated: Aug 15, 2018 02:25PM CEST

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.

Create and configure a Data Adapter:
  • Go to Jaspersoft Studio, Repository Explorer view
  • Right click on the Data Adapters root node and choose Create Data Adapter
  • Go with the Database JDBC Connection wizard
  • 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-5.1.39-bin.jar

Check our video tutorial for creating and configuring a Data Adapter here.
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found