Actian Academy

Reset

Welcome to

Actian Academy

Product Courses

For each Actian product or service comprehensive training is available for you to take up. We have provided you with this library of self-paced training to assist you to become proficient and confident when using Actian products or services. Please browse or search our extensive training library.

We know different personas, from your team, will engage with Actian products or services. We have curated Learning Paths for our products and have attempted, where possible, to tailor the Learning Paths towards a persona to ensure specific training for the persona is provided.

Zen Vector Intermediate Beginner Developer Administrator Self-Learning DataConnect Actian Ingres Actian Data Platform Enterprise Data Integration Edge Data Management Advanced OpenROAD Operational Database DataFlow NoSQL Getting Started Course Catalog

Actian Certification is the ultimate benchmark that recognizes the skills, expertise and real-world know-how of today’s Actian product specialists. Whatever your role, achieving your goals starts with becoming Actian certified.

Communities & Resources

The training provided here is to assist you to engage with Actian either via our active community, raising a support case or opening an online chat with one of our expert support team.

Creating a Tag property type

A property is a component of the metamodel used to store metadata specific to a given item. It allows providing context and/or categorizing the items in the catalog. The Tag property type is a flexible property type that allows you to dynamically create values without being limited to predefined values. You can assign multiple tag values to an item.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation

Keynote Speeches

Configuring a System Template

A System Template is a structured framework used to define and organize metadata for a specific type of information asset. Within Data Intelligence Platform Studio, templates help standardize how assets are described and managed. In this video, we'll walk through how to edit a System Template for catalog design in the Actian Data Intelligence Platform.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation

The Actian Data Intelligence Platform Metamodel

At the core of the Actian Data Intelligence Platform is the data catalog or the Meta Model. It is here that you are able to review, maintain and enrich the information held about your corporate data. When correctly implemented the meta model provides users with the information they need to make the best use of the data they have access to.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific The Meta Model

SqlAlchemy Zen dialect for Python

The latest version of Zen introduces SQLAlchemy Zen Dialect, a Python library that provides SQL and object relational mapping features for Zen database access. This library is not installed with Zen v16 SP1 but is a separate download.

Zen Developer Self-Learning Product Zen 16.1

Data Integration: Scheduling Configuration Execution using a CRON Expression

You can schedule Data Integration Configurations using a CRON Expression. Follow this guide to understand how to utilize CRON expressions for scheduling the execution of Configurations.

Beginner Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

How to Use SQL Query Logging and Query Plan to Troubleshoot Query Performance

Learn how to use Actian Zen Query Logging and Query Plan to troubleshoot and enhance the performance of SQL queries in your corporate database.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Advanced Product Zen Control Center Zen 16.0 brand_zen

Actian Ideas Portal - Training

Actian Communities Community

Ideas - Product Feature Requests

Submit your feedback and request features that you would want to see in Actian Products

Chat with Actian Support

This course teaches you how to interact with Actian Support through chat, offering an alternative to manually creating a case.

Actian Ingres & OpenROAD

Data Explorer Training and Certification Learning Path

This learning path has been curated to provide Data Explorers an opportunity to be formally recognised as subject matter experts for the Actian Data Intelligence Platform. Specific training material has been curated with a certification exam based on that material.

Self-Learning Certification brand_zeenea Data Intelligence Data Explorer

Customer Use Cases

Edge Data, Actian Zen

Data Integration, Actian DataConnect

Data Analytics & Avalanche

HCL Informix - Moving Your Migrated Version 15.0 Instance from Compatibility Mode to Native Mode

Migrate your Version 15.0 instance from compatibility mode to native mode to unlock full features like larger tables, chunks, and page sizes. Learn the two-step in-place process, testing considerations, and why this move is irreversible without an archive restore.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0

The ROWID format has been enhanced to support larger tables and increased storage capacity.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0

Actian Data Platform Warehouse Administrator Associate Certification

Take this exam to achieve the Associate level of certification for managing Actian Data Platform Warehouse(s)

HCL Informix - Key scalability limits improvements between version 15 and version 14

In this lesson, you learn how HCL Informix 15 removes key scalability limits from version 14 through major infrastructure changes. You explore larger row IDs, pages, and chunks, and see how these affect table growth, indexing, and upgrades while maintaining backward compatibility.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix onstat brand_informix HCL Informix 15.0

HCL Analytics Solutions

Fritz and Friends Podcast

Fritz and Friends Podcast: What's Zen Edge Data Management and What's it Used For? Extracted from a 90-minute deep dive discussion between Jeff Fritz and Tom Bates from Actian.

Zen Intermediate Beginner Developer Administrator Business User Self-Learning Edge Data Management Advanced Product Zen Podcast

How to: Install Zen Edge on to a Raspberry Pi Windows IoT Core device

In this course you will learn how to install Zen Edge on to a Raspberry Pi which has the Windows IoT core OS already installed.

Zen Intermediate Developer Administrator Self-Learning Edge Data Management Advanced Product Zen Edge

Actian DataConnect v12: Major Updates and Changes

Actian DataConnect v12 is now generally available and during this course we aim to provide you with a brief summary of the changes implemented in Actian DataConnect v12.

Intermediate Beginner Developer Administrator Business User Self-Learning DataConnect Enterprise Data Integration Advanced Product

How to: Install Zen Edge Server on the Raspberry Pi OS

In this course we provide you with a step by step guide for installing Zen Edge Server on to the Raspberry Pi OS

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product Zen Edge

Using the 'oncheck' utility to check the consistency of data and index pages for a table.

During this training we demonstrate how to use the 'oncheck' command line utility to to ensure that the data and index pages for a table are consistent. Any inconsistencies found must be repaired either via the mechanisms offered by the oncheck utility or via a manual process.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

HCL Informix v15 - Enhancements to HQ

HCL InformixHQ adds role management, H2DB backups, DB utilities UI, PWA support, dbspace/report enhancements, better logging, plus prior fixes: privilege handling, task cleanup, SSL fixes, Java 11 requirement, account lockout, large table support, and constraint dropping.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0

Actian Zen: How to restore a database in Actian Zen

Actian Zen restore depends on your backup method. For plain file backups, stop the engine, replace the data files from backup, then restart. For Continuous Operations backups, restore the files or drive image — changes since the last backup are lost, aside from transactions the engine auto-rolls-forward on startup. With Archival Logging, restore the backup files, then run butil rollfwd to replay logged changes for point-in-time recovery. Use butil or Zen Control Center's Maintenance tool.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Advanced Product Zen Control Center brand_zen

Microsoft Azure Connector

The Microsoft Azure Connector connects your specified Azure resources to your Actian Data Intelligence Platform Data Catalog.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Actian Data Intelligence Platform: Data Products and Data Contracts

With the Actian Data Intelligence Platforms Data Product functionality, you organize, govern, and share trusted, business-ready datasets as reusable assets, making them easy to discover and consume. Through Data Contracts, you establish clear rules, ownership, and expectations for data quality and usage, ensuring reliable collaboration between producers and consumers.

Beginner Self-Learning brand_zeenea Data Intelligence Product Specific Data Contract Data Product

Looker Connector

The Looker Connector connects to your Actian Data Intelligence Platform Data Catalog.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Data Steward Training and Certification Learning Path

This learning path has been curated to provide Data Stewards an opportunity to be formally recognised as subject matter experts for the Actian Data Intelligence Platform. Specific training material has been curated with a certification exam based on that material.

Self-Learning Certification brand_zeenea Data Intelligence Data Steward

Using the 'pvddl' command line utility

There are always times when a database administrator or systems developer needs a utility which is able to work through a file of SQL commands one after the other without the need for human intervention. 'pvddl' is one such utility for the Zen database. Within this course we describe how to use the 'pvddl' utility.

Zen Intermediate Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center brand_zen

Actian MCP Server: Configuring Authentication Methods

The Actian MCP Server supports OAuth 2.0 and OpenID Connect (OIDC) authentication. When you enable this feature, every client request must include a valid JSON Web Token (JWT) issued by a trusted identity provider (IdP).

Self-Learning Product MCP Server Authentication

Actian DataConnect 12.4: Data Profiler: Inspect and Recommend

You can use the Inspect Data and Recommend Rules wizard to run internal algorithms that analyze the source data and suggest rules based on the source schema and various data pattern matching tests. This method is recommended if you're unsure about potential issues in your source data.

Self-Learning DataConnect brand_dataconnect DataConnect 12.4

Actian DataConnect 12.4: Data Profiler: DeIdentify

This function rule changes data via masking or encryption so that it cannot be linked to an individual. The masked or encrypted data can then be shared without risk of exposing sensitive personal information.

Self-Learning DataConnect brand_dataconnect DataConnect 12.4

Actian Integration Manager Fundamentals.

Integration Manager brings together the flexible APIs and scalable workloads from Actian DataCloud, the rapid integration capabilities of Actian DataConnect, and the raw power of Actian DataFlow into a single platform. During this course we will provide you with the fundamental information you require to get the most from Integration Manager using best practice advice and guidance.

Intermediate Beginner Developer Administrator Business User Self-Learning DataConnect Enterprise Data Integration Advanced Product

Introduction to the Actian DataConnect Studio

Actian DataConnect is the digital business platform for hybrid data integration, transformation, and management. In this course we provide you with an introduction to the key functionality found within Actian DataConnect Studio IDE.

Intermediate Beginner Developer Administrator Self-Learning DataConnect Enterprise Data Integration Advanced Product

Actian - Get Registered (NE)

Case Management - Create Cases (NE)

Problem solving process to help customers achieve desired/ expected results.

How to Interact in the Communities (NE)

Connect with Actian Developers/ Support & Community Users Via Forum Questions/ Discussions

Actian Zen: How to implement the Data Export Utility (DEU)

The DEU data export utility exports the results of a SQL SELECT statement to a delimited text file.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Advanced Product Zen Control Center brand_zen

Actian DataConnect 12.4: Data Profiler: Expression Builder

In this lesson, you’ll learn how to use the Actian DataConnect Expression Builder to create and validate the logic behind your data transformations. You’ll practice selecting fields, functions, and operators to build expressions for filtering, deriving fields, and improving data quality—giving you the skills to enhance and control your data flows without writing code.

Self-Learning DataConnect brand_dataconnect DataConnect 12.4

Actian DataConnect 12.4: Data Prep: Parse Extract

Parse Extract lets you break apart structured field values—such as email addresses, names, URLs, timestamps, or addresses—into their individual components using the appropriate parsing function. For example, applying the Parse Email function separates an email address into a username (before the @ symbol) and a domain (after the @ symbol), generating a derived field for each part. This helps you analyze and work with complex data more efficiently.

Self-Learning DataConnect brand_dataconnect DataConnect 12.4

Actian DataConnect 12.4: Data Profiler: Assert Profile Rule

The Assert Profile Rule provides users the ability to evaluate multiple fields and conditions within a single rule and it ensures that a specific relationship or calculation between fields is met.

Self-Learning DataConnect brand_dataconnect DataConnect 12.4

Actian DataConnect 12.4: Data Profile: LookUp Value

In this lesson, you learn how to use a lookup function to search another dataset and automatically retrieve matching values. You place these results into a new derived field, which you can then use in expressions, rules, or to write data to a target, helping you work more efficiently with related information across datasets.

Self-Learning DataConnect brand_dataconnect DataConnect 12.4

Actian DataConnect 12.4: Remediation Functionality

In this lesson, you learn how to use Remediation rules to clean and correct source data by addressing issues like duplicates, inconsistent formats, and missing values. You explore how these rules are applied before Profiling rules during execution and how you can reorder Remediation rules to control processing order, while Profiling rules remain fixed.

Self-Learning DataConnect brand_dataconnect DataConnect 12.4

Actian DataConnect 12.4: Data Prep: StringSplit

In this lesson, you will learn how to use the StringSplit rule to break a single string into multiple parts using a delimiter. You’ll create derived fields for each part, which can be used in further processing or output. For example, you’ll split full names into separate first and last name columns, making your data easier to work with and analyze.

Self-Learning DataConnect brand_dataconnect DataConnect 12.4

Groups - Product updates (NE)

Stay tuned and get notified about valuable product information via Groups.

Chat with Actian Support (NE)

This course teaches you how to interact with Actian Support through chat, offering an alternative to manually creating a case.

Actian Ideas Portal - Training (NE)

Actian Ideas Portal - Training

Using the BMON and BCFG Command Line Utilities

Zen is designed for ease of use and minimal administration. At times, however, you may want to monitor various conditions or resources in the Zen environment. For example, you may need to tune portions of your application and monitor various performance aspects pertaining to the database. The BMON and BCFG command line tools will assist you to setup monitoring for your Zen database.

Zen Intermediate Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center brand_zen

Ideas - Product Feature Requests (NE)

Submit your feedback and request features that you would want to see in Actian Products

Case Management - Create Cases

Problem solving process to help customers achieve desired/ expected results.

Introduction to Actian SQL (self-paced)

This course provides a tour of the principal Actian database features along with insight into best practice use of the Actian SQL language.

Vector Intermediate Beginner Developer Administrator Business User Self-Learning Actian Ingres Learning Path Actian Data Platform Getting Started

Actian Data Intelligence Platform Public RESTAPI - a comprehensive insight.

In this comprehensive course we provide you with a deep technical insight for how to make best use of the Actian Data Intelligence Platform public API.

Intermediate Developer Administrator Self-Learning Advanced Data Engineer brand_zeenea Data Intelligence Public API REST API

Using an Actian Data Intelligence Platform Custom Item

Custom Items allow you to represent any concept that is specific to your needs. They also help you give more information about your assets, in a more detailed way than simple properties. In this course we provide you with a description for a Custom Item and how to create and maintain a custom item.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation

Triggering Scans

Actian Data Observability is a data quality analysis and monitoring platform that helps data teams proactively understand, detect, and resolve data quality issues without writing code, SQL, or rules.

Intermediate Administrator Self-Learning Product Data Engineer Data Intelligence Data Steward brand_data_observability

How to implement the Actian JSON functionality

A brief overview of how to implement the Actian JSON functionality.

Vector Intermediate Beginner Developer Self-Learning Actian Ingres Actian Data Platform Product Vector 6.0

Introduction to the Actian Product and Actian SQL (self-paced)

This course provides a tour of the principal Actian database features along with insight into best practice use of the Actian SQL language.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Operational Database Product

Data Encryption and Data Masking

For the Actian Database products, Actian Ingres, Actian Vector and Actian Data Platform, data can be encrypted at the database level, column level and data can also be masked. In this video we introduce each method.

Vector Intermediate Developer Administrator Self-Learning Actian Ingres Advanced Operational Database Product Administration Vector 6.0

Actian OpenROAD Server Fundamentals Certification

This learning path has been curated to encourage OpenROAD professionals to solidify their existing knowledge and experience to obtain this OpenROAD Server Certification. The certification questions are derived from the training materials provided.

Self-Learning Learning Path OpenROAD Product Certification brand_openroad OpenROAD Server

Actian MCP Server: Connecting to Actian Ingres

The Actian MCP Server is distributed as Docker container images, with one dedicated image for each supported Actian database. In this video you will learn the steps required to easily connect and Actian Ingres Database to Actian MCP Server.

Self-Learning Product MCP Server

The Actian Data Intelligence Platform Public Catalog Design API

The Actian Data Intelligence Platform offers a set of public APIs that will allow you to manage your catalog and its contents. In this course we specifically describe the Catalog Design API.

Intermediate Developer Administrator Self-Learning Advanced Data Engineer brand_zeenea Data Intelligence Public API REST API

The Actian Data Intelligence Platform - Audit Trail API

The Audit Trail API allows you to list all added, updated, and deleted metadata in the catalog; this includes users, contacts, groups/permission sets, and data access requests.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Public API

Connector - Google Cloud Storage

The Google Cloud Storage Connector connects to your Actian Data Intelligence Platform Data Catalog.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Create, Edit and Delete a Data Process via Studio

A Data Process item represents a program or pipeline that takes data as input and produces output. It's a key component within Zeenea's data catalog, allowing you to understand how data is transformed and used. In this course we provide you with a demonstration for how to maintain Data Processes within the Actian Data Intelligence Platform.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation

Creating Items in bulk using the file import feature

The Actian Data Intelligence Platform File Import feature allows you to bulk-create and update items in the data catalog from instructions held within an Excel (.xlsx) file.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation

Actian Data Intelligence Platform: Data Access Requests

The Access Request feature in Actian Data Intelligence Platform is designed to simplify and streamline the process of requesting access to data assets and products within the organization. It allows users to request access to the data assets or data products they need directly through Zeenea Explorer. Data owners can review these requests in Zeenea Studio and trigger an external workflow to apply the appropriate permissions and grant access to the data.

Beginner Self-Learning brand_zeenea Data Intelligence Product Specific Data Access

Configuring a PostgreSQL Connector

To automate the ongoing collection of metadata from remote data sources use an Actian Data Intelligence Platform connector. The Actian Data Intelligence Platform connector is configured to ensure your data catalog always contains the most up to date information for your connected datasources. Use the information provided in this training to make the best use of the PostgreSQL Connector.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Actian Data Intelligence Platform | Getting Started

An introductory course to gain an understanding of the Actian Data Intelligence Platform, covering user interfaces, best practices, scanners, and APIs.

Beginner Administrator Self-Learning Product Getting Started Data Quality brand_zeenea Data Intelligence Data Steward Data Explorer

Connecting to a Local File System

To automate the ongoing collection of metadata from remote data sources use an Actian Data Intelligence Platform connector. The Actian Data Intelligence Platform connector is configured to ensure your data catalog always contains the most up to date information for your connected data sources. Use the information provided in this training to make the best use of the Actian Data Intelligence Platform Local File System connector.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Lineage view for Data Explorers

