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
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.
Database Forms Use Cases
Finance & Accounting
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.
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
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.
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
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
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
Enterprise grade security
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
What are the 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.
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
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. Live Forms 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
More and more companies are trying to reduce waste in an effort to become “eco-friendly.” But, any large institution will struggle with going completely green. Even when you’re conscious and mindful, it’s easy to generate a large volume of waste in an office or building with a large group of people. In the most recent […]
Timesheet tracking has been around for years. Punch cards, clocking in and out, ID forms, paper forms, Excel – we’ve seen every variant. But, these processes are tedious and HR departments struggle to manage them. They must organize, deal with and approve timesheets for dozens or even hundreds of employees at the same time. In […]
Through the years, we know that customers just want their data so they can use their preferred tools and methods to analyze it. As a result, our product strategy maximizes customers’ ability to push or export form and workflow submission data into other systems. We provide a variety of connectors e.g. the SQL Database Connector, […]
Talent is the most important determinant of success in the 21st century. Talent is scarce and the competition for the most in-demand skills is fierce. Retaining your best employees is harder than ever before. Attracting and retaining world-class talent has become a critical aspect of companies’ futures. According to a Pew Research Center analysis of […]
500 East Main St.
Branford, CT 06405
Copyright 2008-2019, frevvo Inc. All rights reserved.
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