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 and solve the problem quickly if they have visibility into order history from the database. Faster problem resolution leads to happier customers.
As customers interact with your organization online, they often do so using forms. To be truly interactive and useful, these forms need to connect with and access data from internal systems – often SQL databases. Database forms, especially as part of business processes, allow you to bring your operations much closer to the customer and that’s a crucial part of world-class customer service.
Forms are a part of life but they don’t have to be tedious and ugly. Clean, well-designed online forms help customers provide needed information quickly and painlessly. What if your existing employees could do it all using simple visual tools without coding?
Workflow automation is the foundation of digital transformation. But, automating everyday processes isn’t always easy. Dynamic forms, complex routing, e-signatures, mobility and more … it’s a lot to handle and that’s if you can find the necessary programming talent. What if your existing people could do it all using simple visual tools? Watch this brief video to see how easy it is with frevvo’s 100% visual, low-code platform.
To learn more, visit our website, try frevvo absolutely free for 30 days or contact us for more information.
This large international provider of sports betting and casino games in Europe has over 6,000 employees with branches in several countries.
The company uses frevvo with Confluence on daily basis for a multitude of tasks from employee on-boarding to budget management to online ordering. frevvo’s Database Connector allows them to surface frevvo forms and workflows in Confluence that read/write data from their SQL database and easily create dynamic content.
frevvo integrates with our Confluence system as well as other systems without complex APIs. And the best part of all is that frevvo is very cost-effective and feature-rich compared to products that are many times the price.
The reduction of development time to build these business-critical applications has allowed them to focus on other priorities. Business users also appreciate the fact that information is easily available and they have more time to spend with customers.
Today we’re happy to announce the general release of frevvo 7.2. Cloud customers were automatically upgraded on April 29. On-Premise availability is coming up shortly – subscribe to Release Announcements for the precise date. This release also includes upgrades to the Database Connector.
We know that frevvo is powerful software but there’s also a learning curve. frevvo 7.2 is the first in a series of updates this year focused on making it easier to use.
Visual Rule Builder
This release also includes some security enhancements – e.g. user ids no longer appear in URLs and are replaced by opaque UUIDs – and other under-the-hood improvements needed for future ease-of-use improvements.
The DB Connector is one of the most widely used connectors – customers have created all kinds of integrations with their SQL databases. Most of the improvements made in this release are fairly technical and we won’t go into details here. See the Release Notes for reasons to upgrade. We’ve also made several under-the-hood improvements so we can make this oft-used connector easier to use and as point-and-click as possible. We’ll detail those in future blog posts.
We’re excited about this release and several upcoming ones. The focus is squarely on updating and making so many of the good things we do easier to use.
Aero Communications inc. provides customer-focused technology solutions to broadband and wireless providers, businesses, public venues, government facilities, and residential subscribers.
The company was using a number of paper, Excel & InfoPath forms for everyday business processes such as Vehicle Inspections, Facilities Maintenance, Financial Forms and Warehouse Orders. Many of them require approvals forcing employees to email them around and print/sign/scan for approval. In addition, the existing forms could not pull data from SQL databases resulting in excessive and duplicate data entry, errors, corrections and inefficiencies.
“We were looking for a single, affordable solution that could address all our requirements.
frevvo’s modern, online system is easy-to-use, and meets our needs at a reasonable cost. Live Forms is the best web-based forms & workflow solution on the market today for our needs.”
–Adam Wiener, Applications Specialist
Aero Communications considered a dozen+ solutions before selecting frevvo Live Forms because it provided an easy-to-use solution that works with their database, and integrates with Active Directory at an affordable cost.
Day-to-day business activities are simply more useful if they can access information from SQL databases on-demand. If Customer Service has visibility into order history from the database, they can better help the customer. HR applications can access employee data and so on.
frevvo provides a Database Connector that allows you to perform sophisticated integration with your database. From dynamic dependent pick lists to master-detail views to creating and updating records in SQL and running stored procedures, you do it all with frevvo.
Learn more by downloading our new eBook or by watching the video at the links above and visit our website to view customer success stories and signup for a free trial.
Deeply rooted in the National Capital Region and Eastern Ontario for over a quarter of a century, La Cité is the largest French-speaking applied arts and technology College in Ontario.
1200+ registration forms have already been submitted electronically with a 24/7 service offering. Students save time since they no longer have to stand in line for registration. Instead of lining up, they simply complete the process on their smartphones.
La Cité serves a diverse population from students and faculty to a large student body. Students, in particular, prefer to use their mobile phones for almost everything. Yet most of La Cité’s forms and applications were paper or PDF documents that had to be printed out, hand-filled and signed. They didn’t integrate with databases, DocuShare (their document management system) or salesforce.com (CRM).
That means students filling out long forms by hand and standing in long lines to register, internal employees scanning and indexing paper forms and a tedious, inefficient overall experience.
Students love the built-in mobile support. Now that the forms are compatible with devices, 60% of responses have come in on mobile.
La Cité decided that they needed to improve services to students and staff. They selected frevvo Live Forms and, in a matter of months, they’ve replaced several paper/PDF forms with electronic ones. They’re available 24/7, work automatically on mobile devices, and integrate with DocuShare, Oracle and salesforce.com. frevvo forms also work in multiple languages including French, which is the dominant language on La Cité’s campus. Data is pre-populated, frevvo’s build-in validation ensures fewer errors, documents are automatically stored in DocuShare and salesforce and students are no longer standing in line.
Co-Op applications, which used to be paper are now electronic. As a result, the number of applications has gone up from about 10 in previous years to over 70.
The results have been impressive and La Cité plans to roll out several additional forms and workflows in the coming months.
The Road to Hybrid Cloud. The cloud computing model continues to create a larger and larger footprint in the IT landscape as enterprises pursue the model’s benefits including but not limited to: 1) shared resources 2) facilitated access to information and resources from anywhere on any device 3) on demand provisioning and reallocation of computational resources. The greatest benefits are typically achieved using public cloud services however most organizations are unwilling to put ALL their data (particularly sensitive information) into public cloud solutions. In order to still reap the benefits of the cloud computing model, organizations will implement some solutions on internal private cloud platforms.
What is Hybrid Cloud and How Does It Work. A hybrid cloud refers to an environment that runs both public and private cloud services AND provides a way to to share data between them. Typically the data shared with public cloud services is limited and secured/encrypted to reduce exposure. Exposing a server within your firewall to a public cloud service is not what we mean by hybrid. A hybrid cloud connects 2 or more internal and external cloud platforms in such a way that they can exchange information.
What Are the Advantages. A hybrid cloud allows organizations to leverage the efficiency gains of the cloud computing model without having to expose all their data to public cloud services by providing mechanisms to securely share data. Once mechanisms have been defined for exchanging data between internal and external cloud platforms, CIOs can incrementally control what data is exposed to public cloud solutions. The ability to integrate internal data with external/public cloud services is hugely beneficial (if not required) to leverage public cloud services in a compelling and useful fashion.
The Benefits of frevvo. When you sign up for an account on app.frevvo.com, you’re using frevvo in the public cloud. If you deploy frevvo within your organization, you are setting up frevvo as a multi-tenant, private cloud solution. Either way, there are many examples of frevvo participating in hybrid cloud architectures. A frevvo account running in the public cloud could be configured to securely access LDAP information running within a private cloud. Enterprises running frevvo within their private cloud infrastructure can write data to google spreadsheets (public cloud). Another example is utilizing frevvo’s database connector to allow frevvo from either a public or private cloud to integrate with any back-end relational database.
In Summary. This cloud computing phenomenon migrates both, public cloud and private cloud services, to solve your business needs. From small business to large enterprises, being able to keep private information secure as well as hosting public information is very beneficial. As noted on the infographic (pictured to the left) using frevvo in the hybrid cloud is a business strategy to lead you to successful business agility. Our cloud based product is mobile ready, with a drag & drop easy design, that allows you to create custom forms and workflows to increase business agility.