BUSINESS INTELLIGENCE

Give Business Users Relevant BI Information


Panorama Software announced Panorama Enterprise Reporter, a reporting solution that integrates ad hoc query capabilities, analysis, and report authoring. The product gives end users the ability to create enterprise reports such as invoices, production reports, and financial statements from any Web browser. The company also announced the latest release of Panorama Performance Dashboard, which includes new tools to help end users communicate and collaborate better. The Web-based dashboard is personalized and automates the delivery of crucial business information from multiple data sources to any user inside or outside the corporate firewall. The integration of reporting, analysis, and key performance indicators (KPIs) in one interface makes it easy for users to move from one application to another. The product supports a variety of user-authentication and authorization protocols, including Anonymous Authentication for extranet deployments to partners, suppliers, and customers, and works with various data sources, including SQL Server, Oracle, IBM DB2, and Teradata. For pricing and other information, contact Panorama at 877-709-5848, info@panorama.com, or http://www.panorama.com.

DATABASE CONNECTIVITY

Provide Secure Data Connections


JNetDirect announced JSecureConnect 2.0, secure Java-component driver technology that provides secure and firewall tunneling Java Database Connectivity (JDBC) to SQL Server, Microsoft Access, Oracle, IBM DB2, and MySQL databases. The product provides secure JDBC access over SSL and HTTPS protocols and firewall tunneling through HTTP and HTTPS protocols. For the latest release, JNetDirect has optimized the product's code to reduce performance costs and provide HTTP and secure tunneling that's significantly faster than in previous releases. Pricing for JSecureConnect starts at $225 for a single-user, single-connection license. For more information, contact JNetDirect at 703-880-3800 or 800-995-8534, send an email message to customer@jnetdirect.com (existing customers) or sales@jnetdirect.com (new customers), or visit the company's Web site at http://www.jnetdirect.com.

DATABASE DOCUMENTATION TOOL

Document Your SQL Server Database


ApexSQL announced ApexSQL Doc 1.15, a SQL Server documentation tool that lets you create HTML Help-formatted documentation of every aspect of your SQL Server database. The product's wizard-based interface lets you automatically document a database in minutes. You can immediately publish the documentation for use in your organization and easily generate updates. The product also features a command-line interface that further automates the documentation process. ApexSQL Doc works with SQL Server 2000 and 7.0 and will be available for SQL Server 2005. A free, 14-day trial download is available at the ApexSQL Web site. Pricing for single-user licenses start at $199, and ApexSQL offers free support and free product upgrades. For more information or other pricing options, contact ApexSQL at 866-665-5500, sales@apexsql.com, or http://www.apexsql.com.

DATA PROTECTION AND RECOVERY

Get File-Based Continuous Data Protection


TimeSpring Software announced TimeData, file-based continuous data protection software. The software automatically captures all changes to application data in realtime so that transaction-dependent organizations—such as those involved in the financial, retail, healthcare, and manufacturing industries—can recover from data loss, corruption, or security breaches in minutes. The software makes it possible to perform offline processing such as reporting, analysis, or application testing by capturing all application and file metadata changes as they occur. The product checks all data changes for consistency and time-stamps them in a secure repository built on a standard Windows server. The data repository provides a complete change history and audit trail for application data that is easy to access and use. Pricing for TimeData starts at $1295 per file server. For more information, contact TimeSpring Software at 408-834-8966, 888-375-7634, or http://www.timespring.com.

DEVELOPER TOOLS

Accelerate Application Development


Altova announced version 2005 of its line of software-development tools. The four tools enable accelerated application development and data integration and include native, production-ready implementation of the World Wide Web Consortium's (W3C's) new XSLT 2.0 and XPath 2.0 specifications, as well as native support for XQuery. New features in Altova XMLSpy 2005 include advanced standards compliance, SchemaAgent (a visual tool for managing complex schemas), and integration with the Eclipse application development environment. Pricing for XMLSpy 2005 starts at $499. Altova MapForce 2005 incorporates flat-file support, a new visual function builder, and the ability to use transformation input parameters. MapForce 2005 pricing starts at $245. New in Altova StyleVision 2005 is the ability to auto-generate output in RTF format and create database-enabled electronic forms. Pricing for StyleVision 2005 starts at $245. And Altova Authentic 2005, the company's free content editor, introduces database-content editing, a feature that lets business users edit content in a relational database through electronic forms. All version 2005 products are currently available for download from Altova's Web site. For more information, contact Altova at 978-816-1600, sales@altova.com, or http://www.altova.com.

MIGRATION TOOLS

Migrate Stored Procedures


AdventNet announced the release of a free edition of SwisSQL Database Stored Procedure Migration Tools, part of the company's suite of tools that automates migration of complex proprietary stored procedures, SQL dialects, database schema, and enterprise data between database platforms. The SwisSQL database migration suite is the first toolset to offer stored-procedure migration. The free edition, which is designed for small projects or parts of larger projects, lets customers migrate up to 5000 lines of stored procedures across SQL Server, Oracle, IBM DB2, and Sybase databases. The free edition supports all the migration features of the product's Professional Edition, which you can try free for 30 days. The free edition of SwisSQL Database Stored Procedure Migration Tools is available for download at http://www.swissql.com. Pricing for the Professional Edition is based on the number of lines you need to migrate and starts at $495. For other product information and pricing, contact AdventNet at 925-924-9500, sales@advent net.com, or http://www.adventnet.com.

PERFORMANCE-TUNING TOOL

Pinpoint Blocking in SQL Server


Sql Power Tools announced Stealth Blocked Process and SQL Monitor, software that detects when a database client session's transaction blocks other clients from completing their SQL transactions. The product monitors database blocking and gives you a description of the blocked process, along with a realtime graph of the SQL statement text, show plan, resource usage, and the database locks involved in the blocking. The software also provides information about SQL statement resource utilization and the length of time the query was blocked or stopped from running. The product lets you pinpoint and rank the most frequently blocked SQL statements and provides a historical summary of every SQL statement involved in blocking so that you can analyze performance problems. A free trial of the Stealth Blocked Process and SQL Monitor is available for download at http://www.sqlpower.com. For pricing and other information, contact Sql Power tools at 307-433-8039 or info@sqlpower.com.