Using Cognos or Crystal Reports to Access Mainframe Data
Have you ever wished that your PC reporting tools could directly access mainframe data without the need for an extract and download? You can do this right now with UltraQuest Cloud Server and products like IBM Cognos and SAP Crystal Reports.
For example, let's look at doing this with Cognos. With UltraQuest Cloud Server, you can create a virtual view connecting to any data source NOMAD can access (VSAM, DB2, IMS, NOMAD etc.). After you tell Cognos about this view, NOMAD segments and items are automatically mapped as tables and columns in Cognos. Even hierarchical paths are mapped as single tables. And as the mapping is dynamic, any changes to the NOMAD schema are immediately reflected by refreshing the view in Cognos.
With UltraQuest Cloud Server, the Cognos user’s view of the data is always current and there is no need for manual maintenance of external file mappings.
Test your knowledge or learn something new
Suppose you have a master which has sales information (PRODUCT and AMOUNT) as well as information about the person who made the sale (SALESMAN, REGION, and the salesman's PET). You want a report of the highest sales in each region, which includes the product that was sold, the salesman who sold it, and, of course, his pet ☺. What keyword would you use to include the additional information associated with the highest sales?
The database description is:
master SALES ;
item PRODUCT as a15 ;
item AMOUNT as $999,999,999.99 ;
item SALESMAN as name'16' ;
item PET as a8 ;
item REGION as a8 ;
The database contains the following data:
SALESMAN PET REGION PRODUCT AMOUNT
---------------- -------- -------- --------------- ---------------
FRED FLINTSTONE DINO BEDROCK DINO BURGERS $4.99
DINO FRIES $2.99
DINO MILKSHAKE $1.99
RICHARD NIXON CHECKERS US CHINA $700,000,000.00
WATERGATE HOTEL $2,000,000.00
TIMMY MARTIN LASSIE US LEMONADE $0.50
The report should look like this:
REGION AMOUNT PRODUCT SALESMAN PET
-------- --------------- --------------- ---------------- --------
BEDROCK $4.99 DINO BURGERS FRED FLINTSTONE DINO
US $700,000,000.00 CHINA RICHARD NIXON CHECKERS
Take a Peek at UltraQuest Reporter 6.0
video gives a short overview of UltraQuest Reporter 6.0.
If you've never seen Reporter before, this is a great way to
see what it can do for you! Click
here to watch now.
Sign up now to see a deep dive video of UltraQuest 6.0
See our "Peek at Reporter 6.0" plus how to do an
extract, joins, job scheduling, the browser-based
UltraQuest library for reports and dashboards, and a
sample UltraQuest web application. For more information,
please contact Sales at
Check Us Out On
We would love for you to connect with us by clicking on any of
the social network links.
Click here to check out and see our postings on our Social
Did you know???
Select Business Solutions has a team of consultants that can help
you with anything from NOMAD/UltraQuest application support,
configuration, efficiency improvements to z/VM and z/OS systems
programming, installs, and IT configuration/tuning.
If you want to know more, please email
or call 203-383-4600 ext 2.
Select Business Solutions has always based product development
and enhancements on the feedback we get from our customers.
Features like the interfaces to Oracle and SQL Server
and the UltraQuest Scheduler were based directly on requests from
our customer base. We pride ourselves on being responsive
to our customers’ needs and the changing IT environment, and we
want to hear from you. If there is a product feature you
would like to see added, or if you have any suggestions on how to
make our products better, please email them to us at
NOMAD/UltraQuest Puzzler Answer
Question: How do you include additional information associated with a report function?
Answer: Use the WITH keyword. As noted in Chapter 4 of the UltraQuest and NOMAD Reference Manual, “The WITH parameter displays additional items that are associated with the results of the previous report function.” The request that produced the report shown earlier is:
list by REGION max(AMOUNT)
with (PRODUCT, SALESMAN, PET)
— or —
list by REGION max(AMOUNT)
with PRODUCT with SALESMAN with PET
Note to UltraQuest users: The WITH feature is not currently directly available in Reporter, but can be used by inserting a code fragment containing the word WITH before each column to be included. If you want it included in the product, let us know!
3 Corporate Drive, Suite 216
Shelton, CT 06484
US Phone: 1.888.472.7347
UK Phone: 44.20.3642.0532
Outside US & UK: 1.203.383.4600
If you do not wish to receive future emails from