Using SQL Data Sources

GlobalForms supports saving data to and reading data from Microsoft SQL Server data sources.  To leverage SQL accessibility, you will need the name of a SQL Server instance, a database in that instance, a username and password with access to the tables you intend on reading from or writing to, and you must ensure your SQL Server is configured to listen over the TCP/IP protocol.

Connecting to SQL data sources is helpful if you need to save data submitted from a form to SQL database.  Remember, GlobalCapture natively supports exporting data to a SQL database, so while you can send data directly to a database, it may be more beneficial or easier to use the Data Export Node in GlobalCapture. Use a SQL Query Form Action to save to SQL, or to generate unique IDs for submissions (Purchase Requisition Number for example).