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
Employee Leave Management is one of the main things HR departments handle. But, many companies get bogged down in unnecessarily long, complicated processes. Here are 5 common mistakes that can hurt your company, and ways to fix them. 1. Creating a “Vacation Shaming” Culture In many companies, employees have to deal with comments about choosing […]
Are you ready to replace your expensive paper processes with automated, efficient, electronic forms/workflows? Looking for a low cost, low code workflow management system to quickly automate processes, enhance productivity and drive down costs? Not sure where to start? What is Workflow Management? A workflow is a repeatable set of tasks performed to achieve a […]
In life or in business, risk taking has benefits and may even be an essential ingredient of success. Quite the opposite when it comes to procurement – the last thing you want is risk. A smoothly functioning procurement process is standardized and dependable. Why is it important to reduce procurement risk? Procurement is no longer […]
Every time we think we’ve got a handle on automation, new statistics emerge to challenge our perception. Just this month, McKinsey released a new report about the future of women at work, saying that an estimated 40 to 160 million women around the world will need to transition their skills. But the report also pointed […]
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