Configure data source
There are many ways with which AEM enables integration with an external database. One of the most common ways to integrate a database is by using Apache Sling Connection Pooled DataSource configuration properties through the configMgr.
The first step is to download and deploy the appropriate MySql drivers in AEM.
Create Apache Sling Connection Pooled DataSource and provide the properties as specified in the screen shot below. The database schema is provided to you as part of this tutorial assets.
Database has one table called formdata with the 3 columns as shown in the screen-shot below.
SaveAndContinue
com.mysql.cj.jdbc.Driver
jdbc:mysql://localhost:3306/aemformstutorial
Assets
The SQL file to create the schema can be downloaded from here. You will need to import this file using MySql workbench to create the schema and the table.
Next Steps
Create an OSGi service to store and fetch data in database