In this course, you’ll learn to trace and interpret data lineage to understand how datasets are created, transformed, and connected. You’ll explore how to retrieve or define lineage in Explorer and visualize it across Datasets, Visualizations, and Data Processes to gain deeper insight into your data’s journey.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Data Explorer Product Specific Lineage

Adding a Generic JDBC Connection

To automate the ongoing collection of metadata from remote data sources use an Actian Data Intelligence Platform connector. The Actian Data Intelligence Platform connector is configured to ensure your data catalog always contains the most up to date information for your connected datasources. Use the information provided in this training to make the best use of the JDBC connector.

Beginner Self-Learning brand_zeenea Data Intelligence Data Steward Data Explorer

Actian Data Intelligence Platform Customer Certification

This learning path has been curated to provide our customers with the opportunity to learn and understand the Actian Data Intelligence Platform. The self-paced course content provides you with all of the information required to successfully pass the certification exam.

Self-Learning Learning Path Certification brand_zeenea Data Intelligence

Using Identification Keys

In order to facilitate imports and exports of all objects in the Catalog, being able to uniquely identify them is necessary. Identification Keys are also useful when synchronizing the Catalog with an External System using the APIs.

Beginner Administrator Self-Learning Administration brand_zeenea Data Intelligence Product Specific Documentation

Create, Edit and Delete an Actian Data Intelligence Platform Responsibilities

A responsibility is the relationship between a contact (individual, team, or entity), whether internal or external to the company, and an item. In this course we provide you with a demonstration for how to maintain the your corporate list of responsibilities within the Actian Data Intelligence Platform.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation Responsibilities

Configuring a Scanner Hook

Hooks allow you to trigger processing at the end of import, update, or synchronization scanner jobs. This course will provide you with the steps to configure a hook to execute after a scanner job has completed.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Scanner Product Specific

Data Intelligence Platform Studio: Search and Filter Options

The Actian Data Intelligence Platform Studio feature provides powerful and convenient search and filter options to help you locate the data or information you are seeking from your corporate data catalog. In this lesson we provide you with a demonstration of how to best use the Search and Filter options.

Beginner Self-Learning brand_zeenea Data Intelligence Product Specific Search

Data Intelligence Platform: Scanner Installation and Configuration for Linux

In this lesson, you learn how to download the Zeenea Scanner software, install the software, configure the scanner, start the scanner and how to ensure the scanner is up and running via the Data Intelligence Platform user interface.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Scanner Product Specific

Bulk Editing Catalog Items

As your data catalog scales you will need features which turn mundane into trivia. The 'Bulk Editing' feature is one such feature. Select the items to work with, decide the action to apply and all selected items have the same action applied to them, reliably and in no time at all.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation

Create, Edit and Delete an Actian Data Intelligence Platform Custom Item

Custom Items allow you to represent any concept that is specific to your needs. They also help you give more information about your assets, in a more detailed way than simple properties. In this course we provide you with a demonstration for how to Create, Edit and Delete a Custom Item.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation

Actian Zen Connector

The Actian Zen Connector connects your specified database to your Actian Data Intelligence Platform Data Catalog.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Using REST API to generate Data Products and Data Contracts

With the Actian Data Intelligence Platforms Data Product functionality, you organize, govern, and share trusted, business-ready datasets as reusable assets, making them easy to discover and consume. Through Data Contracts, you establish clear rules, ownership, and expectations for data quality and usage, ensuring reliable collaboration between producers and consumers.

Beginner Self-Learning brand_zeenea Data Intelligence Product Specific REST API Data Contract Data Product

Actian Data Intelligence Platform : Managing User Groups

The Actian Data Intelligence Platform convenient provides the 'group' concept for managing permissions for a defined 'group' or set of users. Numerous permissions can be configured and amended for a group which are inherited by the user records aligned to the group. In this video we demonstrate how you use the group feature.

Beginner Administrator Self-Learning Administration brand_zeenea Data Intelligence Product Specific

The Actian Data Intelligence Platform Public API

The Actian Data Intelligence Platform offers a set of public APIs that will allow you to manage your catalog and its contents.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Public API

Collaboration and Comments for Data Explorers

Learn how to explore, understand, and collaborate around data using the Actian Data Intelligence Platform. This course covers finding trusted datasets, interpreting documentation, connecting with data stewards, and submitting feedback through the Suggestions feature. Discover how Actian turns data discovery into a continuous cycle of collaboration and improvement.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Data Explorer Product Specific Collaboration

Configuring an Actian Ingres Connection

To automate the ongoing collection of metadata from remote data sources use an Actian Data Intelligence Platform connector. The Actian Data Intelligence Platform connector is configured to ensure your data catalog always contains the most up to date information for your connected datasources. Use the information provided in this training to make the best use of the Actian Ingres Connector.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Documenting Catalog Items using the default attributes.

In this course we provide you with information in relation to the default and specific attributes available in Actian Data Intelligence Platform to assist with documenting your Actian Data Intelligence Platform catalog items. Our recommended best practice advice is that you aim to provide values into these default attributes to provide the base documentation per item.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation

Oracle Connector

The Oracle Connector connects your specified database to your Actian Data Intelligence Platform Data Catalog.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Amazon S3 Connector

The Amazon S3 Connector connects your specified S3 buckets to your Actian Data Intelligence Platform Data Catalog.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Actian AI Analyst Datasheet

Actian AI Analyst lets your team ask questions about your data in plain language and get instant, accurate answers — without writing SQL or knowing your database structure.

Developer Business User Data Scientist Data Steward Actian AI Analyst

Actian MCP Server: Getting Started

The Actian MCP Server is distributed as Docker container images, with one dedicated image for each supported Actian database. This 'Getting Started' guide explains the process of starting the server instance and connecting it to an MCP-compatible artificial intelligence (AI) client.

Getting Started MCP Server Actian MCP Server

The Actian Data Intelligence Platform Scanner and Connector Introduction

A critical aspect for the Actian Data Intelligence Platform is the quality of the metadata sourced from the corporate data sources such as databases or file systems. The Actian Data Intelligence Platform provides a wide range of scanners and connectors which are deployed to initially gather and then maintain the data catalog metadata.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Scanners and Connectors

Maintain your Actian Data Intelligence Platform Glossary

This course provides you with insight for how to maintain the Data Intelligence Platform Glossary.

Beginner Administrator Self-Learning Administration brand_zeenea Data Intelligence Product Specific

Data Intelligence Platform Explorer: Search and Filter Options

The Actian Data Intelligence Platform Explorer feature provides powerful and convenient search and filter options to help you locate the data or information you are seeking from your corporate data catalog. In this lesson we provide you with a demonstration of how to best use the Search and Filter options.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Search

Introduction to Actian Data Intelligence Platform

An introductory course to gain an understanding of the Actian Data Intelligence Platform, covering user interfaces, best practices, scanners, and APIs.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Introducing Actian Data Intelligence Platform

Actian Data Intelligence Platform, User Personas

The Actian Data Intelligence Platform targets three key personas: Data Steward, Data Explorer and the Administrator. These three key personas are described within this course.

Beginner Administrator Self-Learning Administration brand_zeenea Data Intelligence Product Specific Personas

Administration of Data Catalog Records

In this video we provide you with guidance for creating, amending or removing a Data Catalog record defined within your Actian Data Intelligence Platform instance.

Beginner Administrator Self-Learning Administration brand_zeenea Data Intelligence Connector Product Specific

Actian Data Intelligence Platform, User Interfaces

The Actian Data Intelligence Platform has two distinctive user interfaces which you should familiarise yourself with. The information provided in this course provides you with a guided tours for this important part of the Data Intelligence product.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific User Interfaces

Actian Analytics Engine v8.0 New and Updated Features

Actian Analytics Engine 8.0 unifies relational data, vector search, machine learning, and AI inference in a single platform. Discover how built-in RAG, native vector support, GenAI functions, and in-database ML eliminate the complexity and cost of disconnected tools. Whether you're new to Actian or upgrading from v7.0, learn what's new and what it means for your business.

Actian Analytics Engine

Actian AI Analyst: Introduction

Actian AI Analyst lets your team ask questions about your data in plain language and get instant, accurate answers — without writing SQL or knowing your database structure.

Self-Learning Product Actian AI Analyst

OpenROAD - URLConnection Class - connecting OpenROAD to the outside world!

This video provides you with an overview and examples for the functionality provided via the OpenROAD UrlConnection class.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product brand_openroad OpenROAD Server Application Modernization URLConnection Class

ABF2OR - Automated ABF Form to OpenROAD Frame migration

To assist with ABF to OpenROAD Application Modernization and migration projects the ABF2OR OpenROAD Frame Template simplifies and automates the migration of ABF Forms to OpenROAD Frames.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product ABF brand_openroad OpenROAD Server Application Modernization ABF2OR

OpenROAD - Application Development and Maintenance (self-paced)

OpenROAD is a high-productivity low-maintenance 4GL-based object-oriented application-development tool for creating business applications of any type and complexity. It is well-established, with thousands of deployments worldwide.

Beginner Developer Self-Learning OpenROAD Operational Database Product brand_openroad

Application Modernization - ABF to OpenROAD

Subscribe to the courses within this Learning Path to learn about our supported and best practice approach for migrating a complex ABF application into first a desktop OpenROAD application before lifting out the business logic into OpenROAD Server.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Learning Path Advanced OpenROAD Operational Database Product ABF brand_openroad OpenROAD Server Application Modernization ABFComp2OR ABF2OR

Actian Technical Update - OpenROAD

This Actian technical update was recorded 1st February 2021 and includes the product roadmap for Actian OpenROAD.

Intermediate Beginner Developer Administrator Business User Self-Learning Advanced OpenROAD Operational Database Product

Actian OpenROAD - JSON Generators

This course demonstrates how developers can create OpenROAD Server Procedures as Web Services using the JSON RPC 2.0 interface. Functionality available from OpenROAD version: OpenROAD 6.2 patch 15469

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product brand_openroad JSON OpenROAD Server Application Modernization

Actian OpenROAD Server - Getting Started

OpenROAD Server allows OpenROAD 4GL business logic to be accessed by various client environments and languages, including web server scripting languages, OpenROAD clients, and browser applications. Use this training to develop your understanding of OpenROAD Server.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Learning Path Advanced OpenROAD Operational Database Product Getting Started brand_openroad OpenROAD Server

Actian OpenROAD JSON, JSON-RPC and WebGen functionality.

This course provides three lessons to describe the functionality available within Actian OpenROAD to support the usage of JSON, JSON RPC and the WebGen functionality

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product brand_openroad JSON OpenROAD Server Application Modernization

Connecting your Alteryx software to your Platform Warehouse

Alteryx is a major player in the Data analytics world and that is not overlooked here. This training provides the steps required to connect your Platform Warehouse to your Alteryx software and demonstrate how to verify that the connection is good to go.

Developer Administrator Business User Self-Learning Actian Data Platform Product Third Party Tools Google Cloud Platform

Data Integration: Application Template - NetSuite to the Platform Warehouse on GCP

Explore the Data Integration Templates feature to efficiently transfer data from the NetSuite application to an Avalanche Data Warehouse hosted on the Google Cloud Platform.

Beginner Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Data Integration: Job Log Overview

Jobs are reports about the run results of the configurations you execute. Follow this guide to gain an understanding of how to access and navigate the log file output generated during the execution of a Data Integration Configuration against a Platform Warehouse on Google Cloud Platform.

Beginner Developer Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Data Integration: Configuration Creation

The task of integrating data into your Platform Warehouse must be efficient and convenient for it to be valuable to you. Actian Data Platform comes complete with 200+ data connectors right out of the box which provides you with a wide range of connectors to many data sources. Take this training to discover how to create a data integration configuration.

Intermediate Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product Google Cloud Platform Data Integration

Data Integration: Simple Mapper

Data integrations enable the transformation and migration of data by visually mapping fields between a defined data source and a target Platform warehouse. Follow this guide to gain an understanding of how to use the Data Integration Simple Mapper functionality.

Beginner Developer Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Data Integration: Jobs

Follow this guide to learn how to schedule, configure and review Data Integration Jobs

Developer Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform Data Integration

Load Local Files

Loading data into the Platform is a key requirement. Actian provides numerous high performing methods for loading data into the Platform. The training provided here focuses on the 'Load Local Files' feature and guides you through the process of loading the contents of locally source data files into a Platform Warehouse.

Beginner Developer Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Perform a table level restore using the HCL Informix Archecker utility.

During this video we demonstrate how to use the Archecker utility to perform a table level restore.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Actian X and Ingres on Docker, Containerization and Beyond

Ingres as an OLTP engine is tried and true. What’s changed over the years has been its continued ability to evolve and adopt the latest in underlying server architecture. The next wave of evolution is here. Join this session to hear how automated deployment of Actian X and Ingres in the Cloud or On-Premise using Docker, Kubernetes and Helm achieve consistent, isolated environments with cost effective, rapid and iterative deployments, thereby reducing operational overhead.

Actian - Get Registered

Actian Data Platform: Administrator Learning Path

A Platform as comprehensive as the Actian Data Platform will require an Administrator to manage your organisations Platform assets. The training provided during this Learning Path provides the Administrator with the knowledge required to manage the Platform with best practice.

Beginner Administrator Self-Learning Learning Path Actian Data Platform Administration Google Cloud Platform

How to create an encrypted dbspace for HCL Informix server.

During this video we demonstrate how to create an encrypted dbspace within an existing HCL Informix server.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

User Profiles and Permissions

In this course we provide a short summary of the different Actian Data Intelligence Platform User Profiles and the scope of their engagement within the Actian Data Intelligence Platform.

Beginner Administrator Self-Learning Administration brand_zeenea Data Intelligence Product Specific

Install Actian VectorAI DB

VectorAI DB stores and indexes high-dimensional vectors and supports nearest neighbour search with optional metadata filters. It runs locally via Docker and is accessible over gRPC or REST.

Beginner Self-Learning Product Actian VectorAI DB

Actian License Key Manager Training

Actian software will not work without a valid license in place. During this training we will provide you with a demonstration for using the Actian License Key Manager to obtain a valid software license key.

Community Licensing

Actian License Key Manager Training (NE)

Actian software will not function without a valid license in place. During this training we will provide you with a demonstration for using the Actian License Key Manager to obtain a valid software license key.

Actian Communities Community Licensing

Actian Technical Update - Actian Ingres product roadmap.

This Actian technical update was recorded 11th January 2021 and includes the product roadmap for Actian Ingres, a customer use case discussion with the Irish Revenue Commissioners and Q&A with our SVP of Engineering - Emma McGrattan.

Intermediate Beginner Developer Administrator Business User Self-Learning Actian Ingres Operational Database Product

Configure a DataSource

Actian Data Observability is a data quality analysis and monitoring platform that helps data teams proactively understand, detect, and resolve data quality issues without writing code, SQL, or rules.

Data Intelligence brand_data_observability

Bring Your Own Actian Licenses (BYOL) into a VM Instance with a single or multiple NICs deployed via AWS

Understand how Actian Licensing is implemented in the context of VM Instances deployed via AWS.

Intermediate Beginner Administrator Self-Learning Actian Ingres Advanced OpenROAD NoSQL Product brand_openroad Bring Your Own License

Bring Your Own Actian Licenses (BYOL) into a VM Instance with a single or multiple NICs deployed via Google Cloud Platform

Understand how Actian Licensing is implemented in the context of VM Instances deployed via Google Cloud Platform.

Intermediate Beginner Administrator Self-Learning Actian Ingres Advanced OpenROAD NoSQL Product brand_openroad Bring Your Own License

Deploying Actian Ingres into Docker

The latest version of the Actian Ingres Database software can be installed, licensed and run within a Docker Container. In this course we provide the steps required to achieve this.

Administrator Self-Learning Actian Ingres Advanced Product Actian Ingres 11.2 Docker

Connect your DbVisualizer software to your Platform Warehouse

DbVisualizer is a major player in the DB Visualisation and SQL utility space and that is not overlooked here. This training provides the steps required to connect your Platform Warehouse to your DbVisualizer software and demonstrate how to verify that the connection is good to go.

Beginner Developer Administrator Business User Self-Learning Actian Data Platform Product Third Party Tools Google Cloud Platform

Actian Data Platform: Native Data Ingestion v2.0 (self-paced)

Actian Data Platform provides - out of the box - native data ingestion functionality to facilitate the ease of loading data into an Actian Data Platform Warehouse(s). Features include the desktop data loader for ad hoc data loading from a local computer and Actian Data Platform Connect for continuous data integration from disparate sources. All functionality is accessible via the Actian Data Platform Console.

Intermediate Beginner Administrator Self-Learning Actian Data Platform Product Data Ingestion Google Cloud Platform

Data Integration: Files

Refer to this guide for a step-by-step tutorial on uploading files into Actian Data Platform to the Files page and linking these files with a Data Integration Configuration or Template.

Developer Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform Data Integration

Actian Data Platform: CLI Data Ingestion v2.0 (self-paced)

In addition to offering rich browser-based native data ingestion capabilities, Actian Data Platform includes functionality executed through the command line to facilitate batch data loading. This course comprehensively explores the various functionalities at your disposal for loading data into a Platform Warehouse using command line operations.

Intermediate Beginner Developer Administrator Self-Learning Actian Data Platform Product Data Ingestion Google Cloud Platform

Data Integration: Connect Actian DataConnect to a Platform Warehouse using the Actian JDBC Data Driver.

Being able to hook up Actian DataConnect to a Platform Warehouse is an obvious and necessary connection to be made. Take this training to learn how to connect these two best in class products together using the Actian JDBC Data Driver.

Intermediate Beginner Developer Administrator Self-Learning DataConnect Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Data Integration: Install Actian DataConnect Studio for Windows

Follow this guide to understand how to install the Actian DataConnect Studio IDE on your desktop. This IDE is designed for developing integration packages, which can be deployed into Actian Data Platform to populate selected Platform warehouses according to your needs.

