2016 Actian Technical User Group Presentations

Click on the links below to download copies of the Ingres and OpenROAD presentations. Click on these links to access DataConnect, Versant and PSQL presentations.


Ingres and OpenROAD Development Update (Session for Ingres and OpenROAD)
A review of the latest Technical Preview of Ingres 11 (including how 'clonedb' works for Ingres) and what to expect for OpenROAD.
Speakers: Alex Hanshaw, Director of Engineering, Actian and Chris Clark, Engineering Manager, Actian

HSS Hire Case Study: The Evolution of Spanner - Extending an Enterprise Ingres Application with DataConnect
Spanner, an ABF Ingres application, originated more than 20 years ago to manage many of the business processes at HSS Hire (transactions, HR records, marketing, product acquisition). As HSS moved to enable a web presence for their customers (via Live Hire), moving data from Spanner to the web and back required various bespoke integrations that were difficult to maintain and hard to extend. This session will describe how HSS Hire used a combination of Ingres, OpenROAD and DataConnect to transform the original Spanner application into a key part of a flexible and much more agile development infrastructure and deliver improved customer experience via web access (including the behind-the-scene connections with legacy and 3rd party systems).
Speaker: Kevin Price, Business Systems Director, HSS Hire

Trace Points Part 1
The first half of a two-part session will introduce two new trace facilities. SET Session_TRACE/Server_TRACE is a successor to an extension of the existing SC930 trace point, with new features designed for the troubleshooter. SET TRACE AT produces SQL or SQL-like representation of a query as it is flattened, transformed and rewritten by the DBMS server.
Speaker: Karl Schendel, Software Development Architect, Actian

Trace Points Part 2
The second half of the Trace Points session will cover the 'dotty" trace points, which enable graphical display of a query's parse tree and data structures at various points. We will also do a short review of the "classic" trace points, such as DM420 and OP150, and touch on some useful but lesser-known trace points: QE11, QE88, QE89/93 and SC916.
Speaker: Karl Schendel, Software Development Architect, Actian

ESRI Plug-In and R-TREE Indexing with 3D Datatypes
This session will cover the new ESRI plug-in and improving query performance using R_TREE indexing with 3-D datatypes. We will also cover the expanded SQL function support for 3D types in Ingres 11.
Speaker: Darren Horler, Engineering Manager, Actian

Ingres Backup in the Cloud
This session will provide an overview of cloud technologies and scenarios where cloud usage makes sense. We'll also dive into the key features currently being developed for Ingres database backup as a cloud service. The backup service takes a hybrid approach with an agent running within the Ingres install utilizing a cloud based backup service. This session will include a live demo of the current capabilities of the Ingres backup service.

Speaker: Jim Falgout, Chief Technologist. Actian

Ingres Upgrades Made Easy - A Session for Technical and Non-Technical Users
This session will walk through both the requirements around the planning and performing an Ingres upgrade. We'll discuss the resources, tools and actions required for an upgrade. The session will also review a case study of an Actian Services managed Ingres upgrade for a high street retailer including lessons learned in the process.
Speaker: Peter Lydon, Principal Consultant EMEA Services


OpenROAD Daily Build and Test Automation
This session will share experiences of the OpenROAD Development team when automating the tasks of daily OpenROAD builds (runtime and 4GL images) and regression testing. It will give an overview of the approaches used on Windows and Unix and cover the challenges that have been addressed.
Speaker: Bodo Bergmann, Senior Software Engineer, Actian

GUI Testing Experiences with OpenROAD
This session will provide a general overview of automating OpenROAD GUI testing with Smartbear's TestComplete tool. We will discuss using TC, some details of the implementation, the test creation process and source code control integration. The session will also include a walk-through of creating a test and working with source code control integration.
Speaker: Jason Boissiere, Senior QA Engineer, Actian

64-bit OpenROAD
This session will review recent experiences with new releases on 64-bit platforms, including changes to system classes, COM/ActiveX support, 3GL procedure calls, remote access to the OpenROAD Server on Unix (without DCOM), and special changes on Unix.

Speaker: Bodo Bergmann, Senior Software Engineer, Actian

OpenROAD Server for OpenROAD and ABF Developers
This session will cover one methodology of moving an OpenROAD "thick" client application to "thin" client technologies, thereby making use of the OpenROAD Server. We will also cover the use of non-OpenROAD frontends to connect to the OpenROAD Server and use the Business Rules defined within. The session will also cover moving ABF Forms to OpenROAD Frames, making it easier to convert ABF applications to OpenROAD.

Speaker: Sidney Glenn, Principal Support Engineer, Actian

OpenROAD Script Editor and Other New Features
OpenROAD has added several new features since 6.2 became generally available. This session will cover those features including special focus on the new script editor which includes syntax highlighting, standard keyboard controls and more. We'll cover how the editor was integrated into OpenROAD, how users can customize the editor to create their own plugins and close with a brief discussion of potential editor features.

Speakers: Donald Criley, Architect, Actian and Chris Clark, Engineering Manager, Actian

OpenROAD 6.2: Some Useful How-To's
The new facilities in OpenROAD 6.2 enable some useful features to be implemented much more quickly and simply. This presentation shows you exactly how to set up some of these, including: Parsing string elements; Sort arrows in TableField column headers; Animations; Field-local context help; combined left and right-aligned toolbars; and more if time permits!

Speaker: Sean Thrower, Principal Support Engineer, Actian

©2016 Actian. All rights reserved. | Privacy Policy | Terms of Use

Connect with Us