Data Adapter
- 29 Oct 2021
- 1 Minute To Read
- Print
- DarkLight
- PDF
Data Adapter
- Updated On 29 Oct 2021
- 1 Minute To Read
- Print
- DarkLight
- PDF
Article summary
To connect Jaspersoft Studio with MySQL Server for Jasper reports compatible with Mambu, the database must be integrated as a data source during development. This involves creating and configuring a Data Adapter in Jaspersoft Studio. Users should right-click on the Data Adapters root node in the Repository Explorer and select "Create Data Adapter," then follow the Database JDBC Connection wizard. Key configuration steps include naming the adapter, specifying the JDBC driver (com.mysql.jdbc.Driver), and entering the JDBC URL (e.g., jdbc:mysql://localhost:3306/local_mambu_database). Additionally, users must provide the MySQL username and password set during installation. In the Driver Classpath tab, a link to the MySQL connector JAR file must be added (e.g., /mysql-connector-java-8.0.13-bin.jar). A video tutorial is available for further guidance on creating and configuring the Data Adapter.
Did you find this summary helpful?
Thank you for your feedback
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:
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_databaseUsername: 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
- Add a link to the mysql connector jar file (JDBC Driver for MySQL).
Video Tutorial
Check out our video tutorial for creating and configuring a Data Adapter here.
Was this article helpful?
