Web Interface

SEQUEL Web Interface

The SEQUEL Web Interface provides fast, secure Web access to your System i data. When you install the SEQUEL Web Interface, you can import and display your existing SEQUEL views or other queries directly from your browser. The SEQUEL Web Interface also allows you to manage your spooled file output over the Web.

Combine the power of SEQUEL and the SEQUEL Web Interface to develop comprehensive, browser-based business intelligence systems. Start with simple queries, then add run-time prompts, drill-down hyperlinks, and graphics. You can even reformat your DB2 data as Extensible Markup Language (XML) and Extensible Stylesheet Language (XSL) output to incorporate advanced formatting in your results. When you combine the SEQUEL Web Interface with SEQUEL or ESEND, you can distribute spooled files by e-mail directly from your browser.

You can license the SEQUEL Web Interface at one low price for all System i models. It’s a great way to provide better end-user access to information at any location without the time and money costs associated with other solutions.

See also: Security

Summary of Features / Examples

Use the following links to see types of results you will see with the SEQUEL Web Interface. (Note: All are static screen shots.)

1. See an example of a SEQUEL View, Report or Query/400
2. Drill down from high-level summary information to detailed data.
   
   

   Click to view examples: Region Summary, Customer Summary, Order Summary, and Line Items.

3. SEQUEL views can include graphical images within query results.
   

   Click to view examples: Customer Inquiry - with sample pictures, Display Photo Images from Catalog

4. You can run SEQUEL views and reports interactively and e-mail results to recipients.

    

5. SEQUEL lets you convert System i or AS/400 data into XML. Use the SWI to run interactive SEQUEL views using XML/XSL
   

   Click to view example: Customer Totals for California
   (Internet Explorer 5.0 or later is required in order to view XML content.)

6. Record level security allows you to control who has access to different subsets of data. This lets you provide the latest information over the Web to a remote sales force or customer with assurances that they see only what they're supposed to see.

   Click to view example: Record Level Security

7. You may sort results at the browser using dynamic data binding. You can include this function with results containing hyperlinks that drill-down to other views.

   Click to view example: Customer Summary - Region 010

8. UPDATE, DELETE, or INSERT records in a physical file on the System i or AS/400. Using i5/OS and / or record level security (above) you can limit who has access to different subsets of data. This example shows updating records in a file.

   Click to view example: Update Example

9. Display a list of existing SEQUEL and QRY objects within a library. The SEQUEL Web Interface builds the list dynamically.
   

   Click to view example: Work with SEQUEL Objects

10. Manage spooled files by user profile or by output queue.

    The SWI lets you display, copy, move, delete, hold or release spooled files such as reports or job logs within a selected output queue or user profile.

    When you combine the SEQUEL Web Interface with ESEND, you have the added ability to convert spooled files to PDF (or other popular formats) and send them to individual e-mail recipients or to burst and distribute them to multiple recipients in an e-mail distribution list.

    Click to view example: List Spooled Files.

    The table below shows what spooled file management functions are available when using the SEQUEL Web Interface as a standalone product or when it's combined with SEQUEL or ESEND.

    SEQUEL Web Interface
    Function	Standalone	With ESEND
    Display	X	X
    Copy	X	X
    Move	X	X
    Delete	X	X
    Hold / Release	X	X
    Display Attributes	X	X
    E-Mail		X
    Burst & Distribute by E-mail		X
    Convert to PDF		X
    Copy to IFS		X

    
    
11. Display graph shortcut files (.vpt) created with SEQUEL ViewPoint. Access a list of available files and click to display.
    

    You can use frames to display multiple elements in a single page.

    

Security

The SEQUEL Web Interface offers several ways to secure access to views and data. You can configure the SEQUEL Web Interface to use i5/OS object-level security. Anyone trying to access SEQUEL views through the SEQUEL Web Interface must log on with a valid user ID and password. Access to SEQUEL objects and the files they use is validated against the user’s credentials.

You also can secure the SEQUEL Web Interface without requiring a valid user ID by securing the objects used by the HTTP server. The System i HTTP server uses both user profile and password security to limit access from the Internet or an intranet. Because the System i HTTP server is read-only, the SEQUEL Web Interface does not allow UPDATE or DELETE commands.

The result is fast, easy, secure, and cost-effective access to your System i data—with the SEQUEL Web Interface.

 

	Please send me my FREE SEQUEL Information Kit.
	Contact me to set up a FREE 30-day trial
What prompted you to visit our Web site today?	System i News Magazine Ad IBM Systems Magazine Ad Direct Mail from Help/Systems E-mail from Help/Systems Search engine Heard about you from a friend Used products at another company Other
How many System i systems do you manage?
First Name:
Last Name:
Job Title:
Company Name:
Street Address:
City:
State/Province:
Zip/Postal Code:
Country:
Phone:
Fax:
E-mail: