IBM i > ADMINISTRATOR > SYSTEMS MANAGEMENT

Going Mobile With DB2 Web Query

DB2 Web Query

If you have the Express edition, you won't have the ability to use the report scheduler, so skip that step and go to your mobile device, download the Mobile Faves app and configure it to access Web Query over the Internet.

This is a simple matter of setting your device to point to the IP address and port. Of course if VPN access is used, this must be addressed in your mobile device settings (and once complete, it likely won't impact Web Query).

With either the Express or Standard edition, users can open Mobile Faves and see the configured company server as an entry. Selecting it allows any report that was previously dragged into the Mobile Favorite folder on their on the corporate portal page to be viewed/run (see figure 3). This is important: Mobile app users will only see reports placed in this folder! Realize this type of viewing is via a connected session. If Wi-Fi or cellular connections aren't available, the app issues a "Check your connection to the Internet" warning and displays the IBM i server as "not available" (N/A). When a connection is made, and the user/password is saved, the app connects when the user touches the line for the company server. Then it displays the user's available folders and reports. As each report is touched, the reports are expanded and run in the app with data retrieved from the IBM i system (see figure 4).

Standard Edition offers another way to get reports to users. This option steps things up, adding the capability for disconnected operation. With access to the report scheduler (which you or someone else may have configured as you installed Web Query), you can establish an event to email a report to a user. This is referred to as the Email channel (see figure 5). In this case, the report recipient need not be connected to the IBM i server; the report arrives via email (a normal email connection is obviously required for this), and the user can open the report in a disconnected state thereafter as needed. This is particularly valuable for dedicated road warriors who spend so much time in a disconnected status, perhaps in planes, trains and automobiles.

When Mobile app users receive email containing a report from Web Query, they select the attachment and view options to open it. One option is the Mobile Faves app. All emailed reports are displayed in the app, under the Email channel, until the user removes them.

Regardless of how the user accesses the report, whether by selecting in Mobile Faves or clicking an email attachment, the resulting view is pretty much the same, as illustrated in figure 4.

Report Scheduling and More

Configuring report scheduling is fairly straightforward. First, enter your email server into Web Query, including any necessary user ID or password for that server. This is a one-time administrator function. Whether your email server is on Power Systems or another platform, Web Query can manage it.

Subsequent report scheduling is also simple. Any users with scheduling responsibilities can establish a schedule for reports (see figure 6). From the Web Query portal, just right-click the report and select the Schedule option. This prompts for choices about delivery methods to distribute the report. For email, you have the flexibility for single recipient address or a pre-created distribution list. You must also specify if this is a one-time email or establish a schedule for future timed-basis delivery (with granularity of dates and times). Report distribution and scheduling is actually a detailed topic that honestly merits a future article. For now I'll simply say that if your manager wants a report available on her iPad each Monday at 9 a.m., Web Query scheduling can handle this with ease.

Whether the report is in a top-level or underlying folder, the schedule object, when saved, will appear in the portal as a named entry. I usually leave the name default the same as the report, which causes them to listed adjacently in the portal, though I've also seen installations where all schedules are stored in a separate folder. 

What about mobile access via just a browser, or via just email? How about stakeholders who don't have access to your system? With Web Query Standard Edition, corporate stakeholders who aren't employees, such as vendors or customers, can receive reports using the email capabilities of Web Query. For various reports, such as those using PDF, HTML or Active report types, you can just schedule the report to run and specify the email address/group. Recipients don't need a Web Query license or the Mobile Faves app to view what they've received; they simply open the report attachment in their default browser. To obtain a list of supported browsers from IBM at any time, read the HotFix letter for your Web Query version.

When consumers view Active reports, they can manipulate the enclosed data with sort, filter, chart and rollup options, provided as the report author grants these functions for the specific report. Each Active report includes an options list, completed at report creation time, which allows the creator to determine which functions are available to users. This is accomplished by using a number of checkboxes to select roles or customization options. A report creator might decide that the monthly sales report should expire 30 days from date of issue (see figure 7), that it needs to be password-protected, or that the consumer should not be allowed to export report data to Excel. If you have any of these requirements, you'll find the granularity to set these execution options quite handy.

Other possible mobile approaches include using the scheduling function in Standard Edition to post report information to a location where consumers can access it on-demand. Output of reports or charts to file types such as PDF or PNG might make it easy to build a site that receives auto-updates from Web Query. The scheduler enables downloading of reports from Web Query to other locations, such as a website without a working link to Web Query. In that scenario, you might "push" content on a timed schedule from Web Query to a file server directory via FTP. The target directory―for example, a directory in your IBM i Integrated File System (IFS)―could then utilize a web server to allow authorized users to view metrics, charts and reports, or to print or download content.

These are just some of the possibilities that emerge when you "go mobile" with DB2 Web Query for i.

Rick Flagler is an information technology consultant, teacher and mentor.



Like what you just read? To receive technical tips and articles directly in your inbox twice per month, sign up for the EXTRA e-newsletter here.



Advertisement

Advertisement

2017 Solutions Edition

A Comprehensive Online Buyer's Guide to Solutions, Services and Education.

IBM i > ADMINISTRATOR > SYSTEMS MANAGEMENT

Going Mobile With DB2 Web Query

Directing i

How to enable IBM i for management by IBM Systems Director

Putting the "V" in Virtualization

IBM eServer line delivers on the promise of virtualization

IBM Systems Magazine Subscribe Box Read Now Link Subscribe Now Link iPad App Google Play Store
IBMi News Sign Up Today! Past News Letters