Vinyl Reference Guide¶

Vinyl Features¶

Vinyl Lite Integration™: Easily leverage data from different sources without requiring ETL
Auditing: Configurable auditing available to track application changes
Data Import/Export: Supports the ability to import and export data from external sources
Batch Processes & Scheduling: Automate scheduled processes
Integration: Supports integration with any API or data source
Extensibility: Extend Vinyl by connecting third party systems, leveraging plug-ins, or code if needed
Universal Development Language: Use our patented mvSQL to build logic and views of data
Low-Code IDE for App Development: No code required yet supports code if needed
Customizable App Theming: Full control over application look and feel
Responsive Design: Applications automatically respond to multiple devices
Workflow Automation: Implement and automate workflow business processes
Automatic Notifications: Configure workflow-triggered notifications
File Management: Upload, download, store, and display files
Multilingual Translation Engine: Translation service utility built into the framework
Integrated Debugging Engine: Developer access to log files and error messaging
Release Management: Integrated utility to package, deploy and install app across the lifecycle
Security: Built-in features to manage and maintain security
Full Access Control and Permission Management: Developer manages through the framework
Accessibility Support: WCAG 2.0 support, keyboard hotkeys allow navigation
Release Authentication: Supports industry-standard methods for recognizing and verifying users

Recently Released Features (2018 – 2023)¶

Table Wizard: Enhanced automation with workflows to build out tables in the Data Layer
Page Wizard: Streamlines and automates the process of adding pages to an app
Panel Wizard: Simplifies the process of adding a panel to a page
Control Wizard: Simplifies the process of adding a control to a page
Column Templates: Vinyl learns the names, data types, and control settings as you build apps and reuses those setting
Live Designer: Brand new much-requested Live Designer feature
Marketplace: Accelerate app development with demo application, connection, and other reusable components
Design Center: Shortcut landing page for developers to rapidly build out and maintain apps
Styles: CSS stylizing of elements is elevated to the UI layer for simplified control over the look and feel
Enhanced Security Logs: Visibility into User password change and reset events
Security Provider Configuration: Now supports exporting, importing, and validation
Vinyl Startup: Handles configuration on startup for License, Admin password and policy, Security Providers, and Sites
OpenID Connect (OIDC): Allow Vinyl app users to log in using the OpenID Connect protocol
Group Control: New container provided for controls belonging in a logical grouping
Stacked Area Chart: An extension of a basic Area chart
Button Controls: Enhanced and simplified button options
Wizard Pages: Enhanced to include a progress bar, improved look and feel
Bitwise Operators: Vinyl adds support for bitmask/flags and bitwise operators
Integrated Help: Quick access to Success Central, Release Notes, Community Forum
Temporary Tables: Supports in-memory storage of perishable fields
Enhanced Password Policy Options: Additional options available to strengthen security
App Diagrams: Network graph provides visualizations and insight about apps
Real-Time Language Translation Service: Translations service now runs in real-time
Updated Chart Library: Highcharts reporting engine upgraded to the current release
System Menu Toolbar: Provides quick navigation shortcuts to Users
Create New Application: Simplified workflow to build a new app from one screen
Auto-build Accelerators: Data Layer shortcuts to help automate app development
Expiring API Keys: Supports enhanced security with integrated APIs
Managed Tables: New table type to track data on User, Window or Session
Widget Inline Editing: Vinyl now supports the ability to edit Widget files within native Vinyl
Native Mobile Controls: New Controls support more granular handling over mobile display
Vinyl Mobile App: Download and install the Vinyl Mobile App, connect to existing Vinyl apps
Mobile Push Notifications: Support for sending iOS and Android push notifications
Data Source Connection Wizard: New workflow to step through connecting a data source
Site Menu: Redesigned to provide an improved and customizable landing page
Visual Rule Builder: New logic editor featuring drag and drop and real-time results
Table Designer: Improved designer for creating and maintaining tables
Application Workbench: Centralized location provided for improved development experience
Page Wizard: New wizard process available to step through creating a page
Auto Build: New feature to rapidly build out baseline pages
Create Application Wizard: New wizard process to step through creating an application
Enhanced Menus: Menus can be driven by data objects, support icons, badges, and buttons
Network Graph Chart: New chart illustrates relationships between objects
Tabs and Accordion Options: New UI options to display/hide information within regions
ACE Editor: Robust and intelligent editing available for working with data objects
Customizable Help Text: Tooltips available for customization throughout the framework
Cross Data Source Table Inheritance: Inherit and extend data from distinct data sources
User Time Zone and Language Support: Automatically detect and persist user data
Bubble Charts: Chart used to represent three dimensions of data
JSON Integration with Charts: Customize defined aspects of chart appearance
Customizable Error Messages: Substitute error messaging for end users
Full Audit: Configurable audit to track application changes
Gantt Charts: Chart type used to plan and schedule projects
Secure Developer Silo: Partition off areas of framework for users
REST API Support: Integrate and extend an app with REST API (SNAPI)
iFrame Embed Support: Display Vinyl through an iFrame
Password Expiration: Configure passwords to expire for users
Custom Login Screen: Override the default application login screen
Application Row-Level Security: Configure security access within an application
User-Defined Logical Data Types: Create custom Logical Data Types
Smart Validations and Auto-Fill: Enable validations and auto-fill for Logical Data Types
Reporting: Application reporting provides insights and auditing
Data Source Connection Support: Each release adds support for additional data sources

Systems¶

Native RDBMS¶

Azure SQL
DB2
DB2i
DB2z
Denodo
Microsoft SQL Server
Microsoft SQL Server PDW
MySQL
Netezza
Oracle
PostgreSQL
Redshift
SQLite
Teradata

CData ADO.NET¶

Active Directory
Airtable
Apache Hive
CosmosDB
DynamoDB
Dynamics
IMAP/Pop3
Facebook
Gmail
Google Analytics
Google BigQuery
Google Calendar
Google Contacts
Google Drive
Google Sheets
HubSpot
JIRA
Magento
Microsoft Access
Microsoft Exchange
Microsoft Office 365
Microsoft SharePoint
MongoDB
NetSuite
Office365
PayPal
QuickBase
QuickBooks
SAGE Intacct
Salesforce
SAP Concur
SAP ABAP
SAP ABAP over RFC
ServiceNow
Snowflake
Sybase
Twilio
Twitter
VeevaVault
ZohoCRM

REST & OData¶

Infor M3
Site configured REST
SuccessFactors
OData
See API Repository: Some REST data sources Vinyl has connected to for others

Other¶

File System
S3
SFTP
Azure Blob Storage
SharePoint as File System
Schema Browser

Security Providers¶

JWT SSO
API Key
HTTP Basic Authentication
Integrated Windows Authentication
Web Access Management
HTTP
OData
RDBMS
SAP OData Services
SuccessFactors OData
Application Authentication
OAuth
Salesforce
SAML
WS-Federation
Active Directory
Local User
SuccessFactors Password
SAML Identity Provider
User Provisioning
Rewrite URL
OpenID Connect (OIDC)