SQL2XL™ for GE Security's Picture Perfect™
Our best-selling product, SQL2XL, is access control reporting like you've never seen! Imagine data moving from Picture Perfect SQL reports into Microsoft Excel® at lightening speed with a single mouse click from your web browser.
Elegant simplicity. Export data from Picture Perfect™ directly into Microsoft Excel® in a single click using only your web browser!
SQL2XL enables you to use your favorite web browser to export data from any Picture Perfect PPSQL report directly into a MS Excel workbook on your PC! Simply select the SQL report from the pulldown list, fill in any required variables and click Execute. The report results are immediately displayed on your screen where you can page through the data or click the Excel button which pushes the Excel workbook to a window on your local PC. Deliver the power of ANSI SQL and the ease of Microsoft Excel to your desktop in seconds.
Scheduled e-mail allows you to receive monthly reports in Excel format automagically! Use the handy scheduling form to e-mail it to you or to a list of users on a recurring basis. Excel worksheets can be automatically protected from tampering, helping you meet your Sarbanes-Oxley audit requirements.
Install the SQL2XL software on your Picture Perfect host and it
immediately becomes available to any PC that has network access
(including VPN). There is no restriction on the number of concurrent
users or terminals running SQL2XL. 
SQL2XL is 100% web-based and works with Picture Perfect releases 1.5.2 and above and runs on Linux, AIX, and Unixware. Operators must have a Picture Perfect login account since SQL2XL fully adheres to the Picture Perfect report permissions scheme.
Features
- Excel reports automatically generated and e-mailed to one or many recipients
- Worksheet protection using random or user-defined passwords
- Report titles and headers displayed on each Excel worksheet as defined by Picture Perfect report setup
- Built-in LDAP SSO support (PP 4.0 only)
- Complete integration with PP report permission scheme
- Syntax checking and error highlighting
- Variable and macro substitution using text, drop-down lists, and checkboxes
- Inactivity timeout
- Resizable fonts
- E-mail audit trail
Browsers supported include IE, Netscape, Opera, Mozilla. SQL2XL is delivered in RPM (Red Hat Package Manager) format for Linux and AIX 5L, and SHX (Shell Executable) for AIX and Unixware.
| SQL2XL Product Availability Chart | ||||
|---|---|---|---|---|
| PP Release | Red Hat Linux 4.0, 3.0 | IBM AIX 5.2 | IBM AIX 5.1 | IBM AIX 4.3 |
| 4.0 | .rpm | .rpm | N/A | N/A |
| 2.0 | .rpm | .rpm | rpm | N/A |
| 1.7 | .rpm | N/A | shx | .shx |
| Pricing and Ordering | ||||
Codebench SQL2XL™ is a trademark of Codebench, Inc.
