IBM Database Expert Query for i (“Expert Query”)

Expert Query is a native IBM i reporting platform and is part of Expert Labs “IBM Database Expert” family of offerings. 

Create and manage reports with Architect

Deploy to Explorer

Users Run reports from Explorer

Schedule using your scheduler of choice

Export to many common formats 

For more information, please contact John Westcott

• Architect
• Explorer
• Explorer - Modules
• Team Members

Architect – Design and Build Studio

Create and manage reports using Architects easy to use browser interface featuring capabilities such as 

• Tabular and Pivot Report Layouts

• Column Selection

• Headers and Footers

• Styling (bold, underline, italic, font, color, …)

• Conditional Formatting

• Prompt Definitions (drop down, text box, …)

• Calculated Columns

• Create deployable exports for scheduling

• Distribute via email, to IFS Folder, and FTP

• AND MORE

• Back to top

Explorer – On Demand Reporting and Exporting

Run and export reports using Explorers easy to use browser interface featuring capabilities such as

• Filter Prompts

• In Report “Wildcard” Searching

• Column Sorting

• Hyperlink to Other Reports

• Export to Spreadsheet (xlsx), HTML, CSV, and JSON

• AND MORE

• Back to top

Explorer – Modules

SCM: Turning Compliance into Confidence

In today’s complex security landscape, compliance isn’t just a requirement, it’s a strategic advantage. SCM empowers organizations with a unified, enterprise-wide view of security compliance, transforming oversight into actionable intelligence. With powerful built-in tests, monitoring, and full customization to fit your unique applications, SCM delivers measurable results and supports Key Risk Indicators (KRIs) for proactive risk management.

Every insight is traceable to industry standards and company policies, ensuring confidence and accountability at every level. 

Note: An embedded version of Expert Orchestrate is included with SCM. Expert Orchestrate provides the collection and ETL services for the Data Mart. For needs beyond SCM, a full license of Expert Orchestrate is required. Please contact John Westcott for more information on license upgrades.

Note: SCM is the successor to Compliance Automation Reporting Tool (CART). All features and capabilities are available with SCM.

• Back to top

Team Members

• John Westcott, Senior Delivery Consultant, Team Lead, IBM i Database Expert Labs
• Terry Ford, Senior Delivery Consultant, IBM i Security Expert Labs
• Joe McClure, Delivery Consultant, IBM i Database Expert Labs
• Ron Bibby, Contracts and Opportunities

• Back to top