Building a Great Business Analytics Solution for IBM i
Power Systems customers using IBM i want an effective business analytics solution that is affordable and runs on their platform. Everything that you need is available today running under IBM i !!

Coglin Mill’s RODIN provides world class Extract, Transform and Load (ETL) functionality using existing DB2 databases. And Help/Systems SEQUEL was created to be an easy to use, high function, graphical front end tool that is optimized for DB2 on IBM i. Couple these two products together and you get the best of all worlds – a full function Business Analytics solution that runs on your IBM POWER System under IBM i.

Join us to see how these two great products can be used together to create the solution that every IBM customer has been looking for.
Help System's Doug Fulmer and Heath Kath, Coglin Mill's Alan Jordan

Watch the Webinar Recording

Download the Presentation

Fast Track to Successful Data Warehousing using RODIN
This session will demonstrate the extensive capabilities of RODIN and show how it's many automated features including  data quality & error management, auditing and metadata support dramatically simplify the development and maintenance of data warehouse and data mart environments. See first hand how RODIN's highly productive IDE and powerful ETL capabilities can reduce development time and simplify ongoing management of a  data warehouse.  Coglin Mill's Alan Jordan

Watch the Webinar Recording

Download the Presentation

Data Warehousing and Business Intelligence on IBM i
If you are planning to bring Business Intelligence to your organization, or are struggling to realize any real benefit from the front end tool you already have, you will find this session extremely useful. Alan will discuss the issues that virtually all organizations struggle with, and highlight the pitfalls and best practices that you need to be aware of in order to be successful, especially the need for a data warehouse or data marts as the foundation for that success. Coglin Mill's Alan Jordan

Watch the Webinar Recording

Download the Presentation

What's New in DB2 Web Query?
The 1.1.2 version of DB2 Web Query was released earlier this year and included many improvements to the product. Join this session to learn about these exciting enhancements. You will see InfoAssist, the sleek new development tool, learn about the many improvements made to improve report performance, and hear about the plentiful other goodies packed in this major release upgrade. IBM's Gene Cobb

Watch the Webinar Recording

Download the Presentation

We will look at how to find out what is really happening under the covers when you run a report. This session contains many tips based on new functions available in the latest release of DB2 Web Query including tips for using InfoAssist, working with metadata, keys to performance, and more. IBI's Jackie Jansen

Watch the Webinar Recording

Download the Presentation
 

Take Your SQL to the Next Level

SQL SELECT statements are a very powerful feature for accessing the business data in your DB2 for i databases. Some may think that nesting multiple SELECT statements within an SQL as insanity. In actuality, nesting SELECT statements can improve the efficiency of your applications. In this session, you will learn how to leverage Views, Subqueries, Common Table Expressions, Derived Tables, and other advanced SQL features to boost to your productivity and performance. IBM's Kent Milligan

Watch the Webinar Recording

Download the Presentation

Accessing SQL Functions using Rational Open Access: RPG Edition
In this session you will learn how to create program handlers that will “bridge” existing applications to SQL based services without the need to rewrite these applications in SQL. All it takes is one line of code to begin using the advanced capabilities provided by embedded SQL. The webinar will cover what you need to know to begin creating program handlers that can transform traditional IO to SQL functions. IBM's Dan Cruikshank

Watch the Webinar Recording

Download the Presentation

DB2 for i Code Examples