The Easiest Way to Connect Web Forms to SQL Databases
Use our simple database connector to securely integrate your web forms to databases. Easily create dynamic picklists and master-detail forms, perform lookups, and invoke stored procedures against any SQL database.
Deliver engaging, dynamic user experiences to customers and partners without programming.
Powerful, interactive forms connected to SQL databases
Web forms are a big part of customer interactions. They're simply more useful if they can connect to business data to retrieve part numbers, customer information, order line items, and more in real-time.
Incorporate data from SQL to deliver a quality user experience and gain a competitive edge.
When you implement form to database integration using frevvo's connector, you’ll reap many benefits:
Reduced data entry and improved productivity
Fewer errors and omissions in your data
Automatically managed connection pools, retries, etc.
System protection against attacks like SQL injection
Sophisticated queries such as SQL joins
Secure, encrypted connections
Database forms in hours rather than weeks of coding
Database forms and workflow in 3 easy steps
1. Define SQL query
Configure the connector. You can use a standard SQL
query or a stored procedure.
2. Generate the form
Add a data source to the form and generate controls
corresponding to the SQL query.
3. Link to the query
Configure the form or workflow so that it links to the
query to read from or write to the database.
Pick lists (or drop downs) that are populated on-the-fly from a SQL database are a very common business scenario. These are lists of things that change from day to day. Examples include available items, eligible users, current printer models, etc.
With frevvo's database connector, it's very easy to integrate this highly dynamic behavior in your web forms. Define the appropriate SQL query, give it a name, drag and drop a pick list onto your form, and connect the pick list to the query using a simple business rule.
Another common scenario is multi-level picklists where the choices in a list vary depending on what was picked in the prior one. For example, select a car brand and the next picklist displays the list of models for that brand. Select a model and the third list changes to display the list of trim levels, etc.
It's very easy using our database integration. Once again, define the queries, name them, drag and drop as many picklists as you need, and connect each one to the appropriate query using a simple business rule which passes the value of the prior picklist to the query.
Select a customer and view contact details or select an item and view specifications – master-detail interfaces are extremely common in business forms and workflows.
It's very easy with frevvo. Simply define and name the appropriate SQL query in our database connector, add a data source to your form, generate controls for the query, and connect the data source to the SQL query. That's it. Text, date, money and other controls will be generated automatically depending on the SQL column type. You can drag and drop to customize the layout including creating multi-page forms.
There's nothing to program; your form will automatically insert data into fields from the results of the query.
Items in a purchase order, individual expenses in a reimbursement request, students taking a particular course – tables like these are another form of master-detail relationship where the number of rows varies.
With our database integration, this extremely complex and highly dynamic scenario is a piece of cake. As before, define a query, name it, add a data source, generate controls, and configure a data source to use the query. frevvo does the rest. The form will automatically add or remove rows from an on-screen table control and update data on-the-fly. You won’t have to write a single line of code.
Sometimes, it's necessary to create, update or delete records in database tables e.g. when a customer places a new order or a student changes their course enrollment.
With the database connector, it's straightforward. SQL queries can contain all CRUD operations and the form can be setup to invoke any of them simply by changing the HTTP method in the configuration wizard.
The form can even read data from a query, display it, allow the user to make complex changes e.g. add a new line item, modify a second one, and delete a third. When submitted, the connector will run an Insert query for the added item, the Update query for the modified one and the Delete query for the removed one and correctly update database tables. Automatically!
Re-use stored procedures and connect to multiple databases
Many businesses have a complex SQL database infrastructure with multiple databases, dozens of tables, hundreds of stored procedures and a huge volume of data.
Use our DB connector and you can simultaneously connect to as many databases as you want. They don’t even have to be the same. You can combine SQL Server, Oracle, and MySQL data in the same form.
Run existing stored procedures to insert or update data and reuse functionality that is tested, reliable, and stable.
Connection pools, custom formats, Unicode data – we handle all the details
Integration with SQL databases is not easy and even experienced developers can struggle with it. There are so many things to manage – connection pooling and releasing connections, multithreading, custom date formats, nillable columns, character encoding, and so on.
Use our connector and you don't have to think about any of these things. frevvo takes care of all the details. It works with international characters in your SQL, normalizes dates, handles UTF-8 encoded data, automatically recycles connections, and more. Your database forms will just work.
Secure, reliable database forms for your enterprise
frevvo is built for businesses and includes everything you need to meet real business requirements.
Secure: Use your existing provider e.g. Active Directory or SAML to authenticate. Individual database queries can also be secured.
Mobile: All functionality including dynamic picklists and master-detail views work automatically and look great on all devices.
Accessible: ADA and WCAG compliant.
Worldwide language support.
Robust: The system automatically monitors and protects against SQL injection, CSRF attacks, and more so you don’t have to.
Flexible: Cloud-based or
Ready to create your own dynamic, database forms?
Sign up for a free, fully-functional 30-day trial
and get started now.
"We were looking for a single, affordable solution
that could replace paper, Excel & InfoPath forms and
work with our SQL database. frevvo is the best forms
& workflow solution on the market today for our needs."
Adam Wiener, Applications Specialist
frevvo forms look good and they're very user friendly.
They also integrate with our existing business systems. Live
Forms is the best web-based forms & workflow solution
on the market today."
Michael Riggirello, MIS/IT Systems Administrator
"We needed an affordable solution that worked with
our existing PeopleSoft and HR Portal. frevvo has the
best combination of usability, price, support and business
capabilities on the market today."
Roger Rudenstein, ERP Manager
"Our primary concerns are always adoptability and
simplicity. There are many workflow solutions on the
market today but none offers the balance of simplicity
and flexibility found in frevvo."
Mike Malone, Director of Technology
Mercy Ships has deployed over 70
forms & workflows integrated with Confluence
"We wanted a single, affordable solution that would be
able to address our forms, workflow and document signature
requirements. frevvo's modern solution is easy-to-use
and meets all our business needs at a reasonable price."
Chief Information Officer
We value your privacy and want you to clearly understand the
control you have over your information on all frevvo.com sites.
personalize content and to analyze traffic. By using our website, you