Developer Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform Data Integration

Data Integration: Macros

Macros are placeholders you create for values that are typically used during design and runtime, such as target paths, and credentials to access databases. This training provides you with the information required to create, populate and amend Macros for use within integration configurations.

Beginner Developer Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Actian Data Platform: Schema Design v2.0 (self-paced)

Explore Data Organization. Learn how data is stored in tables and how to create, partition, define column data types, and implement constraints within a user's schema.

Beginner Self-Learning Actian Data Platform Product Administration Google Cloud Platform brand_adp

How To: Load Data from Cloud Storage into an Actian Data Platform Warehouse using the COPY VWLOAD Command

This course provides you with the steps required to load delimited data files from your cloud storage into an Actian Data Platform warehouse using the COPY VWLOAD command.

Intermediate Beginner Developer Administrator Self-Learning Actian Data Platform Advanced Product Data Ingestion

Actian Data Platform: Getting Started (self-paced)

Actian Data Platform is a Cloud Based Data Platform which is administered from the native web browser based user interface. In this course a guided tour of the user interface is provided highlighting the native functionality available. Create a Warehouse, add IP to the allow list of IP and use the native Query Editor tool to access your data.

Self-Learning Actian Data Platform Getting Started Google Cloud Platform

Actian NoSQL v11.0: Database Encryption

The NSQL-11.0.0.2 release introduces robust encryption capabilities for NSQL databases, enhancing data security and compliance. This module provides a comprehensive understanding of the encryption features available in NSQL-11, including technical requirements, implementation steps, and client-side considerations.

Intermediate Administrator Self-Learning NoSQL Product

Actian Data Platform: Data Scientist Learning Path

The Data Scientist Learning Path has been provided to guide you through the functionality which is provided within the Actian Data Platform to assist a new or seasoned Data Scientist to accomplish the data processing aspects of their role as efficiently as possible.

Intermediate Self-Learning Learning Path Actian Data Platform Analytics Google Cloud Platform Data Science Data Scientist

Connecting Looker to your Platform Warehouse

Looker is a major player in the Data analytics world and that is not overlooked here. This training provides the steps required to connect your Platform Warehouse to your Looker software and demonstrate how to verify that the connection is utilised within Looker to build out Looker dashboards.

Developer Administrator Business User Self-Learning Actian Data Platform Product Third Party Tools Getting Started Google Cloud Platform

Actian Data Platform - Getting Started

Get to know the Actian Data Platform and the features it provides to our customers in this short training video.

Beginner Developer Administrator Business User Self-Learning Actian Data Platform Getting Started Google Cloud Platform

Actian Data Platform: Data Quality

During this course we provide all that you need to know for getting started with the Actian Data Platform Data Quality functionality. Data Quality ensures the data going into your production system data stores is accurate, complete and able to support the decisions and actions you need to take. At Actian we know and understand this and bring to you best in class Data Quality functionality which when implemented ensures that you are always basing decisions on the best quality of data.

Beginner Developer Enterprise Data Integration Product Data Ingestion Data Engineer Data Profile Data Quality brand_adp_dq

Actian Data Platform: Security v2.0 (self-paced)

Explore the robust native data security solutions offered by the Platform Warehouse, customized to meet your organization's needs. This course covers user management, table data access control, data masking, and data-at-rest encryption.

Beginner Self-Learning Actian Data Platform Product Administration Google Cloud Platform brand_adp

Loading data from a Cloud Data Store into an Actian Data Platform Warehouse using an External Table

This series of short how to training videos provide step by step instructions for loading data from an Amazon S3 bucket, Microsoft Azure Blob Storage and Google Cloud Store into an Actian Data Platform Warehouse using an the 'External Table' feature.

Intermediate Beginner Developer Administrator Self-Learning Actian Data Platform Advanced Product Data Ingestion Google Cloud Platform

Manually creating a HCL Informix Instance with minimum configuration parameters

During this video we demonstrate how to create a HCL Informix Instance with minimum configuration after the HCL Informix binaries have been installed.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Confirming Client Connectivity to a HCL Informix Database Instance

During this video we demonstrate how to confirm that your client side computer is able to connect to a HCL Informix Database Instance.

Intermediate Beginner Developer Administrator Business User Self-Learning Operational Database Product Data Scientist Data Engineer HCL Informix

Using the 'cdr' list' command to Manage and Monitor Replication Settings.

During this video we provide a demonstration of how to use a number of different variants of the 'cdr list' command to help to keep track of any replications progress or configuration.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix explore brand_informix cdr

High Availability Data Replication Cluster monitoring using the 'onstat' utility.

In this video we demonstrate the set of parameters which can be supplied into the 'onstat' utility in order to monitor the whole cluster, the individual primary server node and any of the individual secondary servers which are included in the cluster.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Techniques for migrating from a small to large table

This course provides detailed guidance on migrating data from small tables to large tables using the latest version of HCL Informix. It covers multiple supported methods for transitioning data from small table formats to large table formats, particularly after upgrading from earlier versions of HCL Informix.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0

How to implement the HCL Informix External Table feature for migrating data

During this training we demonstrate how to use the External Table feature. You can use the External Table to load and unload data to or from your database. You can also use external tables to query data in text files which are not in the HCL Informix databases.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Migrating your existing HCL Informix installation to the latest version of software

During this video we provide a demonstration of how to migrate your existing installation of HCL Informix to the latest version. A migration of this type must never be underestimated as databases are typically mission critical. This video provides technical insight into the migration itself but beyond this there must be a project plan to ensure all dependencies are tested and all stakeholders informed of the migration effort.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix explore brand_informix cdr Migration

Migrating HCL Informix from On-Prem to an AWS Cloud Environment.

The trend to migrate mission critical database environments to a cloud environment shows no signs of abating. Here at Actian we facilitate such a migration with our key database offerings including the latest version of HCL Informix. The content provided in this video is best practice advice and guidance for migrating your on-prem environment to the AWS cloud environment.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 14.1 AWS Cloud

Using onbar or the archecker utility to validate backup files.

During this video the 'onbar' and 'archecker' commands are demonstrated to verify that backup files are valid and, if needed, available for a restore task.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

High Availability Data Replication (HADR): Managing Failover Scenarios

Managing failover scenarios involves ensuring continuous system availability by automatically switching to a backup system or component when the primary system fails. Effective failover management minimizes downtime and maintains service continuity, ensuring business operations remain unaffected by unexpected system failures. HCL Informix provides robust and comprehensive functionality to manage failover scenarios. In this video we consider a sample of the most common failover scenarios.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix explore brand_informix HADR

High Availability Data Replication (HADR): Server Role Management within a Cluster.

For numerous operational or perhaps maintenance reasons the roles of the servers within a cluster environment might need to be altered within a HCL Informix cluster. During this video we provide you with the best practice advice and guidance you need to switch a node(s) in a cluster from one role to another.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HADR HCL Informix 14.1

HCL Informix: Increase in Limits means increase in scalability.

HCL Informix 15.0 significantly expands scalability across the system. From larger page sizes to massive increases in storage limits, these changes allow HCL Informix to handle far bigger workloads than before.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0

HCL Informix: Timstamp and Incremental Archiving.

HCL Informix 15 introduces a new 8-byte page timestamp. This greatly expands the range of possible timestamp values and effectively prevents timestamp wraparound.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0

HCL Informix: Page Size

In this course, we’ll explore the larger page size options introduced in HCL Informix v15 and understand how they help improve performance and scalability.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0

Taking a HCL Informix Database backup using the OnTape utility.

During this video we demonstrate how to use the OnTape utility to perform full and incremental server backups and Manual and Continuous Logical Log Backups.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Types of Backup & Restore available for HCL Informix

During this video we provide operational information for the different backup and restore mechanisms available for HCL Informix.

Intermediate Beginner Administrator Self-Learning Product HCL Informix

Setting up a dashboard in HCL Informix Explore to monitor the health of the connected HCL Informix Servers.

During this training we demonstrate how to setup up a monitoring dashboard in HCL Informix Explore in order to monitor the health of the connected HCL Informix Servers. A comprehensive list of sensors can be selected from and added to the dashboard as your use case requires. Add multiple panels to monitor numerous sensors for the connected HCL Informix Servers.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix explore

Actian Vector Views

This course provides an overview of the Actian Vector View functionality

Vector Intermediate Beginner Developer Administrator Self-Learning Actian Data Platform Product Vector 6.0

This video guides provides you with guidance for implementing the Pivot Table functionality now available within the Actian database products mentioned below.

Vector Beginner Developer Administrator Self-Learning Actian Ingres Product Analytics Vector 6.0

Vector 6.2 and Vector 6.3 Delta/New Features

Many new features and functionality upgrades have been provided with the releases of Vector 6.2 and 6.3. In this course we bring together the learning content for each new or upgraded piece of functionality together with a short quiz to help reinforce the information provided.

Intermediate Developer Administrator Business User Self-Learning Learning Path Product Data Scientist Data Engineer Architect Vector 6.3 Vector 6.2

Database Encryption Key Management via SQL Commands

During this course we provide guidance for how to use the newly added SQL functionality for maintaining encryption key settings at either the table or database level via newly added SQL command functionality.

Vector Intermediate Administrator Self-Learning Actian Ingres Actian Data Platform Advanced Product Administration Vector 6.0

Actian Client Runtime - Download, Install and create ODBC DSN for Windows

This short video will demonstrate how to Download, install and configure Actian client runtime setup on Windows platform. Additionally the video demonstrates how to create an ODBC DSN for use with third party applications.

Vector Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced Operational Database Product Vector 6.0

User Defined Functions

This video guides you through the UDF functionality which has been provided in the versions of Actian database software listed in the video.

Vector Beginner Developer Administrator Self-Learning Actian Ingres Actian Data Platform Product Administration Google Cloud Platform Vector 6.0

What is new in Actian Ingres 11.2

In this course we spotlight the new functionality which has been added into Actian Ingres 11.2

Intermediate Beginner Developer Administrator Business User Self-Learning Actian Ingres Advanced Operational Database Product

Bring Your Own Actian Licenses (BYOL) into a VM Instance with a single or multiple NICs deployed via Microsoft Azure

Understand how Actian Licensing is implemented in the context of VM Instances deployed via Microsoft Azure.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD NoSQL Product brand_openroad Bring Your Own License

Actian Zen 16.1 New Features Summary

A number of new features have been added to Actian Zen v16.1. During this course you will learn about these new features to ensure that you continue to extract the very best from this flagship database product.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Advanced Product Zen Control Center brand_zen Zen 16.1

Actian VectorAI DB: What is a Vector Database?

VectorAI DB stores and indexes high-dimensional vectors and supports nearest neighbour search with optional metadata filters. It runs locally via Docker and is accessible over gRPC or REST.

Self-Learning Actian VectorAI DB

Actian MCP Server: Connecting to Actian Zen

The Actian MCP Server is distributed as Docker container images, with one dedicated image for each supported Actian database. In this video you will learn the steps required to easily connect Actian Zen to Actian MCP Server.

Zen Self-Learning Product MCP Server

Actian VectorAI DB: Embedding Models

VectorAI DB stores and indexes high-dimensional vectors and supports nearest neighbour search with optional metadata filters. It runs locally via Docker and is accessible over gRPC or REST.

Self-Learning Actian VectorAI DB

Actian VectorAI DB: Traditional Search vs Vector Search

VectorAI DB stores and indexes high-dimensional vectors and supports nearest neighbour search with optional metadata filters. It runs locally via Docker and is accessible over gRPC or REST.

Self-Learning Actian VectorAI DB

Actian VectorAI DB: Vector Search Similarity vs Retrieval Quality

VectorAI DB stores and indexes high-dimensional vectors and supports nearest neighbour search with optional metadata filters. It runs locally via Docker and is accessible over gRPC or REST.

Self-Learning Actian VectorAI DB

Actian VectorAI DB: Approximate Nearest Neighbour (ANN) Indexes

VectorAI DB stores and indexes high-dimensional vectors and supports nearest neighbour search with optional metadata filters. It runs locally via Docker and is accessible over gRPC or REST.

Self-Learning Actian VectorAI DB

Vector Administrator Associate Certification

Take this exam to achieve the Associate level of certification for the latest version of the Actian Vector Database

Actian Data Platform: Data Manipulation v2.0 (self-paced)

Explore best practices for updating data within Platform Warehouse tables, optimizing query performance with statistics, and leveraging inbuilt query execution plans to ensure efficient queries.

Beginner Self-Learning Actian Data Platform Product Administration Google Cloud Platform brand_adp

Administrator Training and Certification Learning Path

This learning path has been curated to provide Actian Data Intelligence Platform Administrators an opportunity to be formally recognised as subject matter experts. Specific training material has been curated with a certification exam based on that material.

Administrator Self-Learning Certification brand_zeenea Data Intelligence

Transaction Isolation Model

In this course we provide insight into the Transaction Isolation model provided within the Actian Vector based products including Vector and an Actian Data Platform Warehouse.

Vector Intermediate Beginner Administrator Self-Learning Actian Data Platform Product Administration Google Cloud Platform Vector 6.0

Configuring AES Encryption Networking

This course provides an overview of Secure Communication Encryption with AES. It also shows how to configure AES Encryption Networking.

Vector Administrator Self-Learning Actian Ingres Actian Data Platform Advanced Operational Database Product Connectivity Vector 6.0

Analytical Functions for Standard Deviation and Variance

In this short how-to video we provide you with guidance for using our inbuilt Standard Deviation and Variance database functions.

Vector Intermediate Developer Administrator Business User Self-Learning Actian Ingres Actian Data Platform Product Analytics Google Cloud Platform Vector 6.0

Command Line SQL/iSQL tools (Windows)

Take this course to understand how the command line tools SQL and iSQL operate within a Windows environment.

Vector Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Actian Data Platform Operational Database Product Vector 6.0

Actian MCP Server: Connecting to Actian Analytics Engine

The Actian MCP Server is distributed as Docker container images, with one dedicated image for each supported Actian database. In this video you will learn the steps required to easily connect and Actian Analytics Engine to Actian MCP Server.

Self-Learning Product MCP Server Actian Analytics Engine

Actian Jaspersoft: JasperReports Server for End-Users

This course provides a comprehensive guide for end-users on how to effectively utilize JasperReports Server, focusing on viewing, manipulating, and automating reports and dashboards. Learn to apply dynamic filters, customize data displays, and set up automated scheduled jobs for seamless data delivery.

Self-Learning Jaspersoft

Actian Jaspersoft: Analyst Connect and Build

This course guides you through data visualization in JasperReports Server, from Domain modeling to Ad Hoc report creation. You will build interactive, data-rich dashboards that combine multiple report elements into a single, cohesive view — transforming raw data into actionable insights using professional best practices for performance and usability.

Self-Learning Jaspersoft

Actian Jaspersoft: Product Overview

This course is designed for anyone who wants a holistic understanding of the Jaspersoft product suite. You will learn about the architecture and the key components of Jaspersoft. Even more importantly, you'll understand the types of business challenges that our platform is uniquely suited to solve. By the end of this session, you'll have a clear picture of how Jaspersoft can help your organization.

Self-Learning Jaspersoft

Actian Jaspersoft: Administrator Optimize and Control

Ready to take full control of your JasperReports Server environment? You'll structure multi-tenant organizations, secure content with roles and attributes, and manage repositories and data sources with confidence. Build your skills with the Admin Console, import-export workflows, report scheduling, and mail server integration—so you can keep your BI platform secure, efficient, and running at its best.

Self-Learning Jaspersoft

Actian Jaspersoft: Design Pixel Perfect Reports

Master Jaspersoft Studio to design pixel-perfect reports from concept to publication. Learn the Designer Palette, Fields, Parameters, and Variables, then advance to Data Adapters, Datasets, and Pro components like HTML5 Charts and Maps. Explore Subreports and Report Books for complex, multi-chapter documents, and finish by publishing polished reports to JasperReports Server for organization-wide delivery.

Self-Learning Jaspersoft

Actian Data Observability

Actian Data Observability is an AI-powered enterprise data observability solution that provides complete visibility across your modern data stack. It proactively ensures data quality without sampling or cost surprises so you can confidently build reliable, AI-ready data products.

Intermediate Beginner Self-Learning Level 200 Data Observability

ER configuration: cdr utility options

Learn how to use the cdr utility to configure and manage Enterprise Replication from the command line on UNIX™ and Windows™ systems. This course is designed for Enterprise Replication server administrators responsible for running and controlling cdr commands.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0 cdr

Remote File System Support for Vector (SMP)

During this video we explain the configuration steps required and usage for remote file support for Vector (SMP) which has been introduced with the release of Vector 6.3.

Vector Intermediate Beginner Administrator Self-Learning Product Administration Vector 6.3

Actian Vector Developer - .NET Connectivity (self-paced)

During this course we will provide developer guidance for using Microsoft .NET technology with an Actian Vector database

Vector Intermediate Beginner Developer Self-Learning Actian Data Platform Operational Database Product Vector 6.0

Extending UDF Accessibility

During this video we provide a demonstration of how to make use of the new feature for extending the accessibility to UDFs, created by the DBA, introduced with the release of Vector 6.3

Vector Intermediate Developer Administrator Self-Learning Product Data Scientist Vector 6.3

User Defined Functions: Containerized and non-containerized deployment, process control/cancellation, log message output and importing libraries/modules

During this video we provide guidance and a demonstration of how to make use of new UDF functionality introduced with the release of Vector 6.2.

Vector Intermediate Developer Administrator Self-Learning Actian Ingres Advanced Product Data Scientist Vector 6.2

LISTAGG Aggregation Functionality

During this video we provide guidance and a demonstration of how to make use of the LISTAGG aggregation function introduced with the release of Vector 6.2

Vector Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Product Data Scientist Vector 6.2

