Data Integration Documentation

The "Data Integration" category offers a comprehensive collection of resources for seamlessly integrating data within the nFORM system. Whether you need to process submission data, dynamically load data into a data source, or pre-fill data into nTEGRATE, you'll find step-by-step instructions and best practices in this section.

Documents in this category:

• Processing Submission Data: This guide provides instructions on how to leverage nTEGRATE's near real-time updates from nFORM, enabling efficient data analysis and reporting without impacting nFORM's responsiveness. Basic SQL knowledge and the ability to connect to your nTEGRATE database are required.

• Guide for Loading Prepopuation Data into nTEGRATE: This guide explains how to prepopulate nFORM forms with data from your existing systems, a feature that simplifies form completion and improves accuracy. It addresses the challenges of aligning nFORM's structure with nTEGRATE's data model, providing step-by-step instructions for successful implementation. SEE MORE STREAMLINED APPROACH BELOW called the “WRK Table” Approach.

• Loading Dynamic (Lookup) Data into nTEGRATE: This guide provides detailed instructions on creating and managing dynamic lookup tables in nTEGRATE to enhance the user experience within nFORM. Learn how to efficiently populate these tables with data using various methods, including manual SQL insertion, imports from external databases, and stored procedures. SEE MORE STREAMLINED APPROACH BELOW called the “WRK Table” Approach.

• Guide to “WRK Table” Approach to Prepopulation: This guide explains how to prepopulate form data and lookup data using a more streamlined approach using the “integrate” schema database objects.