GlobalForms supports saving data to and reading data from SQL 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).
-
Forms database setup / Resquel -
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