Integrating with a new database

  1. Create a new empty Data Model ( File > New > Data Model > Provide a name and click Next > Use an empty model as a starting point ).

  2. In the Properties view, select the Generate LC Component and Deploy to LCDS options in AEM forms tab

  3. Ensure that new tables are created in the database by setting the Database Tables option to either UPDATE or RECREATE

  4. In the Properties view, switch to the General tab and enter an appropriate JDBC Datasource name (e.g. enter “java:IDP_DS” to create new tables in AEM forms’s system database) and optionally select an appropriate Hibernate SQL Dialect (e.g. select “org.hibernate.dialect.MySQL5Dialect” when using Document Service Turnkey’s MySQL database).

  5. Add new entities to the Data Model and ensure that you select the Generate Service option in the AEM forms tab in the Properties view for all entities.

  6. Save and deploy the Data Model.

  7. In the Applications view, open the process where you wish to access the database.

  8. Select the Activity Picker and drag it on to a desired swimlane in your process map.

  9. Define the activity with one of the new service operations generated for your data model.

  10. In the Process Properties view, provide Input and Output parameters for the activity.

  11. Connect the new activity box with other activities within the process.