Actian Vector 7.0 New and Updated Features

Many new features and functionality upgrades have been provided with the release of Actian Vector 7.0. During this course you will learn about each of the new or updated features to ensure that you continue to extract the very best from these flagship database products.

Vector Beginner Developer Business User Product Data Scientist Data Engineer Expert Vector 7.0 vector-branding brand_vector

SQL Conversion Functions

This video provides you with insight into the SQL Conversion functions available for Actian Databases.

Vector Beginner Developer Administrator Business User Self-Learning Actian Ingres Product Analytics Vector 6.0

Actian Zen: Creating a Table from a Btrieve File using DDFBuilder

This video will demonstrate how to build a single table from a Btrieve file using DDFBuilder. Some metadata information is available in the data file itself, but much of the column layout information is not. DDFBuilder will use this available information and allow you to analyze the data to best determine the data structure within the file..

Zen Intermediate Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center

Actian DataConnect 12.4: Data Prep: String Join

In this lesson, you learn how to combine multiple fields into one value using a delimiter. You use the auto-generated derived field for further processing or additional rules, with all data types formatted to strings, including ISO 8601 for dates and times.

Self-Learning DataConnect brand_dataconnect DataConnect 12.4

Snowflake Connector

The Snowflake Connector connects your specified database to your Actian Data Intelligence Platform Data Catalog.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Publishing SQL Result Sets in XML

XML publishing provides a way to transform results of SQL queries into XML structures. During this training we provide guidance for how to publish your SQL result set in XML format.

Intermediate Beginner Developer Administrator Self-Learning Operational Database Product HCL Informix XML Functions

Components of a HCL Informix Database Server

During the lessons within this course we provide insight into the components which make up a HCL Informix Server. The focus is placed on the main components disk, memory and processes.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Using the 'oncheck' utility to Monitor Partition Usage/Allocation

During this training we demonstrate how to use the 'oncheck' command line utility in conjunction with the '-pt' parameter to monitor usage and allocation of partitions within the Informix installation.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix oncheck brand_informix HCL Informix 14.1

HCL Informix server operating modes and how to start HCL Informix Server in a particular operating mode

During this video will discuss the various operating modes available for HCL Informix server and how to start HCL Informix server in a particular mode using the OnInit utility

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Using the DbSchema, DbExport and DbImport database utilities.

During this video we demonstrate how to use these three HCL Informix database utilities. The command usage and resulting outputs are demonstrated for each command.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Plan of a Running Query & Invisible Indexes

When a SELECT statement or other DML operation is submitted to the database server, the query execution optimizer designs a query execution plan. You can now review these query execution plans. Additionally we provide information in relation to the use of Invisible Indexes and the impact they have on query execution.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix onstat brand_informix HCL Informix 15.0

Connector - Microsoft SQL Server

The Microsoft SQL Server Connector connects to your Actian Data Intelligence Platform Data Catalog.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Connector Product Specific

Chunk Size increase.

A chunk is the largest unit of physical disk dedicated to database server data storage. Chunks provide administrators with a significantly large unit for allocating disk space. In this video we provide guidance for the increase in Chunk Size which has been added to the product.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Using the 'oncheck' utility to verify the integrity of a table index.

In this training session, we illustrate the utilization of the 'oncheck' command line utility to verify the integrity of a table index, ensuring that no inconsistencies have occurred. If any irregularities are detected, they must be rectified using either the oncheck utility's provided mechanisms or through a manual process.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix oncheck

Monitoring HCL Informix Memory utilisation using the 'onstat' utility.

Understanding how your HCL Informix Installation utilises memory is critical knowledge that an experienced DBA will want to be aware of. The content within this video describes how to make use of the 'onstat' utility to monitor how memory is being utilised within a Installation. Use this insight to proactively avoid potential system outages or system performance degradation.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix onstat

The Actian Data Intelligence Platform Federated Catalog

The Actian Data Intelligence Platform Federated Catalog aligns with the core principles of Data Mesh. It supports these decentralized efforts by allowing each organizational domain to maintain its catalog with complete autonomy over its data assets.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Federated Catalog

Actian Ingres 12.0 New and Updated Features

Many new features and functionality upgrades have been provided with the release of Actian Ingres 12.0. During this course you will learn about each of the new or updated features to ensure that you continue to extract the very best from these flagship database products.

Intermediate Beginner Developer Administrator Business User Actian Ingres Advanced Data Engineer Vector 7.0 Actian Ingres 12.0 actianingres_branding

Actian DBA Tools

In this short how to video we demonstrate how to install the Actian DBA Toolset.

Vector Intermediate Developer Administrator Self-Learning Actian Ingres Operational Database Product Vector 6.0

User Management

Actian Data Observability is a data quality analysis and monitoring platform that helps data teams proactively understand, detect, and resolve data quality issues without writing code, SQL, or rules.

Intermediate Administrator Self-Learning Product Data Engineer Data Intelligence Data Steward brand_data_observability

Manage Projects

Actian Data Observability is a data quality analysis and monitoring platform that helps data teams proactively understand, detect, and resolve data quality issues without writing code, SQL, or rules.

Intermediate Administrator Self-Learning Product Data Engineer Data Intelligence Data Steward brand_data_observability

Actian Ingres 12.1 New and Updated Features

Many new features and functionality upgrades have been provided with the release of Actian Ingres 12.1. During this course you will learn about each of the new or updated features to ensure that you continue to extract the very best from our flagship database.

Intermediate Beginner Developer Administrator Business User Self-Learning Actian Ingres Operational Database Product Data Science Data Scientist Data Engineer Architect Actian Ingres 12.1

Monitoring: Identify Users Holding Locks

During this video we provide a demonstration for how to Identify users who are holding locks on tables within the database.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Efficiently Moving Large Tables to a Different Database using the SQL command 'Create Table As Select' (CTAS)

Using the Actian Ingres Star product can provide you with a very efficient way to move tables between databases which may be on different versions of OS, versions of Database Software and in different geographical locations! Find out more from watching this video.

Intermediate Administrator Self-Learning Actian Ingres Operational Database Product

High Availability Data Replication (HADR): How to set up a Shared Disk Secondary (SDS) Server .

A shared-disk (SD) secondary server participates in high-availability cluster configurations. In such configurations, the primary server and the SD secondary server share the same disk or disk array. During this video we describe and demonstrate the process for adding an SDS to your cluster.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HADR HCL Informix 14.1

Unload Data from your Platform Warehouse to your Google Cloud Store

Being able to seamlessly connect your Google Cloud Store to your Platform Warehouse is a great feature to allow you to not only read data in but also write data out to your Cloud Store. This training focuses on setting up your Platform Warehouse for writing data out to your Cloud Store.

Administrator Self-Learning Actian Data Platform Product Cloud Data Storage Google Cloud Platform

HCL Informix Explore System Settings

HCL Informix Explore is a modern web console for visualizing, monitoring, and managing your HCL Informix server instances. During this video we provide guidance for the 'System Settings' which can be configured via the web console to include alert notifications, data cleanup, report definitions, sensor and user management.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix explore

Command Line SQL/iSQL tools (Linux)

Take this course to understand how the command line tools SQL and iSQL operate within a Linux environment.

Vector Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Actian Data Platform Operational Database Product Vector 6.0

How to implement HCL Informix Database External Backup and Restore functionality

During this video we provide a demonstration for how to implement the HCL Informix External Backup and Restore functionality.

Intermediate Administrator Self-Learning Advanced Operational Database Product HCL Informix

Using OnBar to restore HCL Informix storage spaces (dbspaces) and logical files from a backup

Learn to use OnBar for restoring HCL Informix storage spaces and logical files with step-by-step guidance and best practices for System or Database Administrators.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix onbar brand_informix

Using the 'oncheck' utility to verify the integrity of a table data.

In this training session, we illustrate the utilization of the 'oncheck' command line utility to verify the integrity of data within a table, ensuring that no data inconsistencies have occurred. If any irregularities are detected, they must be rectified using either the oncheck utility's provided mechanisms or through a manual process.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Btrieve Mixed Security

Zen's "mixed mode" security allows NoSQL (Btrieve) applications to access data without granting users direct OS-level file permissions, enhancing security while maintaining application compatibility.

Zen Intermediate Beginner Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center

Actian Zen Control Center: Create 32-bit and 64-bit ODBC DSN records

In this video you will learn how to create Zen 32-bit and 64-bit ODBC DSN records

Zen Beginner Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center

Actian DataConnect Studio - Advanced Course

Actian DataConnect is the digital business platform for hybrid data integration, transformation, and management. In this course we provide you with an introduction to the key functionality found within Actian DataConnect Studio IDE.

Intermediate Beginner Developer Administrator Business User Self-Learning DataConnect Enterprise Data Integration Advanced Product

How to use the 'oncheck' utility to check the consistency of the root reserved pages within an existing HCL Informix server.

During this video we demonstrate how to use the 'oncheck' utility to ensure the consistency of the root reserved pages is as expected within an existing HCL Informix server.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Using the High Performance Loader to load and unload data from a HCL Informix Database.

During this training we demonstrate how to use the High Performance Loader command line utilities to load and unload data from a HCL Informix database.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

High Availability Data Replication (HADR) Cluster Configurations.

In this video we provide information for the different configurations available to accommodate the need for a High Availability Data Replication solution. It goes without saying that ensuring business continuity and data security are highly desirable outcomes for HCL Informix customers with mission critical production database environments.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix

Pattern Matching - SIMILAR_TO

During this video we provide a demonstration of how to make use of the new SIMILAR_TO pattern matching feature introduced with the release of Vector 6.3

Vector Beginner Developer Administrator Business User Self-Learning Product Data Scientist Data Engineer Vector 6.3

Using the 'dbload' utility to load data from text files into database tables.

During this training we demonstrate how to use the 'dbload' command line utility to load data, which is stored in a text file(s) into a HCL Informix database table(s)

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

How to Install and use Zen DataExchange.

Zen DataExchange is the Zen database replication solution. It manages copying data between two or more Zen databases to maintain warm backup systems, drive data into reporting servers, or synchronize remote databases. During this course we provide guidance for installing DataExchange and guide you through the process of creating a replication project.

Zen Intermediate Beginner Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center

How to use the 'ifxclone' utility to add new HDR/RSS Servers to an existing HCL Informix server.

During this video we demonstrate how to use the 'ifxclone' utility to add new HDR/RSS servers or nodes to an existing HCL Informix server.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Load and Transform Data into Actian Vector using Actian DataFlow

This short video will demonstrate how to use Actian DataFlow to read data from a CSV file and populate a table in an Actian Vector Database.

Vector Intermediate Beginner Developer Self-Learning Operational Database DataFlow Product

Download and Install the Actian Data Platform Command Line Interface (CLI) for Windows.

Follow this guide to learn how to download and install the Actian Command Line Interface (CLI) for Windows, and how to connect to a Platform Warehouse. This tool enables you to interactively enter, edit and execute individual queries or files containing queries.

Beginner Developer Administrator Business User Self-Learning Actian Data Platform Product Connectivity Google Cloud Platform Data Scientist

Essential Environment Variables required within a HCL Informix Database Installation.

During this video we spotlight the essential HCL Informix Environment Variables required for starting, running, connecting to and monitoring the database installation.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

ABFComp2OR Utility - Automate migrating ABF Components to equivalent OpenROAD Components

To assist with ABF to OpenROAD Application Modernization and migration projects the ABFComp2OR utility simplifies the migration of ABF components to equivalent OpenROAD components.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product ABF brand_openroad OpenROAD Server Application Modernization ABFComp2OR

How to configure HCL Informix CDC with HDR Secondary Servers

With HCL Informix version 15.0, you can use Informix Change Data Capture (CDC) on HDR secondary servers.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HADR HCL Informix 15.0

Unload Data from your Platform Warehouse to your Microsoft Azure Cloud Store

Being able to seamlessly connect your Microsoft Azure Cloud Store to your Platform Warehouse is a great feature to allow you to not only read data in but also write data out to your Cloud Store. This training focuses on setting up your Platform Warehouse for writing data out to your Cloud Store.

Administrator Self-Learning Actian Data Platform Product Cloud Data Storage Microsoft Azure

High Availability Data Replication (HADR), Connection Manager Configuration

In this video we provide information for configuring the connection manager. Connection Managers can control automatic failover for high-availability clusters, monitor client connections and direct requests to appropriate database servers, act as proxy servers and handle client/server communication, and prioritize connections between application servers and the primary server of a high-availability cluster.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HADR HCL Informix 14.1 HCL Informix 15.0

On-premises Installation of HCL Informix Server with the HCL Informix Binary

During this video we provide a demonstration on how to install the HCL Informix Server on-prem with the HCL Informix Binary.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

What is new in Actian Ingres 11.1

During this video you will gain an understanding of the new functionality or functionality changes available within Actian Ingres 11.1

Intermediate Developer Administrator Business User Self-Learning Actian Ingres Operational Database Product

Setting up a standalone Remote Secondary Server (RSS).

HCL Informix database software can be customized to create systems that provide uninterrupted services, minimize maintenance and downtime, and distribute both processing and storage across hardware.. During this training we provide a demonstration for how to set up a Remote standalone Secondary Server (RSS) for the first time using the 'ontape' Backup and Restore utility.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix High Availability

Bulk and Batch Data Loading Operations Explained

During this course we provide explanation and demonstration for the actions of either Bulk or Batch loading of data into an Actian Vector Database or Actian Data Platform Warehouse

Vector Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Actian Data Platform Product Data Ingestion Vector 6.0

Configure the Actian Zen Backup Agent for Windows

In this lesson you are guided through the process of configuring the Actian Zen Backup Agent to facilitate backing up Actian Zen datafiles with your own datafile backup solution for a Windows environment.

Zen Beginner Administrator Edge Data Management Product Zen Control Center

Workload Management - Phase 1

Take this course to understand how Workload Management - Phase 1 - has been implemented for the Actian Ingres, Vector and Actian Data Platform database products

Vector Intermediate Administrator Self-Learning Actian Ingres Actian Data Platform Advanced Operational Database Product Vector 6.0

Actian Data Platform Integration v2.0

Actian Data Platform Integration v2.0 is a low code no code data transformation platform that allows your business users of any level of technical ability to integrate data from disparate sources and perform complex in-flight transformations as required. The remodelled intuitive user interface makes the development and deployment of data integration tasks far easier than before. During this course discover how Actian Data Platform Integration v2.0 can help you to get the most out of your data.

Intermediate Beginner Administrator Actian Data Platform Enterprise Data Integration Data Ingestion Data Scientist Data Engineer brand_data_integration Data Integration v2

HCL Informix Enterprise Replication (ER)

HCL Informix supports business needs like fault tolerance, data replication and HA standby systems. Customers use ER for zero data loss, quick recovery, rolling upgrades, disaster protection, quick scaling, continuous availability, and local data storage for compliance. The information within this course introduces the ER feature set..

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HADR ER

OpenROAD 12.0 New and Updated Features

Many new features and functionality upgrades have been provided with the release of OpenROAD 12.0. During this course you will learn about each of the new or updated features to ensure that you continue to extract the very best from OpenROAD

Beginner Developer Business User OpenROAD Architect brand_openroad OpenROAD 12.0

Modifying Onconfig parameters for a HCL Informix Database Instance

During this video we describe the modification scope (Static vs Dynamic) for Onconfig parameters.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

OpenROAD Server Configuration (Windows)

The OpenROAD Server software provides utilities which allow for the configuration of OpenROAD Server and the deployment of OpenROAD Applications via JSON-RPC. During this course we will introduce the Visual OpenROAD Server Administrator (VOSA) application and the command line Python script ORServerAdm.py

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product brand_openroad OpenROAD Server Application Modernization Installation

Using OnBar to backup HCL Informix storage spaces (dbspaces) and logical files.

Learn to use OnBar for backing up HCL Informix storage spaces and logical files with step-by-step guidance and best practices for System or Database Administrators.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix onbar brand_informix

OpenROAD Server Installation for Linux

During this course you will be guided through the best practice for installing OpenROAD Server for Linux, post installation inspection and testing that requests to the server are being serviced

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product brand_openroad OpenROAD Server Application Modernization Installation

Create, Edit and Delete a Property

A property is a component of the metamodel used to store metadata specific to a given item. It allows providing context and/or categorizing the items in the catalog. The properties are also used as search criteria or filters and thus provide more efficient access to items. In this course we provide you with a demonstration for how to maintain properties within the Actian Data Intelligence Platform.

Beginner Administrator Self-Learning brand_zeenea Data Intelligence Product Specific Documentation

How to connect MS Access to a Zen database

Sometimes a need arises whereby you want to use your favourite third party tool to analyse the data stored within your corporate Zen Database. In this video we provide you with step by step instructions for connecting an MS-Access client to your Zen Database.

Zen Intermediate Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center

Identify, manage and monitor long transactions in a HCL Informix database

During this video we will explain what a long transaction is and how to identify and monitor long transactions using the 'onstat' command.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

How to use the Zen Tools and Debug requesters to investigate application Issues.

During this video we demonstrate how to use the Zen tools and debug requesters to debug certain application issues such as connectivity issues, errors opening Btrieve files and problems at startup etc.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product Zen Control Center

Using the 'oncheck' utility to check system catalog tables

During this training we demonstrate how to use the 'oncheck' command line utility to provide information for database tables, columns, indexes, views, constraints, stored procedures and privileges from the database system catalog tables.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

How to use the Zen Database Triggers both via SQL and the Btrieve Explorer

This video demonstrates how Actian Zen Database ‘triggers’ are implemented and executed as a result of an event occurring, such as a data insert or update event, performed against a nominated table or view. Additionally, we demonstrate that using the Btrieve Function Executor to modify data directly within the file will still cause any associated database triggers to execute and capture the change details.

Zen Intermediate Beginner Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center Zen 16.0

