Caspio, an online database tool that allows users to create forms and databases without the need to write code, have announced an upgrade to version 9.0 on 22nd December 2015. Known for its usability and maintainability, this release introduces three major features involving single sign-on, reporting and account security, and some further smaller additions which collectively improve both the security and efficiency of Caspio applications.
SAML Single Sign-On
Caspio has introduced a Single Sign-on (SSO) feature that enables users to use the same username and password for various applications. In fact, Caspio’s new SSO feature allows you to use your own corporate directory service like Microsoft Active Directory to authenticate your Caspio applications. The implementation of SSO in your Caspio applications not only helps you centralize the access management policy for users and applications according to any set internal corporate security requirements, but also helps reduce the number of passwords and numbers to be managed. Many directory services including Microsoft Azure AD, Active Directory Federation Services 2.0 and 3.0, Salesforce, Okta, OneLogin, Auth0 and PingOne are supported by SAML 2.0, which Caspio has adopted.
All it takes to configure SAML Single Sign-On in Caspio is the creation of a new Authentication object:
Pivot Table Reports
Caspio now makes it much easier to create cross-tabulation and summarization reports to use for viewing data from different perspectives with the help of this latest type of DataPage. The information collected helps you discover the insights which would have otherwise been difficult to see. In fact, these Pivot Table Reports can process lots of data and generate reports which effectively aggregate collected data into groups which display subtotals, averages, grand totals, and other similar calculations.
The video will show you how you can create a Pivot Table Report in Caspio:
Customizable Account Security Policy
Anyone signing into their Caspio account can now define a custom security policy. You are at a liberty of setting your own requirements for password expiration, strength, and reuse, and even set your own rules for session timeout, disabling of inactive users, and account lockout. This is an important feature which organizations and corporations can follow to meet both their internal and regulatory security requirements.
Caspio 9.0 release has many smaller additions. A few are listed below.
- The ‘Properties’ area has a new ‘Notes’ field which helps save internal notes for any object in your Caspio account.
- When collapsed, all aggregations set to display ‘Below’ are combined and moved into the grouping row.
- Complete instructions on how to create a password and sign-in to the account are sent by email when you create a new account sub-user.
- Instead of a static email list, notification emails can now be routed to dynamic addresses.
- Table and view datasheets now have keyboard hotkeys.
- Number and Date columns are automatically right-aligned in tabular reports, while other data remains left-aligned with the new ‘Auto-Align’ setting.
- All it takes is clicking on the Caspio’s Login screen’s ‘Forgot Password’ link for Caspio account sub-users to reset their passwords.
For more thorough details about this upgrade, you can check out the release notes here.