new features in formspider 1.9
TRANSCRIPT
Welcome to the
Webinar
Starts at 14:00 CEST (07:00 EST)
• Q&A
• About the Company
• Formspider Benefits• New Features in Formspider 1.9• Quick Update about Our Progress
Yalim K. Gerger
Software EngineerFounder
About Gerger
- International Worldwide recognition with Formspider. Customers in 26 Countries.
- Local Recognised by the Turkish Government as an R&D company. Founding member of Turkey Oracle User Group.
- Basics Founded in 2005. Released Formspider Beta in February 2011. Formspider 1.0 in May 2012
What Happened in 2015?
• Customers in 26 countries Germany, UK, Netherlands, France, Greece, USA, Canada, UAE, Argentina, Brazil, Peru, Latvia, Russia, Indonesia…
• Forms Modernisation Rollouts
• 50+ Companies use Formspider• Hundreds of Developers
• Our Customers Love Us! :-)
Customer SpotlightTEAM GmbH rebuilt their flagship application ProStore (intralogistics and warehouse management) with Formspider
Same development team.
From Oracle Forms to Single Page Web Application running in the Cloud in a year. (>400 Forms)
Did you watch the demo? Watch the Demo
Works on desktops, laptops, iPads and other tablets.
New Features in Formspider 1.9
New Themes» Modern, flat design
» Different color schemes
» Easy to customise
Stateful Database Connections
Stateful Database Connection
• An Oracle Forms application uses one database session while it is running
• Web Applications pick a database connection from a pool of connections. So each time the application executes a piece of code, it might be using a different database session
• Most Oracle Forms Applications are developed assuming a single session during execution. For example, they take advantage of package globals.
• Formspider 1.9 supports stateful connections to the database
• Prevents opening unnecessary sessions
• Avoids unauthorised stateful connections
• One line of code
• Makes Oracle Forms migration a lot easier
Stateful Database Connection
• Can switch between two modes
ROWID Support for DML
ROWID Support For DML
• Issue DML to Datasources with Multi-Column Primary Keys
• One CheckBox
• Can be used with Datasources which have a single column Primary Key
Dynamic Where Clauses
Dynamic Where Clauses
• where (value_nr=:bindvar1 or :bindvar is null) and (order_nr=:bindvar2 or :bindvar2 is null) and…
• This is suboptimal
• Ignores bind values with null values and automatically generates the correct where clause with optimal performance
• Mix and match predicates, change where clause structure
search screen wizard
Search Panel Wizard
• Easily create a beautiful fully functional search screen
• Wizard generates both code and UI
• Integrated with dynamic where clauses to generate the optimum SQL
• Configurable
• Dynamic Where Clauses
• Beautiful New Themes
• Stateful Database Connections
• Search Panel Wizard
Formspider 1.9 New Features
Version 1.9 is Available This Summer
Built-in Multi Browser Support
Scales instantly with Oracle RAC
Cloud Ready
Formspider streams applications
Built-in Performance Best Practices
Built-in Security Best Practices
Built-in Authorisation and Authentication
Built-in Support for 9 out of the 10 most common security vulnerabilities
Git Integration for Version Control
Both UI and PL/SQL is managed in Git
Branching, Automatic Merge, Team Development
100% PL/SQL
100% PL/SQL
Git Integration for Version Control
Both UI and PL/SQL is managed in Git
Branching, Automatic Merge, Team Development
Built-in Performance Best Practices
Built-in Security Best Practices Built-in Authorisation and Authentication
Built-in Support for 9 out of the 10 most common vulnerabilities
Formspider streams applications
Scales instantly with Oracle RAC
Cloud Ready
Built-in Multi Browser SupportDynamic Where Clauses
Beautiful New Themes
Stateful Database Connections
Search Panel Wizard
Coming this fall…
(Formerly ING Insurance). Turkey. Agency Portal, Forms Modernisation.
Turkish Telco. Logistics Reports.
Dutch Branch. Forms Modernisation of Logistics ERP.
Czech Republic .Logistics ERP
Azerbaijan. Core Banking
Germany. Warehouse Management System.
USA. Global manufacturer of equipment used in product assembly
Argentina. Government of Rio Negro. Forms Modernisation.
Peru. Financial Systems
United Kingdom
Lithuania
Italy
Turkey. Campaign Management.
Greece
France CyprusGermany
Azerbaijan
Italy
www.formspider.com