OpenROAD Server JSON-RPC Gatekeeper Installation for Windows

OpenROAD Server provides the ability to service JSON-RPC requests. There are a number of installation and configuration steps to follow in order to have the JSON-RPC Gatekeeper up and running. Follow along with this course to understand what is required.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product brand_openroad JSON OpenROAD Server Application Modernization Installation

How to use Data Sampling

In this course, you’ll learn about data sampling, a statistical technique for selecting and analyzing a representative subset of a dataset. You’ll explore how sampling helps you identify patterns and trends, and how using data samples in a data catalog enables you to quickly understand a dataset’s content, structure, and suitability for your specific use case.

Beginner Self-Learning brand_zeenea Data Intelligence Product Specific Data Sampling

Adding a remote server into Explore, configuring the SSL connectivity and adding the Explore agent

When setting up the remote monitoring of a Server the connectivity between the monitor and the Server must be secure. During this video we provide the guidance required to add the SSL configuration to a Server, add the Server into Explore and finally guidance is provided for adding the Explore agent to the remote server in order to manage the connectivity between server and monitor..

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix brand_informix onspaces

Using 'SET EXPLAIN' to understand the execution path of an SQL statement.

Use the SET EXPLAIN statement to enable or disable the recording measurements of queries in the current session, including the plan of the query optimizer, an estimate of the number of rows returned, and the relative cost of the query.

Intermediate Beginner Developer Administrator Self-Learning Operational Database Product HCL Informix SET Command

Machine Learning UDF's in Actian Data Platform and Vector

One of Actian's machine learning experts talks through how she has developed machine learning UDF's for Vector and Actian Data Platform Warehouses.

Vector Intermediate Beginner Developer Administrator Self-Learning Actian Data Platform Product Analytics Google Cloud Platform

In place upgrade to HCL Informix 15

HCL Informix facilitates an in-place migration, allowing you to upgrade the system without necessitating any changes to your existing hardware or operating system infrastructure.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0 Migration Upgrade

Upgrading your cloud based HCL Informix installation to the latest version of product.

Just because your mission critical HCL Informix database installation resides in a cloud environment does not exclude it from the need to migrate to latest versions of software. Migrating to the latest versions of software is supported best practice. In this course we provide you with best practice advice and guidance for migrating your cloud based HCL Informix to the latest version of product.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix AWS Cloud Migration

Actian DataConnect: Design Integrations on Premise, Deploy and Run in Actian Data Platform

During this course we aim to provide you with guidance to create an integration with Actian DataConnect v12 on premise and to deploy and run this configuration in Actian Data Platform.

Intermediate Beginner Developer Administrator Self-Learning DataConnect Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Restoring an HCL Informix database from backup files using the OnTape utility

During this video we demonstrate how to use the OnTape utility to restore a HCL Informix database from backup files.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Using the 'onsmsync' utility for backup and restore purposes of a HCL Informix database

During this video we demonstrate how to use the 'onsmsync' utility for backup and restore purposes of a HCL Informix database.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Connecting Tableau Desktop Client to your Platform Warehouse

Learn how to connect Tableau Desktop to your Actian Data Platform Warehouse and access corporate data for analysis and reporting.

Developer Administrator Business User Self-Learning Actian Data Platform Product Third Party Tools Google Cloud Platform

Unload Data from your Platform Warehouse to your AWS S3 Coud Store

Being able to seamlessly connect your AWS S3 Cloud Store to your Platform Warehouse is a great feature to allow you to not only read data in but also write data out to your Cloud Store. This training focuses on setting up your Platform Warehouse for writing data out to your Cloud Store.

Administrator Self-Learning Actian Data Platform Product Cloud Data Storage AWS S3

Auditing database activity with the 'onaudit' and 'onshowaudit' utilities.

Use these two auditing utilities to audit user activity within a HCL Informix database. Auditing creates a record of selected activities that users perform. An audit administrator who analyzes the audit trail can use these records to identify any unusual activity such as detecting unusual or suspicious user actions and identify the specific users who performed those actions.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Using the Btrieve 2 SDK with Python

Btrieve 2 is a new Btrieve interface for developers of Zen database applications. The Btrieve 2 API offers a simplified, more intuitive alternative for sending the full set of Btrieve calls to the database engine. Zen developers can make use of the performance and flexibility of Btrieve without having to learn and manage the complexity of the original Btrieve API. In this video we demonstrate using Python along with Btrieve 2.

Zen Intermediate Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center brand_zen

Actian DataConnect v12: RabbitMQ

During this course we aim to provide you with guidance for the new RabbitMQ Queue Step which has been added into Actian DataConnect v12

Intermediate Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product

Install and Configure Audit Master 16 over Actian Zen v16

Audit Master (or AM for short) is an add-on installation that is part of the ECO products that can be installed on top of Zen. The ECO products consist of AuditMaster, BackupAgent, and DataExchange. In this video we provide a demonstration of how to install Audit Master 16 into an Actian Zen 16 installation.

Zen Intermediate Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center brand_zen

Initialising an HDR configuration for the first time.

To setup an HDR configuration you must have at least two servers a primary and a secondary server. The secondary server must always be in step with the primary server as a hot standby. To initialise the secondary server a copy of the primary server database must be initially made and reloaded on to the secondary server. In this demonstration we use the ontape utility to initialise the secondary server.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HADR HCL Informix 15.0 ontape

High Availability Data Replication (HADR): Configuration Parameters related to a Cluster

Managing failover scenarios involves ensuring continuous system availability by automatically switching to a backup system or component when the primary system fails. Effective failover management minimizes downtime and maintains service continuity, ensuring business operations remain unaffected by unexpected system failures. In this video we provide guidance for the configuration parameters related to a HADR cluster.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HADR HCL Informix 14.1 HCL Informix 15.0

How to use and interpret Zen Performance Monitor counters

A Zen server on Windows provides performance counters for use with the Windows Performance Monitor. The performance counters measure state or activity of the database engine, which allows you to analyze performance of your application. Windows Performance Monitor requests the current value of the performance counters at specified time intervals. In this video we provide you with the guidance required to make the best use out of performance counters.

Zen Intermediate Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center brand_zen

How to recover a Primary Chunk from a Mirror Chunk

Mirroring is a strategy that pairs a primary chunk of one defined dbspace, blobspace, or sbspace with an equal-sized mirror chunk. Every write to the primary chunk is automatically accompanied by an identical write to the mirror chunk. If media failure occurs, mirroring provides the database server administrator with a means of recovering data without taking the database server offline. In this video we demonstrate how to perform a recovery of a Primary Chunk from a Mirror Chunk.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix High Availability brand_informix HADR HCL Informix 14.1 HCL Informix 15.0

Activate the Actian Zen License

In this short lesson you are guided through the process of activating an Actian Zen License

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product Zen Control Center

Configuration and administration of the Primary Storage Manager (PSM).

During this video we demonstrate how to configure and administer the Primary Storage Manager (PSM) for HCL Informix.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Auditing Onkstore CDC (Change Data Capture) Session IDs

Auditing Onkstore CDC (Change Data Capture) Session IDs is crucial for maintaining data transparency, security, and compliance in enterprise data systems. Onkstore, designed to manage and log real-time data changes, assigns a unique Session ID to each CDC operation.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0 onshowaudit

HCL Informix Index Key Size

Indexes play a crucial role in improving query performance by enabling faster data retrieval. However, in earlier versions of the HCL Informix, index creation was often limited by the page size and the maximum key length that could fit within a single page. In the latest version, HCL Informix has addressed this limitation by supporting larger page sizes, which in turn allows for larger index key sizes.

Intermediate Beginner Administrator Self-Learning Advanced Operational Database Product HCL Informix brand_informix HCL Informix 15.0

OpenROAD Server Installation for Windows

During this course you will be guided through the best practice for installing OpenROAD Server for Windows, post installation inspection and testing that requests to the server are being serviced

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product brand_openroad OpenROAD Server Application Modernization Installation

Actian Data Intelligence Platform: Explorer Search and Filter

The Actian Data Intelligence Platform Explorer search engine uses a fuzzy search algorithm, which facilitates exploration. In other words, it will try to find all the Objects that correspond exactly to the keywords provided and those that correspond to keywords close to those entered. On the results page, you can use filters to refine your search and reduce the number of results returned.

Beginner Self-Learning brand_zeenea Data Intelligence Product Specific Search

HCL Informix Database server deployment using Helm Charts

During this video we provide a demonstration of how to deploy the HCL Informix Database Server using Helm Charts

Intermediate Beginner Administrator Self-Learning Operational Database Product Helm 4.27 HCL Informix

Onstat Utility – important onstats for day-to-day usage

Onstat is vital command for any DBA to master and provides numerous views into the inner workings of the HCL Informix database server

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Actian Zen Control Center : Import/Export Database Schema

In this course you will learn how to use Zen Control Center to both import and export

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product Administration Zen Control Center

DataConnect Platform Overview (self-paced)

This course will give an overview of the DataConnect Platform including the Design Studio Integrated Development Environment (IDE), Integration Manager, and walkthrough of an end-to-end Design, Deploy, and Manage exercise with no experience necessary.

Beginner Developer Administrator Self-Learning DataConnect Product

DataConnect Core Exercises (self-paced)

The DataConnect Core Exercises course will supply the user with detailed examples that use core components and mapping techniques of the Map Editor, Process Workflow Editor, and Integration Manager. The exercises are task-based which illustrate a variety of techniques applicable to the majority of integration scenarios you may encounter.

Beginner Developer Self-Learning DataConnect Product

Actian Data Platform Assistant

To provide assistance, should it be required, we have developed the Platform Assistant which is readily available from the Platform Home Page. This training provides you with guidance for how to engage with the Platform Assistant.

Beginner Administrator Self-Learning Actian Data Platform Product Getting Started Google Cloud Platform

Connect Actian DataConnect to a Platform Warehouse using ODBC

Gain insight into the necessary procedures for establishing a connection between Actian DataConnect and a Platform Warehouse.

Developer Administrator Business User Self-Learning DataConnect Actian Data Platform Product Third Party Tools Google Cloud Platform

Actian Data Platform Warehouse : Data Integrity Constraints

Follow this guide to gain an elementary understanding of how to implement Data Integrity Constraints within a Platform Warehouse.

Beginner Developer Administrator Self-Learning Actian Data Platform Product Administration Google Cloud Platform

Actian Data Platform Warehouse : Table Partitioning

Follow this guide to gain an elementary understanding of Table Partitioning and how to implement Table Partitioning.

Beginner Administrator Self-Learning Actian Data Platform Product Administration Google Cloud Platform

Data Integration: Templates - Delimited Data file from a GCP bucket into an Actian Data Platform Warehouse on GCP

Follow this guide to comprehend how to leverage the Data Integration Templates functionality. Templates contain integration settings that can be reused by linked configurations. This guide will walk you through using these templates to move data content from a Google Cloud Platform (GCP) data file into a Platform Warehouse provisioned on the Google Cloud Platform.

Beginner Developer Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Data Integration: Integration Listeners

This course provides you with the knowledge required to create an Integration Listener to remotely execute an Actian Data Platform integration configuration. An Integration Listener serves as an API endpoint linked to an existing Integration configuration, allowing the remote execution of the associated configuration through the API endpoint.

Beginner Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Data Integration: Agents

Agents enable remote execution management of on-premise jobs and related collateral. They enable secure cloud-to-on-premises communication without special firewall rules or VPN requirements. Take this training to gain an understanding for an Agent is defined within the Actian Data Platform.

Beginner Developer Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Data Integration: Actian Data Platform Functionality Overview

Follow this guide to explore the essential concepts and capabilities of data integration options available through the Platform warehouse dashboard.

Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product Getting Started AvalancheConnect Google Cloud Platform Data Integration

Install the Platform ODBC Data Driver for Linux

Connecting your favourite data access utilities to the Platform is a key requirement. The training provided here will guide you through how to download the Platform ODBC Data Driver for Linux and demonstrate how to connect to a Platform Warehouse.

Beginner Administrator Self-Learning Actian Data Platform Product Connectivity Google Cloud Platform

Install the Platform Data Driver for Apple MAC

Connecting your favourite data access utilities to the Platform is a key requirement. The training provided here will guide you through how to download the Platform Data Driver for Apple MAC OS and demonstrate how to connect to a Platform Warehouse.

Developer Administrator Business User Self-Learning Actian Data Platform Product Connectivity Google Cloud Platform

Connect your Platform Warehouse to your Microsoft Azure Datastore.

Connecting your Microsoft Azure Datastore to a Platform Warehouse is very simple and provides you with access to your Microsoft Azure Datastore Data via the Platform Warehouse in a few simple steps. This training provides the guidance required to make that connection.

Administrator Self-Learning Actian Data Platform Product Cloud Data Storage Google Cloud Platform

The Future of Cloud Data Platforms

Take a look at where Data Warehousing began through to where it is today and how Actian now provides the Actian Data Platform.

Intermediate Beginner Developer Administrator Self-Learning Actian Data Platform Advanced Product Getting Started Google Cloud Platform

Using Google Single Sign-on (SSO) authentication to connect to connect to the Platform

To facilitate ease of connection, but not compromising on security, the Platform allows for Single Sign-On authentication using Google SSO authentication. The training provided here guides you through the process of using SSO security to connect data processing utilities.

Beginner Administrator Business User Self-Learning Actian Data Platform Product Connectivity

Connecting your PowerBI software to your Platform Warehouse

PowerBI is a major player in the Data analytics world and that is not overlooked here. This training provides the steps required to connect your Platform Warehouse to your PowerBI software and demonstrates how to verify that the connection is available for report/dashboard building.

Developer Administrator Business User Self-Learning Actian Data Platform Product Third Party Tools Google Cloud Platform

Connecting your JMP software to your Platform Warehouse

JMP Statistical Software is a major player in the Data analytics world and that is not overlooked here. This training provides the steps required to connect your Platform Warehouse to your JMP software and demonstrate how to verify that the connection is good to go.

Developer Administrator Business User Self-Learning Actian Data Platform Product Third Party Tools Google Cloud Platform

Actian Data Platform: Architect Learning Path

A curated learning path providing a seasoned Solution Architect with all they require to gain a clear understanding of the functionality provided by the Actian Data Platform for data ingestion,transformation,security and storage. With this knowledge design the solution required.

Intermediate Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Zen Control Center: Configure a Zen Server

In this lesson we demonstrate how to configure a Zen Server with the Actian Zen Control Center

Zen Beginner Administrator Edge Data Management Product Zen Control Center

Installing Actian Director

This video demonstrates how to install Actian Director and also introduces the Actian Director GUI.

Intermediate Developer Administrator Self-Learning Actian Ingres Operational Database Product Administration

How to migrate the Zen Metadata from Version 1 to Version 2 using Zen v15.

Demonstrated during this video will be the support best practice guide for migrating the Zen Metadata from V1 to V2 using Zen v15.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product Zen Control Center

Managing Actian Ingres Installations and Databases (self-paced)

This course provides insight into all aspects of planning, installation, configuration, and day to day running of the Actian Ingres installation. It also covers all aspects of database administration including: managing database objects such as tables, indexes, applications etc.; data integrity; security; backup and recovery; table maintenance and optimization.

Administrator Self-Learning Operational Database Product

Actian Zen Control Center : Query a Database Table

In this lesson you will learn how to query a database table via the Zen Control Center interface.

Zen Intermediate Beginner Developer Administrator Self-Learning Edge Data Management Advanced Product Zen Control Center

Install the Actian Zen Backup Agent for Windows

In this lesson you are guided through the process of installing the Actian Zen Backup Agent within a Windows environment.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product

Actian DataConnect v12: Target Connector Changes

During this course we aim to provide you with guidance for the Target Connector changes which have been implemented within Actian DataConnect v12

Intermediate Beginner Developer Administrator Business User Self-Learning DataConnect Enterprise Data Integration Product

Common Licensing Issues for Actian Zen

During this video we go through a number of common licensing issues experienced by customers and provide guidance for how to overcome those issues.

Zen Intermediate Developer Administrator Self-Learning Product

Actian Zen Control Center : Securing the Zen Database

In this lesson you will learn how to secure the Zen database via the Zen Control Center interface.

Zen Intermediate Beginner Developer Administrator Self-Learning Edge Data Management Product Zen Control Center

How to capture an Actian Zen SQL Query plan and use the Query Viewer feature.

During this course supported best practice guidance is provided for capturing an Actian Zen SQL Query plan and, utilising the Query Viewer feature to review the efficiency of the SQL query, optimize the query accordingly by applying or fine tuning table indexes.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product Zen Control Center

Actian Zen Control Center: Building Actian Zen database tables from data files using DDFBuilder

This video will demonstrate how to build tables for existing data files using DDFBuilder. Some metadata information is available in the data file itself, but much of the column layout information is not. DDFBuilder will use this available information and allow you to analyze the data to best determine the data structure within the file..

Zen Intermediate Beginner Developer Administrator Self-Learning Edge Data Management Product Zen Control Center

Actian Zen Control Center : Monitor

In this course you will learn how to monitor your Actian Zen installation via the Zen Control Center

Zen Intermediate Beginner Developer Administrator Self-Learning Edge Data Management Product Zen Control Center

Actian DataConnect v12: JSON Connector Enhancements

During this course we demonstrate the JSON Connector enhancements now available within Actian DataConnect v12.

Intermediate Beginner Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product

Actian DataConnect v12: What is Data Profiler and how does it work

During this course we aim to provide you with an overview of how to use Data Profiler, Data Profiler Invoker using Process Designer and Data Profiler CLI for Actian DataConnect v12

Intermediate Beginner Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product

Actian DataConnect v12: Zip Aggregator

During this course we aim to provide you with an introduction to the Zip Aggregator functionality now available for Actian DataConnect v12

Intermediate Beginner Developer Self-Learning DataConnect Enterprise Data Integration Product

