Please rotate your device.

Easy Database Forms

Dynamic pick lists, Master-detail, Lookups

Stored Procedures, Secure Queries, All SQL Databases.

Got SQL? Integrate forms & workflows with any database to create truly engaging user experiences.

Powerful interactive forms
connected to SQL

Digital transformation is all about quality user experiences. Online forms are a big part of customer interactions and they're simply more useful if they can connect to your business data to retrieve part numbers, customer information etc.

Use frevvo's database connector together with our drag & drop designers to create highly dynamic forms connected in real-time to your back end SQL databases.

Key Benefits

Simple Integration: SQL Queries

Integration does not require complicated programming or knowledge of esoteric technology. You deal with familiar SQL queries and stored procedures and configure frevvo's Database Connector.

Ease of Use: Connected Forms

Business forms such as Purchase Requests, Patient Medical History, Student Registration etc. are more useful if they can pull information from SQL databases. Users must complete fewer fields, they're more likely to be error-free and more likely to successfully submit your forms.

Complete: CRUD Operations + Stored Procs

The Database Connector supports Create, Retrieve, Update or Delete operations on SQL databases. It's also smart enough to automatically perform the right database operations depending on actions taken in the form. You can even run stored procedures from the connector and connect them to forms.

Flexible: Works with any database

frevvo's integration allows you to integrate with any SQL database that has a JDBC driver (most databases have such a driver freely available). You can also simultaneously connect to multiple different databases and even read from / write to multiple databases from a single form.

Secure Connectivity: Query Keys

The Connector is accessed via secure HTTPS, it's automatically protected against SQL injection and you can also protect your SQL queries using custom query keys resulting in a secure integration with your database.

Connect from Cloud or On-Premise

You can connect forms & workflows running in frevvo's Cloud or in your own data center to the database connector. Obviously, you must deploy the connector in a location where it can access the SQL database.

Database Forms Users

  • Automate manual work: Purchase Requisitions, Sales Orders, Invoices, Expense Reports and other day-to-day processes in the Finance Department are simply more useful if they can connect to back end systems such as SQL databases.
  • Dynamic, database forms improve productivity: Your users don't need to manually fill in data such as Cost Codes or Project Numbers that can be pulled from a SQL database and automatically populated.
  • Reduce errors and delays due to corrections: When data is filled in automatically, errors and omissions are less likely. User-entered information can also be validated on-the-fly against the SQL database reducing the need for later corrections.
  • Automate manual work and reap huge benefits: HR specialists spend over 40% of their time on administrative work such as re-entering data from one system to another. In many cases, SQL integration can drastically reduce the need for this tedious and error-prone data entry.
  • Dynamic, database forms are easier to complete: HR forms can often be very long. The unfortunate thing is that most of the information is already known to the organization often in a SQL database. Pulling in data from employee records simplifies the process of filling out long forms for employees.
  • Automatically generate Government documents: New Hire On-Boarding often requires employees to enter information and sign forms over and over. Eliminate duplicate data entry using electronic signatures and custom PDF generation. With frevvo, the generated PDF (e.g. a Federal W-4 or I-9 form) has all the data as well as the signature transferred from the electronic form.
  • Database Integration is now easy: Customers have created complex forms that work with their SQL database in hours and days rather than weeks of coding, testing and debugging. The DB Connector is easy to use yet powerful enough to address sophisticated SQL queries and stored procedures.
  • Automate internal workflows like I.T. On-boarding for new employees: Provide new employees with access to systems, network file shares, equipment and perform other on-boarding tasks efficiently. There's no need for unnecessary paperwork and duplicate data entry.
  • Enterprise grade security and capabilities: frevvo's systems and procedures ensure that your data is always encrypted and safe. The database connector automatically protects against attacks like SQL injection. Other capabilities like Accessibility, Multi-language support, and AD/SAML integration for SSO, give you the confidence that frevvo dynamic forms will meet all your enterprise needs.

Your electronic forms in 3 easy steps

Our Customers say it best

Aero Communications Inc.
"We were looking for a single, affordable solution that could replace paper, Excel & InfoPath forms and work with our SQL database. Live Forms is the best forms & workflow solution on the market today for our needs."
Adam Wiener, Applications Specialist

Dynamic Customer Info
Master-Detail

Master-detail form gets information from a SQL database.

M
Dynamically get customer info from a database. We're updating this example to demonstrate integrating with a sample SQL DB containing student records.

Sales Orders
Repeating Line Items

SQL integration dynamically displays line items in a sales order.

M
Powerful online forms and approval workflows that integrate with your SQL database to dynamically retrieve information, create & update it.

E-book – 06 ways you
can use frevvo + SQL today

Use cases for frevvo & SQL database integration.

M
E-forms & workflows are simply more useful if they are integrated with internal systems such as SQL databases. With frevvo, anyone can do it.

Fresh from the blog

How to easily create Dynamic Database Forms
Wednesday April 17, 2019

Practically every organization has at least one SQL database and often many of them. Many day-to-day business activities are simply more useful if they can access information from SQL databases on-demand. For example, when a customer calls about a mistake on their order, your Customer Service personnel will be able to better help the customer […]

The post How to easily create Dynamic Database Forms appeared first on frevvo blog.

frevvo earns Great User Experience and Rising Star Awards from CompareCamp
Tuesday April 16, 2019

A leading business software review site recently awarded frevvo’s visual Form/Flow builder two major recognitions: the 2019 Great User Experience and Rising Star Awards. After a comprehensive analysis of the frevvo platform features, the review team concluded that “frevvo is a low-code development platform designed to create dynamic forms and to build their workflows. It […]

The post frevvo earns Great User Experience and Rising Star Awards from CompareCamp appeared first on frevvo blog.

A Comprehensive Guide To An Efficient Time Off Request Form
Wednesday April 10, 2019

What does a typical vacation process look like? If you’re like many other businesses, your HR department is overloaded with paperwork. Honestly, that’s a shame – wouldn’t you rather have them focus on attracting and recruiting talent instead of sifting through endless paperwork? An automated time off request form saves valuable time for any HR […]

The post A Comprehensive Guide To An Efficient Time Off Request Form appeared first on frevvo blog.

The Ultimate Guide to Online Sales Order Forms that Boost Sales (with Examples!)
Monday April 08, 2019

How efficient is your sales process? Although it’s not always easy to admit, many businesses know that their sales process isn’t as efficient as it should be, especially when it comes to sales order forms. And this isn’t something to scoff at – it’s most likely costing you customers. A poor sales order form can […]

The post The Ultimate Guide to Online Sales Order Forms that Boost Sales (with Examples!) appeared first on frevvo blog.

Greater Productivity Starts Here

We value your privacy and want you to clearly understand the control you have over your information on all frevvo.com sites. This website uses cookies to personalize content and to analyze traffic. By using our website, you consent to our use of cookies. Please refer to our updated Privacy Policy effective May 25, 2018.

Accept and Dismiss