How to add adaptive forms to the MySQL database

  • Go to the URL localhost:4502/system/console/bundles .
  • Click on the install/update button.
  • Click on the choose file option in the popup and select the mysql-connector-j file to check the Start Bundle checkbox.
  • Click on the install or update button.
  • Search for MySql in the config manager and check if the bundle is active.
  • Go to the URL localhost:4502/system/console/configMgr .
  • Search for the Apache Sling Connection Pooled DataSource node in the config manager and open the node in edit mode.
  • JDBC driver class must contain the path of the bundle of MySQL-connector-j.
  • JDBC connection URI must contain the value with the database URL path for ex: 

jdbc:postgresql://localhost:5432/test.

  • jdbc:mysql://[host]:[port]/[schema_name].
  • Enter the user name and the password in the fields present below.
  • Click on the save button to save the configuration of the database.

How to Create from data model:

  • Go to the URL localhost:4502/aem/start.html.
  • Go to the forms and select Data Integrations.
  • Click on Create and select the Form Data Model.
  • Create your Model then we will be able to see our database option.
  • Select your database model and click on create.
  • Select the edit option from the popup.
  • Then expand the data source listed in the left pane.

What is a form data model:

From data model provides us an intuitive user interface and tools for editing and configuring a form data model. Using the editor, you can add and configure data model objects, properties, and services from associated data sources in the form data model. It allows you to create data model objects and properties without data sources and bind them with respective data model objects and properties.

How to add data model objects and services:

  • Go to the URL localhost:4502/aem/start.html.
  • Go to the Forms option on the home screen and then select the Data Integration option from the Forms option list.
  • Then expand the data source listed in the left pane.
  • Select the required data model object and service you want to add to the form data and click on Add Selected.
  • After clicking the Add Selected button we will see the graphical representation of all data model objects and properties added to the form data model
  • All the added Services are listed in the services tab

By Akshit Gahlaut