Use Microsoft Excel application to Access a Zen database using ODBC connectivity.

In this video you will learn how to use Microsoft Excel application to Access a Zen database using ODBC connectivity.

Zen Beginner Administrator Business User Self-Learning Edge Data Management Product

Actian DataConnect v12: Macro List User Interface Changes

During this course we highlight the Macro List usability improvement which have been implemented within Actian DataConnect v12

Intermediate Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product

Actian DataConnect v12: Migrate to newer version of SQL Server connector

During this course we demonstrate the Connector Migration Wizard functionality now available within Actian DataConnect v12.

Intermediate Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product

Install Actian Zen into Linux

In this short lesson you are guided through the process of installing Actian Zen into a Linux environment.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product

Actian DataConnect v12: Zip Iterator

During this course we aim to provide you with an introduction to the Zip Iterator functionality now available for Actian DataConnect v12

Intermediate Beginner Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product Data Scientist

Actian DataConnect v12: A summary of new user interface features added into Actian DataConnect v12

During this course we demonstrate the new user interface features which are available within Actian DataConnect v12.

Intermediate Beginner Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product

Actian Zen Control Center: Connecting Microsoft Power BI to an Actian Zen Database using ODBC

This video will demonstrate how to connect Microsoft Power BI to an Actian Zen Database using ODBC.

Zen Intermediate Beginner Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center

Scheduling Platform Warehouse Events

This course equips you with the necessary knowledge to create scheduled events on your Platform Warehouse, enabling you to execute specific actions at predefined intervals, such as starting, stopping, or scaling a warehouse. Additionally, the course covers the procedures for editing and removing scheduled events.

Intermediate Beginner Administrator Self-Learning Actian Data Platform Product Administration Google Cloud Platform

Actian Zen Control Center : Create a new database

In this lesson you will learn how to create a new database via the Zen Control Center interface.

Zen Intermediate Administrator Self-Learning Learning Path Edge Data Management Advanced Product Zen Control Center

How to: Install Zen Core on iOS for Development

In this course we provide you with a step by step guide for installing Zen Core on iOS for Development.

Zen Administrator Self-Learning Edge Data Management Advanced Product Administration

Actian DataConnect v12: Mapping Changes

During this course we aim to provide you with guidance for the Mapping changes which have been implemented within Actian DataConnect v12

Intermediate Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product

Actian Zen Control Center : Create a Database Table

In this lesson you will be guided through the process for creating a database table via the Zen Control Center

Zen Intermediate Beginner Developer Administrator Business User Self-Learning Edge Data Management Product Zen Control Center

Actian Zen Control Center: Export and Import table data

In this course we provide you with a step by step guide for exporting and importing data from Zen tables

Zen Beginner Administrator Self-Learning Edge Data Management Product Zen Control Center

Actian Zen Control Center : Rebuild Tool

In this course you will learn how to use Zen Control Center to Rebuild Tool

Zen Intermediate Developer Administrator Self-Learning Edge Data Management Advanced Product Zen Control Center

Actian DataConnect v12: Introduction to Data Profiler

During this course we aim to provide you with an introduction to the Data Profiler functionality now available for Actian DataConnect v12

Intermediate Beginner Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product

How to: Install Zen Core on Android for Development

In this course we provide you with a step by step guide for installing Zen Core on Android for Development.

Zen Administrator Self-Learning Edge Data Management Advanced Product Administration

Connecting your SQuirreL SQL software to your Platform Warehouse

SQuirreL SQL is a major player in the SQL utility space and that is not overlooked here. This training provides the steps required to connect your Platform Warehouse to your SQuirreL SQL software and demonstrates how to verify that the connection is good to go.

Intermediate Beginner Administrator Self-Learning Actian Data Platform Third Party Tools Google Cloud Platform

Data Integration: Salesforce to an Actian Data Platform Warehouse on GCP

This course will guide through the process of creating an integration within Actian Data Platform to seamlessly transfer data from Salesforce into a Platform Warehouse on the Google Cloud Platform.

Intermediate Beginner Administrator Self-Learning Actian Data Platform Enterprise Data Integration Product AvalancheConnect Google Cloud Platform

Actian Zen Control Center: Defragment Actian Zen Data Files

In this course we provide you with a step by step guide for defragmenting Actian Zen data files

Zen Intermediate Administrator Self-Learning Edge Data Management Advanced Product Zen Control Center

How to Install Actian Ingres in Kubernetes using Helm

How to set up an instance of Actian Ingres running in a container (pod) in a Kubernetes cluster using Helm. This includes how to correctly license this instance of Actian Ingres.

Intermediate Developer Administrator Self-Learning Actian Ingres Product Helm 3.5.0 Actian Ingres 11.2

Actian Zen Control Center Overview

In this lesson we provide an overview of the Actian Zen Control Center user interface.

Zen Beginner Developer Administrator Self-Learning Edge Data Management Product Zen Control Center

Install Actian Zen into Windows

In this short lesson you are guided through the process of installing Actian Zen into a Windows environment.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product

Install the Actian Zen Reporting Engine into Windows

In this short lesson you are guided through the process of installing the Actian Zen Report Engine into a Windows environment.

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product

How to: patch an Actian Zen Installation for Windows OS

In this course you will learn how to patch an Actian Zen installation for Windows OS

Zen Intermediate Beginner Administrator Self-Learning Edge Data Management Product Zen Install, License and Backup

Actian DataConnect v12: Automatic Mapping Transformer

During this course we demonstrate how to configure and use the Automatic Mapping Transformer functionality within Actian DataConnect v12.

Intermediate Beginner Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product

Actian Ingres ABF - Application Development (self-paced)

This course introduces the ABF development environment and guides delegates through the development of an application using the Actian Visual Forms Editor (Vifred) and Actian/4GL.

Beginner Developer Self-Learning Operational Database Product

How to Interact in the Communities

Connect with Actian Developers/ Support & Community Users Via Forum Questions/ Discussions

Product Post to Community

Groups - Product updates

Stay tuned and get notified about valuable product information via Groups.

Community Groups Latest Release Collaboration Groups Latest Patch Product

Connect Actian DataConnect to ServiceNow

During this course you will learn how to connect Actian DataConnect to ServiceNow

Intermediate Beginner Developer Administrator Self-Learning DataConnect Enterprise Data Integration Product Administration

Actian DataConnect Platform Overview

This course provides you with an overview of key Actian DataConnect functionality

Beginner Developer Administrator Business User Self-Learning DataConnect Enterprise Data Integration Product

End of Life for Adobe Flash and Actian DataConnect v10

This course provides the information required to migrate your DataConnect projects from v10 to v11 and overcome the Adobe Flash end of life issue

Intermediate Developer Administrator Self-Learning DataConnect Enterprise Data Integration Advanced Product

Actian DataConnect - upgrade from v10 to v11

A series of videos which guide you through the key areas of note when upgrading from DataConnect version 10 to v11.

Administrator Self-Learning DataConnect Enterprise Data Integration Advanced Product

Actian DataConnect - upgrade from v9 to v11

An introduction to Actian DataConnect v11 new features and functionality plus an overview on upgrading your Actian DataConnect v9 environment to v11.

Developer Administrator Business User Self-Learning DataConnect Enterprise Data Integration Advanced Product

Actian DataFlow for Beginners

This beginners level course guides you through how DataFlow works with KNIME and how to create your first DataFlow workflow.

Beginner Developer Administrator Business User Self-Learning Enterprise Data Integration DataFlow Product

Process Azure Blob Store data using Actian DataFlow

This course provides a description of the steps required to connect Actian DataFlow to an Azure Blob Store account.

Intermediate Developer Administrator Self-Learning Operational Database DataFlow Product

Actian NoSQL: Installation and use of the Actian NoSQL Operator to manage Actian NoSQL database in Kubernetes

In this course we demonstrate how to install and use the Actian NoSQL Kubernetes Operator to deploy a single server NoSQL Database and fault tolerant NoSQL Database servers.

Intermediate Administrator Self-Learning NoSQL Product

Actian NoSQL: Basic Backup and Restore

In this video you will learn to back up a database using the NoSQL vbackup command, and subsequently restore it.

Beginner Administrator Self-Learning NoSQL

Actian NoSQL: Enabling the Client Trace File

In this course learn what a Client Trace File is and how it is implemented.

Intermediate Administrator Self-Learning NoSQL Product

Actian NoSQL: Installation in Console Mode

Shows how to install NoSQL using Command Line Interface (CLI)

Beginner Developer Administrator Self-Learning NoSQL Product

Introduction to Actian NoSQL Database Management System (self-paced)

This course is aimed at delegates who will be responsible for managing Actian NoSQL installations and databases. It covers all aspects of planning, installing, configuring and managing Actian NoSQL databases. It also covers all aspects of database administration including: managing database objects such as tables, indexes, applications, data integrity, security, backup and recovery.

Intermediate Administrator Self-Learning Advanced Operational Database NoSQL Product

Actian NoSQL: Using Custom Identifiers for persistence objects

In this course we demonstrate how to make use of more natural data identifiers (custom identifiers) to identify persistence objects. For example, a social security number (SSN) is a more natural data identifier than using then an identifier provided and managed by Actian NoSQL JPA.

Intermediate Developer Self-Learning Advanced NoSQL Product

Actian NoSQL: How to use the pkgcore script to collect core-files

How to use the 'pkgcore' script to generate two files that have the dynamic libraries linked correctly when debugging a core file on a computer where the core file was NOT generated.

Intermediate Developer Administrator Self-Learning NoSQL Product

Actian NoSQL: Installation via the GUI Interface

In this course we demonstrate how to install the NoSQL software utilising the Graphical Interface.

Intermediate Administrator Self-Learning NoSQL Product

Actian NoSQL: Entity Supplements

This video explains Entity Supplements which are a new feature of Actian NoSQL JPA.

Intermediate Developer Administrator Self-Learning NoSQL

Managing Vector Installations and Databases (self-paced)

This course is aimed at delegates who will be responsible for managing Vector instances and databases under Linux or Windows.

Learning Path Product Vector 6.0

Smart MinMax Index

During this video we provide a demonstration of how to make use of the new Smart MinMax Index feature introduced with the release of Vector 6.3

Vector Intermediate Administrator Self-Learning Advanced Product Administration Vector 6.3

Actian Vector - Inserts, Updates and Deletes

This short informational video provides guidance in relation to adding, modifying and deleting records from Actian Vector

Vector Intermediate Beginner Developer Administrator Self-Learning Actian Data Platform Product Administration Vector 6.0

What's new in Actian Vector 6.0

Here we provide an overview of the new features found in Actian Vector 6.0

Vector Intermediate Beginner Developer Administrator Business User Self-Learning Actian Data Platform Product Vector 6.0

Using NumPy (Numerical Python) and the handling of NULLS within a Vector User Defined Function (UDF).

During this video we provide a demonstration of how to make use of Python's NumPy functionality and how to handle NULL values within a Vector User Defined Function (UDF).

Vector Intermediate Developer Administrator Self-Learning Advanced Product Data Science Data Scientist Vector 6.2

Automatic Log Rotation

During this video we provide a demonstration of how to make use of the new Automatic Log Rotation feature introduced with the release of Vector 6.3

Vector Administrator Self-Learning Advanced Product Administration Vector 6.3

What's new in Actian Vector 6.3

Here we provide an overview of the new features found in Actian Vector 6.3

Vector Intermediate Beginner Developer Administrator Business User Self-Learning Actian Data Platform Advanced Product Data Scientist Vector 6.3

Database Procedure Exception Handling

During this video we provide a demonstration of how to make use of the new Database Procedure Exception Handling feature introduced with the release of Vector 6.3

Vector Intermediate Developer Administrator Self-Learning Product Data Scientist Data Engineer Vector 6.3

Spark Vector Connector 3.0

During this course we provide an introduction to the Spark Vector Connector 3.0 and guidance on how to install and configure the Spark-Vector Provider, import and export data using the Spark connector and demonstrate how to use the new staging table feature.

Vector Administrator Self-Learning Advanced Product Vector 6.2

Actian Vector - Extending a Database

This video provides you with step by step instructions for adding a new data location to an Actian Vector Database using the ExtendDB functionality.

Vector Intermediate Administrator Self-Learning Actian Data Platform Advanced Product Vector 6.0

Incremental Backup

During this video we provide a demonstration of how to make use of the new Incremental Backup feature introduced with the release of Vector 6.3

Vector Administrator Self-Learning Actian Ingres Advanced Product Administration Vector 6.3

Query Result Caching and Spill to Disk

During this video we provide a demonstration of how to make use of the new Query Result Caching feature introduced with the release of Vector 6.2 and the Spill to Disk feature released in Vector 6.3

Vector Administrator Self-Learning Actian Data Platform Advanced Product Vector 6.3

Actian Vector: Workload Management

This course provides you with insight for the Workload Management (WLM) functionality which is available in Actian Vector 6.2 onwards

Vector Intermediate Administrator Self-Learning Product Administration Vector 6.0

Actian Vector - Joins

This short informational video provides guidance in relation to joining Actian Vector tables

Vector Intermediate Beginner Developer Administrator Self-Learning Product Vector 6.0

Automatic Table Partitioning

During this course we provide guidance in relation to the implementation of the Vector Automatic Table Partitioning functionality.

Vector Intermediate Administrator Self-Learning Product Administration Vector 6.0

UDF Engine Startup

During this video we explain the revised method for when and how the UDF engine is started which has been introduced with the release of Vector 6.3

Vector Intermediate Administrator Self-Learning Product Vector 6.3

Control Output and Restricting Rows in Actian Vector

Within this course beginners guidance is provided for the functionality available to control what is included in a result set generated by an SQL statement against an Actian Vector database

Vector Beginner Developer Administrator Self-Learning Operational Database Product Vector 6.0

VWLOAD functionality updates

During this video we provide a summary of the updates which have been included within the release of Vector 6.3

Intermediate Developer Administrator Self-Learning Product Data Engineer Vector 6.3

Introduction to the Platform Warehouse Monitoring Interface

In this video we provide you with a tour of our Actian Data Platform Warehouse monitoring interface. The Platform Warehouse Monitoring console presents service statistics about active queries, connected sessions, disk usage and more.

Intermediate Beginner Administrator Self-Learning Actian Data Platform Product Administration Google Cloud Platform

Technical Update - Actian Vector and Avalanche

This Actian technical update was recorded 22nd February 2021 and includes a product roadmap review and a customer use case with Paul Firth from the AA.

Vector Intermediate Beginner Developer Administrator Business User Self-Learning Actian Data Platform Product Technical Update

Create a Platform Warehouse

To store your data you are going to need a Warehouse. This training provides you with a step by step guide for creating a Warehouse along with providing guidance for setting up who is able to connect to the Warehouse.

Beginner Administrator Self-Learning Actian Data Platform Product Administration Getting Started Google Cloud Platform

Connecting DBeaver to your Platform Warehouse

For those who like to craft and execute SQL commands an SQL utility such as DBeaver is a must have tool. DBeaver is a very popular SQL utility across the data processing community. This training provides step by step instructions for connecting DBeaver to one or more Platform Warehouses.

Developer Administrator Business User Self-Learning Actian Data Platform Product Third Party Tools Google Cloud Platform

Install the Actian Data Platform JDBC Data Driver for WINDOWS

Connecting your favourite data access utilities to the Platform is a key requirement. The training provided here will guide you through how to download the Platform JDBC Data Driver and demonstrate how to connect to a Platform Warehouse.

Beginner Business User Self-Learning Actian Data Platform Product Connectivity Google Cloud Platform

Using the OnParams utility to modify the configuration of both logical and physical logs.

During this video we demonstrate how to use the OnParams utility to relocate both the physical and logical logs into separate dbspaces.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

How to collect HCL Informix Diagnostic Information using the ifxcollect utility

During this video we provide a demonstration for how to collect HCL Informix Diagnostic Information using the ifxcollect utility.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

How to use the DBAccess Utility against a HCL Informix Database Servers

During video we demonstrate how to use the DBAccess utility to access, modify, and retrieve information from HCL Informix Database Servers.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Using the OnSpaces utility for HCL Informix to create dbspaces and chunks.

During this video we demonstrate how to use the OnSpaces utility to create 'dbspaces' and chunks' for a HCL Informix Database Instance.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

How to move the HCL Informix SysAdmin database to an alternative DBSpace

During this video we provide a demonstration for how to move the HCL Informix SysAdmin Database to an alternative DBSpace.

Intermediate Administrator Self-Learning Advanced Operational Database Product HCL Informix

Managing the Warehouse IP Allow List

Security is a top priority for Actian Data Platform and restricting the connections to a Warehouse is one of the security measures in place. Follow this training to understand how to the IP Allow List for your Warehouse(s).

Administrator Self-Learning Actian Data Platform Product Administration Google Cloud Platform

Install the Platform ODBC Data Driver for Windows

Connecting your favourite data access utilities to the Platform is a key requirement. The training provided here will guide you through how to download the Platform ODBC Data Driver and demonstrate how to connect to a Platform Warehouse.

Beginner Administrator Business User Self-Learning Actian Data Platform Product Connectivity Google Cloud Platform

Platform Query Editor

The Platform Query Editor is a browser based SQL query editor which facilitates the creating and executing of your SQL commands against the data stored in your Platform Warehouse.

Intermediate Developer Administrator Business User Self-Learning Actian Data Platform Product Administration Getting Started Google Cloud Platform

Actian Data Platform: Platform User Administration

This video illustrates the process of managing platform user records within the Actian Data Platform. It covers tasks such as creating new platform user records and assigning the appropriate privileges to these user records.

Beginner Administrator Self-Learning Actian Data Platform Product Administration Google Cloud Platform

Security: Create a Platform Warehouse Native User account

Refer to this guide for step-by-step instructions on creating a native user account for an Actian Data Platform Warehouse.

