Web Interface

Combine the power of SEQUEL and the SEQUEL Web Interface to develop comprehensive, browser-based business intelligence systems. Start with simple queries and 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.

 

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. Each user’s access to SEQUEL objects and files is validated against their 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. 

• Drill down from high-level summary information to detailed data.
• Include graphical images within query results in your SEQUEL views.
• Run SEQUEL views and reports interactively and e-mail results to recipients.
• Run interactive SEQUEL views using XML and XSL (SEQUEL lets you convert System i data into XML).
• Control access to different subsets of data, such as data for a particular sales region, using record-level security. You can provide the latest information over the Web to a remote sales force, or customer, knowing that they see only the data they’re supposed to see.
• Control user privileges to data records in a System i physical file using the operating system, record-level security, and the SEQUEL UPDATE, DELETE, or INSERT commands.
• Manage spooled files by user profile or by output queue. The SEQUEL Web Interface lets you display, copy, move, delete, hold, or release spooled files, such as reports or job logs, by output queue or user profile.