DB PowerStudio adds SQL Server Analysis

Released: Apr 15, 2013

Updates in this release

Updates in XE3.5

  • Custom Data Source Categories - Create your own custom categories including category name, short name and identifying color for each.
  • SQL Server Analysis - Table and column statistics now available when tuning against SQL Server data sources. The Table Statistics tab lets you view current table statistics settings as well as manually perform tasks such as updating statistics.
  • DB2 9.7 Execution Statistics - When tuning against a DB2 9.7 datasource, the Generated Cases area of the Overview tab now includes an additional set of execution statistics gathered for the suggested cases.
  • Oracle Database Links Support - Execute and generate cases for transformations, SQL rewrites and hints that do not rely on column, index, or primary key information.
  • Oracle Procedures Load Details - When profiling against an Oracle (10g or higher) data source, the Top Activity and Profiling Details pane now have a dedicated tab that provides procedure information.
  • Oracle Blocking Sessions Details - When profiling against an Oracle data source, the Top Activity and Profiling Details pane now have dedicated Blockers and Blocked Sessions tabs that provide information about sessions holding blocking locks.