Administrator Self-Learning Actian Data Platform Product Administration Google Cloud Platform

Installation of the HCL Informix Explore software and the configuration of the graphical user interface (GUI)

During this video we will demonstrate how to install HCL Informix explorer software, gain access to the graphical user interface (GUI) and troubleshoot the software if unable to configure.

Intermediate Beginner Administrator Self-Learning Operational Database Product Administration HCL Informix explore

Using the 'onstat' utility to monitor disk usage and performance.

During this training we demonstrate how to use the 'onstat' utility to monitor the performance of disk utilisation for a OneDB server.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Using the 'onstat' utility to monitor memory in an HCL Informix database

During this video we will how to use the 'onstat' utility to monitor memory utilization.

Intermediate Beginner Administrator Self-Learning Operational Database Product HCL Informix

Security: Remove a native user and schema from a Platform Warehouse

Follow this guide for step-by-step instructions for removing a native user and associated schema from an Actian Data Platform Warehouse.

Administrator Self-Learning Actian Data Platform Advanced Product Administration Google Cloud Platform

Actian Data Platform Warehouse Scaling

This course provides you with the knowledge required to manually and schedule the scaling of your Actian Data Platform Warehouse.

Intermediate Beginner Administrator Self-Learning Actian Data Platform Product Administration Google Cloud Platform

Connect your Platform Warehouse to your Google Cloud Store

Connecting your Google Cloud Store Data to a Platform Warehouse is very simple and provides you with access to the Google Cloud Store Data via the Platform Warehouse in a few simple steps. This training provides the guidance required to make that connection.

Administrator Self-Learning Actian Data Platform Product Cloud Data Storage Google Cloud Platform

Connect your Platform Warehouse to your AWS S3 Storage.

Connecting your AWS S3 Storage to a Platform Warehouse is very simple and provides you with access to the AWS S3 Storage Data via the Platform Warehouse in a few simple steps. This training provides the guidance required to make that connection.

Administrator Self-Learning Actian Data Platform Product Cloud Data Storage Google Cloud Platform

Actian Data Data Platform Architect: Overview

The course provides context and an overview for the Actian Data Platform

Intermediate Beginner Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Performance Optimization

Insight to improve query performance and discover how to use the inbuilt query execution plan to determine if a specific query is executing efficiently or not.

Intermediate Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Data Access Security

Data security is of utmost importance to organizations. The Actian Data Platform offers native data security for implementation in accordance with your company's needs. From the restricted access to table data, data masking and encryption of data at rest.

Intermediate Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Data Loading

Actian Data Platform offers functionality that is executed via the command line to facilitate loading data via batch process in addition to its rich browser-based native data ingestion functionality.

Intermediate Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Data Integration

Actian Data Platform provides native data loading capabilities to facilitate the easy transfer of data into Actian Data Platform. Features include the desktop data loader for ad hoc data loading from a local computer and Actian Data Platform Integration for continuous data integration from disparate sources. All functionality is accessible via the Actian Data Platform Dashboard.

Intermediate Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Schema Design & Indexing

Data is held in Tables and tables are created within a users schema. In this course we describe how to create tables, partition tables, column data types and how to apply constraints.

Intermediate Self-Learning Learning Path Actian Data Platform Product Architect

Actian Data Platform Architect: Data Drivers and Connections

For the business to be able to leverage the power of an Actian Data Platform Warehouse and deep dive into the data contained within the Warehouse business users must be able to connect to it using their familiar analytical applications. In this course we provide all that you need to know to provide business users with the connectivity required, from maintaining the trusted list of IPs, user creation and connection string parameters.

Intermediate Self-Learning Learning Path Actian Data Platform Product Architect

Powering Next-Gen Networks and IoT Apps on the OpenNESS platform with Zen Database

Multi Access Edge Computing (MEC) brings modern cloud architecture and advanced networking capabilities to the edge resulting in convergence of IT, OT ( Operational Technologies) and CT (Communication Technologies – 4G,5G, CBRS, etc.) at the edge. In this session, you will hear from Intel on why data management is critical for MEC use cases and get an overview of how easy it is to use Actian Zen in containers with helm charts on the OpenNESS platform.

Edge to Cloud without ETL: Mobile and IoT Data Management with Actian Zen

Ten years ago, everyone was convinced that vast majority of data would come from the Edge and processed and analyzed in the Cloud. That thinking has changed 180 degrees. Join this session to see how Actian Zen can remove the security vulnerabilities of ETL in Edge data management and significantly improve your performance.

Actian Zen: A Single, Secure, Scalable Edge Data Management Platform

Mobile, IoT, and embedded branch/remote office applications are becoming more intelligent and increasingly require local data processing and analysis at the Edge to avoid latency, improve data sovereignty, security analysis, governance, and a host of other use cases – many supported by unsupervised ML. Join this session to hear from Desmond Tan about Zen, a single Edge Data Management platform that supports all the scenarios noted above and more.

5 Critical Requirements for Delivery of Breakthrough Cloud-Based Operational Analytics

Affordability, ease-of-use and, of course, performance are critical decision-making factors when deciding on a Cloud Data Analytics platform to support day-to-day, real-world operational analytics. In this session, Adam Luciano looks under the hood at what are the key requirements including separation of compute and storage, query result caching and workload management.

An Integrated Platform for Self-Service Data Ingestion, Enrichment and Post-Processing Visualization

Join this session to see Jason provide a walk-through of how Actian Avalanche can be used to pull disparate desktop Excel spreadsheets, data from an Enterprise Data Warehouse and data from a Web Service API into a unified dataset that can be queried in Avalanche and then visualized through Looker (as an example) – all from a single console, without coding or specialized training.

Better Together: A Foundational Overview of Avalanche on Google Cloud and How to Optimize for Real-World Performance

Actian Avalanche has been redesigned from the ground-up to take advantage of Google Cloud infrastructure including the Google Kubernetes Engine, Google Cloud Storage and Google’s advanced networking. Explore how moving from a static Hadoop based architecture to a flexible contrainerized deployment dramatically reduced deployment time and simplified maintenance. Further, how moving to using Cloud native storage unlocked the full potential of Avalanche scalability and performance in GCP.

Critical Questions for Non-IT Users to Consider When Moving Data Analytics to the Cloud

Join this panel for a discussion of typical concerns power users should have and how to bridge the gap between IT and the rest of us when it comes to moving data analytics to the Cloud

Extending Avalanche with UDF’s to Enable ML Model Management and Other Advanced Analytics Use Cases

User Defined Functions, or UDFs help extend built in functionality for SQL-based data analytics systems used by business analysts, engineers, and scientists. With Avalanche and Vector, these power users can further take advantage of UDF’s by deploying ML models into their database, enabling the models and associated data to be scored directly from within the database. Join this session to hear a discussion and simple examples of model management using an Iris Dataset and Logistic Regression.

Intro to Actian BaaS: Make Databases Available as MicroServices for Consumption in New and Migration of Legacy Services

These days, TypeScript, JavaScript, and Python take the lead in any popularity context for programming languages. And of course, everyone wants to write micro services to automatically deploy on Kubernetes. Join this session to hear how Actian thinks about Backend as a Service (BaaS) to solve this challenge.

AvalancheConnect: Data Hub Functionality Embedded into a Cloud Data Analytics Platform

SaaS applications and Cloud Data Analytics represent a major advancement for real-time decision-making capabilities and their use by organizations of all sizes. But the centerpieces for this revolution are missing a major requirement: accessibility for day-to-day operational analytics capabilities by non-IT users. Join this session to hear about Actian AvalancheConnect, a zero-code, self-service data-hub built into Avalanche.

The High Costs of Dirty Data – Why Data Profiling with DataConnect Version 12 Will Improve Your Business Outcomes

Most Enterprises are drowning in data; some of it would quench their thirst for the right business insights but trying to analyze all of it would be like boiling an ocean. It’s no surprise that Gartner estimates that poor data quality results in billions lost annually! Join this session to hear how DataConnect Version 12 provides powerful functionality to cleanse, enrich, and automate repeatable data pipeline operations.

Actian Data Intelligence Platform Customer Certification Training

This course provides foundational Actian Data Intelligence Platform knowledge and insights to help prepare you for the accompanying certification exam.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian Data Intelligence Platform Customer Certification Exam

Prove your expertise with Actian Data Intelligence Platform with the official certification exam designed for effective users of this technology. Successfully pass the certification exam and share your achievement on your LinkedIn profile.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian OpenROAD Server Fundamentals

Many customers employ OpenROAD Server as an easy to deploy, scalable and managable application server platform. Customers who have many years of mission critical business logic have been able to successfully and simply port their business logic to OpenROAD Server and service requests from a range of technology applications including browser based and B2B applications via JSON-RPC service requests. Take this course to develop your knowledge of this versatile application server platform.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product Expert brand_openroad OpenROAD Server Application Modernization

Your Strategic Data Analytics Opportunity

Lewis Black, CEO for Actian, presents Actian's strategic vision for Hybrid Data Analytics.

Google Cloud Platform Vision for Data Analytics

Lak Lakshmanan, Director for Data Analytics & AI Solutions, Google, describes why Google is a superior platform for Analytics and AI solutions

Avalanche – The Data Platform of the Future

Vikas Mathur, SVP, Strategy and Product Management, Actian, toplines the platform roadmap and strategic direction for the Actian Avalanche Cloud Data Warehouse Platform

Delivering on the Vision

Emma McGrattan, SVP, Actian Engineering describes the Actian product direction for 2021

Hybrid Data Conference Customer Panel

Actian's CMO, Jeff Veis hosts a discussion between three of Actian's key customers, Sabre, Finastra, and Goldstar Software

Modernizing Operational Analytics in the Cloud with the Avalanche Platform – Delivering Real-Time Performance at Scale

Emma McGrattan, SVP of Engineering at Actian, describes how Avalanche takes the best of enterprise data warehouse, data lake and data hub features and functionality with an eye to direct access and use by non-IT staff

HCL – Strategic Vision for A Hyper-Connected World

Kalyan Kumar, CTO & Head of Ecosystems, HCL Technologies, lays out HCL's view of what a hyper-connected world will mean for various industries and their digital transformations

OpenROAD WebGen 101

Need to extend business services to employees, partners, and customers on mobile and other edge environments without risk or undue porting pains? Join this session for a hands-on introduction with Don Criley, OpenROAD Architect, on using WebGen in OpenROAD 11.2. WebGen is a new tool that allows 4GL applications to be deployed to the web. With WebGen, 4GL developers can deploy web/mobile applications that extend existing business services to the Edge.

Actian X, Ingres & OpenROAD Roadmap

In this session Alex will provide a detailed review of the feature additions and enhancements planned for the new releases of Actian X, Ingres and OpenROAD that will take your applications to the next level. See how the synchronised 11.2 release schedule will allow you to modernise your applications, migrate to lower maintenance compute platforms, and improve security, collectively delivering unparalleled insights and an edge over the competition.

Application Modernization with ABF and OpenROAD, What’s New?

Planning to move your applications to a cloud environment but unsure of what it will take with OpenROAD to do this with the least risk and investment of time and resources? In this session Chris Clark, lead engineer for OpenROAD at Actian provides an overview of the options, process, tools, and new features in OpenROAD that make it easier to reuse ABF business logic in OpenROAD in both existing on-premises and the latest cloud environments.

Application Modernization with ABF and OpenROAD, Exploiting New Ideas and New Product Features

Harnessing the value in tried and tested, reliable business logic is a low risk, cost effective and incremental approach that can balance budgetary constraints and innovation goals simultaneously. In this session Nick Denning, CEO for Diegesis will explore the options facing organizations with millions of lines of ABF and OpenROAD code who wish to modernize their applications while “sweating the asset”.

Actian Data Intelligence Platform Data Explorer Training

This Actian Data Intelligence Platform training has been curated for the Data Explorer persona.

Self-Learning Certification brand_zeenea Data Intelligence Data Explorer

Actian Data Intelligence Platform Data Explorer Certification

This certification exam has been curated to provide you with the opportunity to prove that you have the specific knowledge pertaining to the Data Explorer persona in the context of Actian Data Intelligence Platform.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian OpenROAD Server Fundamentals Certification Exam

This certification exam has been curated to provide you with the opportunity to prove that your knowledge of Actian OpenROAD Server is up to the level it must to be in order for you to be an effective advocate and subject matter expert for the technology.

Self-Learning OpenROAD Product Certification brand_openroad OpenROAD Server

Actian Data Platform: Connectivity v2.0 (self-paced)

To harness the capabilities of an Actian Data Platform Warehouse and thoroughly explore the data it holds, business users must be able to connect to it through their familiar analytical applications. This course equips you with comprehensive knowledge on establishing connectivity for business users. This includes tasks such as managing a trusted list of IPs, creating user accounts, and configuring connection string parameters.

Actian Data Intelligence Platform Administrator Certification

This certification exam has been curated to provide you with the opportunity to prove that you have the specific knowledge pertaining to the Administrator persona in the context of Actian Data Intelligence Platform.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian Data Intelligence Platform Administrator Training

This Actin Data Intelligence Platform training has been curated for Administrator persona.

Administrator Self-Learning Certification brand_zeenea Data Intelligence

Implementing a Next Generation Real-Time Customer 360 Solution

Join this session to hear how you can leverage Actian’s Customer360 real-time analytics solutions to improve customer insights across silos, analyze, visualize and report on customer profiling, micro-segmentation, churn and market basket analysis, next best action and campaign optimization.

Implementing a Common Analytics Platform for Insurance Industry Use Cases

No matter what the insurance type – health or property and casualty, commercial or private – there are three areas that require real-time decision-making capabilities for core business operations: underwriting, fraud detection and prevention, and customer adoption and retention. Join this session to review sample Actian insurance customer case studies across these three areas and how Actian provides common analytics platform components for multiple use scenarios

Making the Journey to the Cloud at UK’s Favorite Auto Insurer, Automobile Association

Join this session to hear a conversation between AA’s Head of Underwriting, Paul Frith and Actian’s CRO, Marc Potter, as they discuss the AA’s journey to Cloud and how the AA has made the most of their small but agile organization and resources, leveraging Ingres, Vector, Data Flow, and now Avalanche

Actian Data Intelligence Platform Data Steward Training

This Actin Data Intelligence Platform training has been curated for the Data Steward persona.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian Data Intelligence Platform Data Steward Certification

This certification exam has been curated to provide you with the opportunity to prove that you have the specific knowledge pertaining to the Data Steward persona in the context of Actian Data Intelligence Platform.

Self-Learning Product Certification brand_zeenea Data Intelligence

Using Advanced Analytics to Improve Campaign Outcomes with HCL Unica

HCL Unica provides a comprehensive platform for omni-channel Precision Marketing @ Scale and is tapping into the power and performance Actian’s Vector Analytics database to delivering insights using machine learning. In this session you will learn how HCL Unica and Actian Vector as the data analytics engine provides advanced analytics capabilities within the Unica platform.

Actian Vector + Google Marketing Platform + Tensorflow = A Marketing Technology Hero

Are you a technologist trying to help your marketing and e-commerce teams or on the business side trying to understand the technology? In this session, you’ll learn how combining google marketing data and 1st party transactional data into a Vector database will accelerate your marketing intelligence

Actian Data Platform for Data Scientists: Deploying Machine Learning Models

This training provided via this course provides you with an introduction to User Defined Functions (UDF) for deploying your Machine Learning Models into a Platform Warehouse production environment.

Intermediate Business User Self-Learning Learning Path Actian Data Platform Google Cloud Platform Data Science Data Scientist

Actian Data Platform for Data Scientists: Data Preparation

The training provided within this course provides you with knowledge for the various native Platform capabilities to ingest, clean and transform data and access it all in a single data platform.

Intermediate Business User Self-Learning Learning Path Actian Data Platform Google Cloud Platform Data Science Data Scientist

Actian Data Platform for Data Scientists: Monitoring

This course provides you with the knowledge on Actian Data Platform data drivers, connection parameters and making use of the Platform Query Editor

Intermediate Business User Self-Learning Learning Path Actian Data Platform Google Cloud Platform Data Science Data Scientist

Actian Data Platform for Data Scientists: Building Machine Learning Models

The training provided within this course provides you with insight for the native Platform Warehouse data processing SQL functions, how to achieve feature encoding and how to create datasets for training and testing your Machine Learning Model using SQL.

Intermediate Beginner Self-Learning Learning Path Actian Data Platform Google Cloud Platform Data Science Data Scientist

Application Modernization - Part 2 - Source code and Form to Frame transitions for Vision Menu Forms

During this second part of the series you will be provided with guidance in relation to speed key definitions, ABF menu forms to interactive OpenROAD frames, creation of top level menus and how to connect events raised via the menu options into the existing ABF source code.

Developer Self-Learning Learning Path Advanced OpenROAD Operational Database Product

Application Modernization: Example OpenROAD applications

The OpenROAD applications which have been generated as a result of an ABF to OpenROAD Application to OpenROAD Server Application are provided here.

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Operational Database Product

Application Modernization - Part 6: Migrating embedded 'thick client' business logic to OpenROAD Server deployed 4GL Procedures

During this course we discuss and demonstrate strategies which you will need to consider employing when migrating embedded 'thick client' business logic into OpenROAD Server compliant 4GL Procedures.

Intermediate Developer Self-Learning Learning Path OpenROAD Operational Database Product

Application Modernization - Part 4 - Menus, Buttons and Tabbing Sequences

In this course we will provide you with guidance for adding menu bar options, form buttons, a discussion about tabbing sequences and a look at how 'Exit' events can be utilised to good effect.

Intermediate Developer Learning Path Advanced OpenROAD Operational Database Product

Application Modernization - Part 3 - Styling the migrated ABF Form using OpenROAD Features and Functionality

During this third part of the series you will be provided with guidance in relation to the use of composite fields, alignment attributes and margin attributes to structure and refine the migrated ABF Form user interface using OpenROAD features and functionality.

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Product

