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).

• Generating Unique and Sequential ID Values
• Pulling Data From SQL Into Forms
• Conditional Lists In Data Grids
• SQL Query Form Actions
• How To Perform a Data Lookup in GlobalForms 10
• Securing your SQL Server Data Lookups
• Sending Form Data to Microsoft SQL Server
• Working With Multiple Databases