AEM Forms & Databases

Integrate your AEM forms with databases such as Microsoft SQL Server and Oracle. This course shows you the secrets of integrating AEM adaptive/responsive forms with your company's databases and other enterprise systems. In addition to learning concepts and theory about AEM Forms, you will complete hands-on exercises and develop a complete working AEM application. This course shows you how to prefill forms with data, use data within an adaptive form, and process a form submission. AEM form submissions with and without attachments will also be covered

Course Objectives

• Understand AEM adaptive and responsive forms
• Configure AEM Forms with Microsoft SQL Server
• Write Web Services to process form submissions
• Prefill a form with a prepare data process and a web service
• Extract data and attachments
• Write SQL Statements to retrieve data and prefill a form
• Configure an AEM adaptive form
• Call Stored Procedures to process form submissions
• Understand and use the Adobe JDBC services
• Create an AEM adaptive form
• Process multiple form attachments
• Store form attachments in a JCR (Adobe CRX) and a File System
• Add data formatting to your form and process
• Add data validation to your form and process
• Understand JDBC (Java Database Connectivity)
• Understand XML Schema, XML Data, and data binding

Course Outline

Module: 1

• Reviewing the Database
• XML Schema & Data
• AEM Forms
• JDBC
• Server Configuration
• Developing your AEM Form
• Configuring your AEM Form
• Developing Processes

Module: 2

• Prefilling adaptive forms
• Processing submissions
• Using Web Services
• Form Finalization
• Processing attachments
• Storing attachments
• Integrating your application
• Testing your application

Who Should Attend

Designers, Developers, and IT personnel who need to integrate AEM forms with databases. No previous experience with these technologies is required.