Application Modernization - Part 5 - ABF to OpenROAD Script Migration

In this course we will provide you with strategies to consider when migrating ABF script to be OpenROAD compliant script. Functionality around TableFields and Event handling in particular require attention. Using the strategies described here will assist in making this task easier.

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Operational Database

Application Modernization - Part 1 - The ABF to OpenROAD Migration

This is the first part in our series describing a supported and best practice process for migrating a complex ABF application to an OpenROAD application. During this course you will be provided with a review of the sample ABF application and guidance for implementing the ABF2OR migration tool

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Operational Database Product

Application Modernization: Example ABF application and supporting database

During this course we will provide you with information in relation to the example ABF application for which we have used throughout the Application Modernization Content.

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Operational Database

Actian Data Data Platform Architect: Overview

The course provides context and an overview for the Actian Data Platform

Intermediate Beginner Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Performance Optimization

Insight to improve query performance and discover how to use the inbuilt query execution plan to determine if a specific query is executing efficiently or not.

Intermediate Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Data Access Security

Data security is of utmost importance to organizations. The Actian Data Platform offers native data security for implementation in accordance with your company's needs. From the restricted access to table data, data masking and encryption of data at rest.

Intermediate Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Data Loading

Actian Data Platform offers functionality that is executed via the command line to facilitate loading data via batch process in addition to its rich browser-based native data ingestion functionality.

Intermediate Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Data Integration

Actian Data Platform provides native data loading capabilities to facilitate the easy transfer of data into Actian Data Platform. Features include the desktop data loader for ad hoc data loading from a local computer and Actian Data Platform Integration for continuous data integration from disparate sources. All functionality is accessible via the Actian Data Platform Dashboard.

Intermediate Self-Learning Learning Path Actian Data Platform Product Google Cloud Platform Architect

Actian Data Platform Architect: Schema Design & Indexing

Data is held in Tables and tables are created within a users schema. In this course we describe how to create tables, partition tables, column data types and how to apply constraints.

Intermediate Self-Learning Learning Path Actian Data Platform Product Architect

Actian Data Platform Architect: Data Drivers and Connections

For the business to be able to leverage the power of an Actian Data Platform Warehouse and deep dive into the data contained within the Warehouse business users must be able to connect to it using their familiar analytical applications. In this course we provide all that you need to know to provide business users with the connectivity required, from maintaining the trusted list of IPs, user creation and connection string parameters.

Intermediate Self-Learning Learning Path Actian Data Platform Product Architect

Powering Next-Gen Networks and IoT Apps on the OpenNESS platform with Zen Database

Multi Access Edge Computing (MEC) brings modern cloud architecture and advanced networking capabilities to the edge resulting in convergence of IT, OT ( Operational Technologies) and CT (Communication Technologies – 4G,5G, CBRS, etc.) at the edge. In this session, you will hear from Intel on why data management is critical for MEC use cases and get an overview of how easy it is to use Actian Zen in containers with helm charts on the OpenNESS platform.

Edge to Cloud without ETL: Mobile and IoT Data Management with Actian Zen

Ten years ago, everyone was convinced that vast majority of data would come from the Edge and processed and analyzed in the Cloud. That thinking has changed 180 degrees. Join this session to see how Actian Zen can remove the security vulnerabilities of ETL in Edge data management and significantly improve your performance.

Actian Zen: A Single, Secure, Scalable Edge Data Management Platform

Mobile, IoT, and embedded branch/remote office applications are becoming more intelligent and increasingly require local data processing and analysis at the Edge to avoid latency, improve data sovereignty, security analysis, governance, and a host of other use cases – many supported by unsupervised ML. Join this session to hear from Desmond Tan about Zen, a single Edge Data Management platform that supports all the scenarios noted above and more.

5 Critical Requirements for Delivery of Breakthrough Cloud-Based Operational Analytics

Affordability, ease-of-use and, of course, performance are critical decision-making factors when deciding on a Cloud Data Analytics platform to support day-to-day, real-world operational analytics. In this session, Adam Luciano looks under the hood at what are the key requirements including separation of compute and storage, query result caching and workload management.

An Integrated Platform for Self-Service Data Ingestion, Enrichment and Post-Processing Visualization

Join this session to see Jason provide a walk-through of how Actian Avalanche can be used to pull disparate desktop Excel spreadsheets, data from an Enterprise Data Warehouse and data from a Web Service API into a unified dataset that can be queried in Avalanche and then visualized through Looker (as an example) – all from a single console, without coding or specialized training.

Better Together: A Foundational Overview of Avalanche on Google Cloud and How to Optimize for Real-World Performance

Actian Avalanche has been redesigned from the ground-up to take advantage of Google Cloud infrastructure including the Google Kubernetes Engine, Google Cloud Storage and Google’s advanced networking. Explore how moving from a static Hadoop based architecture to a flexible contrainerized deployment dramatically reduced deployment time and simplified maintenance. Further, how moving to using Cloud native storage unlocked the full potential of Avalanche scalability and performance in GCP.

Critical Questions for Non-IT Users to Consider When Moving Data Analytics to the Cloud

Join this panel for a discussion of typical concerns power users should have and how to bridge the gap between IT and the rest of us when it comes to moving data analytics to the Cloud

Extending Avalanche with UDF’s to Enable ML Model Management and Other Advanced Analytics Use Cases

User Defined Functions, or UDFs help extend built in functionality for SQL-based data analytics systems used by business analysts, engineers, and scientists. With Avalanche and Vector, these power users can further take advantage of UDF’s by deploying ML models into their database, enabling the models and associated data to be scored directly from within the database. Join this session to hear a discussion and simple examples of model management using an Iris Dataset and Logistic Regression.

Intro to Actian BaaS: Make Databases Available as MicroServices for Consumption in New and Migration of Legacy Services

These days, TypeScript, JavaScript, and Python take the lead in any popularity context for programming languages. And of course, everyone wants to write micro services to automatically deploy on Kubernetes. Join this session to hear how Actian thinks about Backend as a Service (BaaS) to solve this challenge.

AvalancheConnect: Data Hub Functionality Embedded into a Cloud Data Analytics Platform

SaaS applications and Cloud Data Analytics represent a major advancement for real-time decision-making capabilities and their use by organizations of all sizes. But the centerpieces for this revolution are missing a major requirement: accessibility for day-to-day operational analytics capabilities by non-IT users. Join this session to hear about Actian AvalancheConnect, a zero-code, self-service data-hub built into Avalanche.

The High Costs of Dirty Data – Why Data Profiling with DataConnect Version 12 Will Improve Your Business Outcomes

Most Enterprises are drowning in data; some of it would quench their thirst for the right business insights but trying to analyze all of it would be like boiling an ocean. It’s no surprise that Gartner estimates that poor data quality results in billions lost annually! Join this session to hear how DataConnect Version 12 provides powerful functionality to cleanse, enrich, and automate repeatable data pipeline operations.

Actian Data Intelligence Platform Customer Certification Training

This course provides foundational Actian Data Intelligence Platform knowledge and insights to help prepare you for the accompanying certification exam.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian Data Intelligence Platform Customer Certification Exam

Prove your expertise with Actian Data Intelligence Platform with the official certification exam designed for effective users of this technology. Successfully pass the certification exam and share your achievement on your LinkedIn profile.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian OpenROAD Server Fundamentals

Many customers employ OpenROAD Server as an easy to deploy, scalable and managable application server platform. Customers who have many years of mission critical business logic have been able to successfully and simply port their business logic to OpenROAD Server and service requests from a range of technology applications including browser based and B2B applications via JSON-RPC service requests. Take this course to develop your knowledge of this versatile application server platform.

Intermediate Beginner Developer Administrator Self-Learning Actian Ingres Advanced OpenROAD Operational Database Product Expert brand_openroad OpenROAD Server Application Modernization

Your Strategic Data Analytics Opportunity

Lewis Black, CEO for Actian, presents Actian's strategic vision for Hybrid Data Analytics.

Google Cloud Platform Vision for Data Analytics

Lak Lakshmanan, Director for Data Analytics & AI Solutions, Google, describes why Google is a superior platform for Analytics and AI solutions

Avalanche – The Data Platform of the Future

Vikas Mathur, SVP, Strategy and Product Management, Actian, toplines the platform roadmap and strategic direction for the Actian Avalanche Cloud Data Warehouse Platform

Delivering on the Vision

Emma McGrattan, SVP, Actian Engineering describes the Actian product direction for 2021

Hybrid Data Conference Customer Panel

Actian's CMO, Jeff Veis hosts a discussion between three of Actian's key customers, Sabre, Finastra, and Goldstar Software

Modernizing Operational Analytics in the Cloud with the Avalanche Platform – Delivering Real-Time Performance at Scale

Emma McGrattan, SVP of Engineering at Actian, describes how Avalanche takes the best of enterprise data warehouse, data lake and data hub features and functionality with an eye to direct access and use by non-IT staff

HCL – Strategic Vision for A Hyper-Connected World

Kalyan Kumar, CTO & Head of Ecosystems, HCL Technologies, lays out HCL's view of what a hyper-connected world will mean for various industries and their digital transformations

OpenROAD WebGen 101

Need to extend business services to employees, partners, and customers on mobile and other edge environments without risk or undue porting pains? Join this session for a hands-on introduction with Don Criley, OpenROAD Architect, on using WebGen in OpenROAD 11.2. WebGen is a new tool that allows 4GL applications to be deployed to the web. With WebGen, 4GL developers can deploy web/mobile applications that extend existing business services to the Edge.

Actian X, Ingres & OpenROAD Roadmap

In this session Alex will provide a detailed review of the feature additions and enhancements planned for the new releases of Actian X, Ingres and OpenROAD that will take your applications to the next level. See how the synchronised 11.2 release schedule will allow you to modernise your applications, migrate to lower maintenance compute platforms, and improve security, collectively delivering unparalleled insights and an edge over the competition.

Application Modernization with ABF and OpenROAD, What’s New?

Planning to move your applications to a cloud environment but unsure of what it will take with OpenROAD to do this with the least risk and investment of time and resources? In this session Chris Clark, lead engineer for OpenROAD at Actian provides an overview of the options, process, tools, and new features in OpenROAD that make it easier to reuse ABF business logic in OpenROAD in both existing on-premises and the latest cloud environments.

Application Modernization with ABF and OpenROAD, Exploiting New Ideas and New Product Features

Harnessing the value in tried and tested, reliable business logic is a low risk, cost effective and incremental approach that can balance budgetary constraints and innovation goals simultaneously. In this session Nick Denning, CEO for Diegesis will explore the options facing organizations with millions of lines of ABF and OpenROAD code who wish to modernize their applications while “sweating the asset”.

Actian Data Intelligence Platform Data Explorer Training

This Actian Data Intelligence Platform training has been curated for the Data Explorer persona.

Self-Learning Certification brand_zeenea Data Intelligence Data Explorer

Actian Data Intelligence Platform Data Explorer Certification

This certification exam has been curated to provide you with the opportunity to prove that you have the specific knowledge pertaining to the Data Explorer persona in the context of Actian Data Intelligence Platform.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian OpenROAD Server Fundamentals Certification Exam

This certification exam has been curated to provide you with the opportunity to prove that your knowledge of Actian OpenROAD Server is up to the level it must to be in order for you to be an effective advocate and subject matter expert for the technology.

Self-Learning OpenROAD Product Certification brand_openroad OpenROAD Server

Actian Data Platform: Connectivity v2.0 (self-paced)

To harness the capabilities of an Actian Data Platform Warehouse and thoroughly explore the data it holds, business users must be able to connect to it through their familiar analytical applications. This course equips you with comprehensive knowledge on establishing connectivity for business users. This includes tasks such as managing a trusted list of IPs, creating user accounts, and configuring connection string parameters.

Actian Data Intelligence Platform Administrator Certification

This certification exam has been curated to provide you with the opportunity to prove that you have the specific knowledge pertaining to the Administrator persona in the context of Actian Data Intelligence Platform.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian Data Intelligence Platform Administrator Training

This Actin Data Intelligence Platform training has been curated for Administrator persona.

Administrator Self-Learning Certification brand_zeenea Data Intelligence

Implementing a Next Generation Real-Time Customer 360 Solution

Join this session to hear how you can leverage Actian’s Customer360 real-time analytics solutions to improve customer insights across silos, analyze, visualize and report on customer profiling, micro-segmentation, churn and market basket analysis, next best action and campaign optimization.

Implementing a Common Analytics Platform for Insurance Industry Use Cases

No matter what the insurance type – health or property and casualty, commercial or private – there are three areas that require real-time decision-making capabilities for core business operations: underwriting, fraud detection and prevention, and customer adoption and retention. Join this session to review sample Actian insurance customer case studies across these three areas and how Actian provides common analytics platform components for multiple use scenarios

Making the Journey to the Cloud at UK’s Favorite Auto Insurer, Automobile Association

Join this session to hear a conversation between AA’s Head of Underwriting, Paul Frith and Actian’s CRO, Marc Potter, as they discuss the AA’s journey to Cloud and how the AA has made the most of their small but agile organization and resources, leveraging Ingres, Vector, Data Flow, and now Avalanche

Actian Data Intelligence Platform Data Steward Training

This Actin Data Intelligence Platform training has been curated for the Data Steward persona.

Self-Learning Product Certification brand_zeenea Data Intelligence

Actian Data Intelligence Platform Data Steward Certification

This certification exam has been curated to provide you with the opportunity to prove that you have the specific knowledge pertaining to the Data Steward persona in the context of Actian Data Intelligence Platform.

Self-Learning Product Certification brand_zeenea Data Intelligence

Using Advanced Analytics to Improve Campaign Outcomes with HCL Unica

HCL Unica provides a comprehensive platform for omni-channel Precision Marketing @ Scale and is tapping into the power and performance Actian’s Vector Analytics database to delivering insights using machine learning. In this session you will learn how HCL Unica and Actian Vector as the data analytics engine provides advanced analytics capabilities within the Unica platform.

Actian Vector + Google Marketing Platform + Tensorflow = A Marketing Technology Hero

Are you a technologist trying to help your marketing and e-commerce teams or on the business side trying to understand the technology? In this session, you’ll learn how combining google marketing data and 1st party transactional data into a Vector database will accelerate your marketing intelligence

Actian Data Platform for Data Scientists: Deploying Machine Learning Models

This training provided via this course provides you with an introduction to User Defined Functions (UDF) for deploying your Machine Learning Models into a Platform Warehouse production environment.

Intermediate Business User Self-Learning Learning Path Actian Data Platform Google Cloud Platform Data Science Data Scientist

Actian Data Platform for Data Scientists: Data Preparation

The training provided within this course provides you with knowledge for the various native Platform capabilities to ingest, clean and transform data and access it all in a single data platform.

Intermediate Business User Self-Learning Learning Path Actian Data Platform Google Cloud Platform Data Science Data Scientist

Actian Data Platform for Data Scientists: Monitoring

This course provides you with the knowledge on Actian Data Platform data drivers, connection parameters and making use of the Platform Query Editor

Intermediate Business User Self-Learning Learning Path Actian Data Platform Google Cloud Platform Data Science Data Scientist

Actian Data Platform for Data Scientists: Building Machine Learning Models

The training provided within this course provides you with insight for the native Platform Warehouse data processing SQL functions, how to achieve feature encoding and how to create datasets for training and testing your Machine Learning Model using SQL.

Intermediate Beginner Self-Learning Learning Path Actian Data Platform Google Cloud Platform Data Science Data Scientist

Application Modernization - Part 2 - Source code and Form to Frame transitions for Vision Menu Forms

During this second part of the series you will be provided with guidance in relation to speed key definitions, ABF menu forms to interactive OpenROAD frames, creation of top level menus and how to connect events raised via the menu options into the existing ABF source code.

Developer Self-Learning Learning Path Advanced OpenROAD Operational Database Product

Application Modernization: Example OpenROAD applications

The OpenROAD applications which have been generated as a result of an ABF to OpenROAD Application to OpenROAD Server Application are provided here.

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Operational Database Product

Application Modernization - Part 6: Migrating embedded 'thick client' business logic to OpenROAD Server deployed 4GL Procedures

During this course we discuss and demonstrate strategies which you will need to consider employing when migrating embedded 'thick client' business logic into OpenROAD Server compliant 4GL Procedures.

Intermediate Developer Self-Learning Learning Path OpenROAD Operational Database Product

Application Modernization - Part 4 - Menus, Buttons and Tabbing Sequences

In this course we will provide you with guidance for adding menu bar options, form buttons, a discussion about tabbing sequences and a look at how 'Exit' events can be utilised to good effect.

Intermediate Developer Learning Path Advanced OpenROAD Operational Database Product

Application Modernization - Part 3 - Styling the migrated ABF Form using OpenROAD Features and Functionality

During this third part of the series you will be provided with guidance in relation to the use of composite fields, alignment attributes and margin attributes to structure and refine the migrated ABF Form user interface using OpenROAD features and functionality.

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Product

Application Modernization - Part 5 - ABF to OpenROAD Script Migration

In this course we will provide you with strategies to consider when migrating ABF script to be OpenROAD compliant script. Functionality around TableFields and Event handling in particular require attention. Using the strategies described here will assist in making this task easier.

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Operational Database

Application Modernization - Part 1 - The ABF to OpenROAD Migration

This is the first part in our series describing a supported and best practice process for migrating a complex ABF application to an OpenROAD application. During this course you will be provided with a review of the sample ABF application and guidance for implementing the ABF2OR migration tool

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Operational Database Product

Application Modernization: Example ABF application and supporting database

During this course we will provide you with information in relation to the example ABF application for which we have used throughout the Application Modernization Content.

Intermediate Developer Self-Learning Learning Path Advanced OpenROAD Operational Database