Self-Service Resources

Search Self Service Resources

In order to simplify your life and give you a centralized hub for HelpSystems product resources, we’re in the process of moving self-service content into our new HelpSystems Community portal.

If you’re looking for Automate, Skybot (recently rebranded as Automate Schedule), Intermapper, or Document Management (RJS) support resources in particular, you will now find everything you need in the new Community Knowledge Base. Thanks for your patience during this transition—we think you’ll really like your new community. Visit the portal >

Showing 1 - 21 of 154
Content Types: How To Guide, How To Video, Product Manual X Product Lines: Sequel X
How To Guide
June 16th, 2016

SEQUEL Data Warehouse has support for certain big data sources.

SEQUEL Data Warehouse can load data from both Apache Hive and Cloudera Impala 'no-SQL' databases, and we plan for further support in the future. The big data ecosystem is...

The simple answer is yes. When using SEQUEL Data Warehouse CDC and ETL components together, you can achieve (near) real-time load of your data warehouse.

However, in many cases this may not be sensible to do. The limitations on real-time...

Depending on the specific requirements, the answer is a qualified Yes.

SEQUEL Data Warehouse is a native IBM i software product and does not itself run on Windows, Linux, /Unix or Mainframe servers. The primary tables built and managed by...

Absolutely!

It is rare, in today's mixed business environments, to only need to pull data from IBM i tables. You may need to integrate data from Microsoft SQL Server, Oracle, MySql or other databases - or maybe DB2 from a mainframe or...

How To Guide
June 16th, 2016

SEQUEL ViewPoint includes a scripting module that lets you run multiple SEQUEL and system commands together. Scripting gives you much of the capability of Command Language (CL) programming without requiring technical programming knowledge. The...

How To Guide
August 25th, 2016
Introduction

Sequel has been integrated with the Google® Mapping API to support interactive map plotting based on address, zip code, or latitude/longitude coordinates stored in System i (or other) database files. Sequel can select virtually any...

When building and managing a data warehouse and associated ETL with SEQUEL Data Warehouse (powered by RODIN), you are building a software application that may be very extensive with hundreds if not thousands of objects. As such change control is...

How To Guide
June 16th, 2016
To answer this question, we first need to ask "Why use an ETL Tool to build my data warehouse?"

The answer to this question is quite simple: It will save you time and money!

Many data warehouse projects have failed because the project...

How To Guide
August 11th, 2016
Background

Using ESNDMAIL and ESNDFILE to e-mail a spooled file in PDF format, or using CPYSPLIFS to convert and save a spooled file as PDF on the IFS sometimes causes the PDF output to truncate if

*LETTER page size is specified....

How To Guide
June 16th, 2016

This Quick-Start guide will assist you with the configuration of the necessary items required to success- fully email from the System i. This guide will be helpful for most users. However, some systems have configuration issues beyond the scope...

How To Guide
November 3rd, 2016

Data Warehouses are always evolving and growing to meet the needs of your organization. New tables will be added on a regular basis, and you will need to modify existing tables too. New columns may be required and the attributes of existing...

We are confident the answer is yes.

Every organization has a unique set of ETL requirements. Over the last decade and more we've seen them all, and continually added functionality to SEQUEL Data Warehouse to support everything we've come across....

No. SEQUEL Data Warehouse is a tool that is designed to build and manage data warehouse tables, and the ETL processes that will load these tables. As such SEQUEL Data Warehouse users are developers in every sense of the word, however it is not...

When building and managing a data warehouse and associated ETL with SEQUEL Data Warehouse, you are building a software application that may be very extensive with hundreds if not thousands of objects. As such change control is imperative. SEQUEL...

In addition to query and reporting tasks, SEQUEL is an extremely useful tool for managing the data in your System i databases. SEQUEL's UPDATE, DELETE and INSERT commands are use- ful for cleansing bad data or applying mass changes to files...

How To Guide
August 11th, 2016

The Active Viewpoint Job Monitor provides access to your ViewPoint job’s connection status and some basic connection statistics. It also provides an easy way to end a ViewPoint session on the host without shutting down the client software. After...

How To Guide
August 24th, 2016

Secure Socket Layer (SSL) is a security protocol that enables Web sites to pass sensitive information securely in an encrypted format. If you have noticed a URL in your browser that starts with “https://”; this tells you the Web page is using SSL...

Introduction

The purpose of this document is to help the reader understand the size and scope of the effort required to set up a single sign on environment, and provide references to authoritative source documents—information that is freely...

How To Guide
August 17th, 2016
Subqueries Explained

A subquery is a query within a query—a SELECT statement nested within a SELECT statement. Using subqueries is an effective way to compare values from one file against values in another file. The subquery is placed in the...

Sequel commands for submitting jobs, such as BCHEXECUTE, BCHREPORT, and so on, do not provide a way to specify a job description in order to control the library list of the submitted job.

This is not a new problem as Sequel has always...

How To Guide
August 11th, 2016
Before You Begin

Sequel Web Interface (SWI) is shipped with at least three HTML documents—WELCOME, HEADER and FOOTER (others may be included)—saved as source members in the SWIHTML file located in the SEQUELWI library (or...