Configure Data Source

There are many ways with which AEM enables integration with external database. One of the most common & standard practice of database integration 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.

data-source

Database has one table called formdata with the 3 columns as shown in the screen-shot below.

data-base

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.

NOTE

Please make sure you name your datasource SaveAndContinue. The sample code uses the name to connect to the database.

Property Name Value

Datasource Name| SaveAndContinue
JDBC Driver Class| com.mysql.cj.jdbc.Driver
JDBC connection uri| jdbc:mysql://localhost:3306/aemformstutorial

On this page

Adobe Summit Banner

A virtual event April 27-28.

Expand your skills and get inspired.

Register for free
Adobe Summit Banner

A virtual event April 27-28.

Expand your skills and get inspired.

Register for free
Adobe Maker Awards Banner

Time to shine!

Apply now for the 2021 Adobe Experience Maker Awards.

Apply now
Adobe Maker Awards Banner

Time to shine!

Apply now for the 2021 Adobe Experience Maker Awards.

Apply now