Video Demos
SEQUEL is a simple, powerful data access, analysis, and presentation tool for IBM Power Systems running IBM i. This video is a visual overview that answers the question, “What is SEQUEL?”
This video shows how easy it is to create a new view using the SEQUEL ViewPoint graphical user interface. Files, fields, and other view information are easy to select from pull-down lists. System i (iSeries, AS/400) data access has never been easier!
SEQUEL tables can automatically summarize data for regions, time periods, or any field in your database. Using tables, you can consolidate large volumes of data in seconds. In this video you’ll see how easy it is to create a table, work with table results, and save the table on the System i.
If you need to analyze data, this video shows you a number of approaches using sales data as an example. See how to look at sales:
- By month and region, graphing seasonal sales trends
- By region and item, e-mailing the results as an Excel spreadsheet
- By customer, showing what percent of total sales each customer represents and rank ordering customers by total sales
The Client Reporting Option allows you to format System i (iSeries, AS/400) reports using all the fonts and colors available on the PC printers at your site. Reports can also include pictures and other formatting options, such as shading, borders, and conditional highlighting.
Starting with a new table, this video demonstrates how you can add or remove column and row data and filter results as you go along. It also explains the power of pivots and of drill-down capabilities for accessing background (detail) data.
This video expands on Working with Client Table Results. It demonstrates how you can use the more powerful data analysis features of a Client Table such as: calculations, data markers, ranking, and percentages.
SEQUEL ViewPoint is the perfect way to deploy powerful data access capabilities to non-technical users. In this video you’ll see how easy it is to display, save, download, e mail, and print data using pre-defined views, tables, and reports.
In the SEQUEL ViewPoint for End Users – Explorer and Shortcuts video we demonstrated how to work with pre-defined views, tables, and reports using the ViewPoint Explorer and desktop shortcut icons. In this follow-up video, you’ll see how to accomplish these tasks using dashboards.
Discover how SEQUEL lets you drill up, down, or sideways from a view or graph to explore related data. And, there’s no need to build a data warehouse because SEQUEL works directly with database files.
Watch this video for a quick overview of SEQUEL Web Interface 10. You'll see its new Explorer interface in action, plus a quick tour of the many things you can do using SEQUEL objects and your Web browser.
We'll demonstrate how to display objects, create object lists, search using wildcard characters, regroup objects, edit and display results, create graphs (charts) and more.
Enjoy the show!
Watch this video and see how easy it is to use the Table wizard to create a Client Table. We'll also review the table designer layout and the results screen, and show you how to save your work when you're done.
SEQUEL’s Import function lets you convert your query objects to SEQUEL views and reports. This video shows how easy the process is and how you can leverage your existing queries into more advanced SEQUEL objects.
SEQUEL can extract information from a System i database, convert it to any number of different file formats, and e-mail the data to different recipients – all in a single automated process. Most importantly, it selects and sends unique information to each recipient, so they see only the data they're supposed to see. It's easy to set up e-mail distribution, and you can use it to forward i5/OS physical files (by FTP), spooled files, customized e-mail messages, and data converted to PC file formats.
Managers commonly use Microsoft Excel to prepare budgets and create other types of departmental databases for business analysis. This demonstration shows how you can use SEQUEL to automatically upload Excel files created by multiple departments to the System i, then compare the spreadsheet data with other System i database information. The example in this demonstration shows how to use SEQUEL to streamline the budget and financial analysis process.
SEQUEL simplifies access to J.D. Edwards (JDE) database information. SEQUEL automatically converts data and links field attribute information from JDE data dictionary files to transaction files to create a new view of the data, without changing the original dictionary database files. You can access the information using SEQUEL or another query program, a spreadsheet, or other third-party reporting tools. You see the information you need without the need to translate decimal positions or decipher cryptic field descriptions. This video shows how to make JDE data more accessible.
This video provides an overview of ABSTRACT functions in the traditional 5250 host interface.
This video provides an overview of ABSTRACT functions as seen in the graphical, Windows-based WebSphere Development Studio Client and System i Navigator interfaces.