As Published In
Oracle Magazine
March/April 2010

AT ORACLE: Oracle News Briefs

Oracle SQL Developer 2.1 Offers Productivity Enhancements

Now available, Oracle SQL Developer 2.1 is the latest release of Oracle’s free database development and migration tool. Oracle SQL Developer 2.1 offers Oracle Database developers productivity enhancements with two new features: PL/SQL Unit Testing and Data Modeler Viewer.

PL/SQL Unit Testing is a unit-testing framework that enables developers to build and share unit tests and test suites that can be run in batch mode and from the command line against different databases. It offers database developers prebuilt capabilities with which to develop and run regression tests for their database code, resulting in higher-quality database development while reducing the need for writing scripts for unit testing.

Data Modeler Viewer provides read-only access to Oracle SQL Developer Data Modeler. This new feature enables developers, data modelers, IT architects, and others to use the tool to open and browse data models built with the standalone Oracle SQL Developer Data Modeler as well as graphically view their schema objects by dragging tables onto a model diagram. Data Modeler Viewer allows users to rely on a single tool to browse third-party database tables and their foreign key relationships on a diagram and then use the tool to migrate data and objects to an Oracle database.

Oracle SQL Developer 2.1 also introduces Oracle Migration Workbench support for Teradata and IBM DB2 UDB for Linux, UNIX, and Windows.

“The addition of PL/SQL Unit Testing sets Oracle SQL Developer apart from many other database development tools,” says Mike Hichwa, vice president of software development at Oracle. “We know virtually every Oracle Database customer uses PL/SQL, and having a robust unit-testing framework will allow our customers to reduce costs and improve the quality of their releases.”

Oracle Process Integration Packs Integrate Project Management with ERP

Two new Oracle Application Integration Architecture 2.5 Process Integration Packs integrate project management and enterprise resource planning (ERP).

Oracle Project Portfolio Management Integration Pack for Primavera P6 and Oracle E-Business Suite connects Oracle’s Primavera P6 Enterprise Project Portfolio Management with Oracle Project Costing and Oracle Project Management to seamlessly integrate project management and financial information for complete enterprise project portfolio management (PPM) functionality. It allows users to synchronize information regardless of whether they create projects in Oracle Project Costing and Oracle Project Management or Primavera P6 Enterprise Project Portfolio Management.

Oracle Project Portfolio Management Integration Pack for Primavera P6 and Oracle’s JD Edwards EnterpriseOne connects Primavera P6 Enterprise Project Portfolio Management and JD Edwards EnterpriseOne Project Costing, offering seamless integration that allows users to synchronize information between the two solutions regardless of where they create projects.

With either pack, users can synchronize project structures, resource details, budgets, actual costs, progress, and cost to complete. This provides one cohesive look into all projects and portfolios within an enterprise.

“The Oracle PPM integration packs bridge the gap between ERP and project management to deliver true enterprise PPM for the first time, helping to ensure that projects adhere to committed budgets and time frames,” says Joel Koppelman, senior vice president and general manager, Oracle’s Primavera Global Business Unit.

Oracle Real User Experience Insight 6 Unveiled

Oracle has released Oracle Real User Experience Insight 6, a real-user monitoring solution for business applications that combines performance and usage analysis into a single offering. Oracle Real User Experience Insight integrates with the performance diagnostics capabilities of Oracle Enterprise Manager, helping to identify and resolve user experience issues before business is affected.

The new release also integrates with Oracle’s Java diagnostic and SOA management capabilities to provide a single-vendor solution for proactively diagnosing anomalies from the end-user perspective through to the application, middleware, and database. This allows businesses to decrease the time it takes to identify and repair issues. The release also delivers enhanced accelerators for Oracle’s Siebel Customer Relationship Management, Oracle E-Business Suite, and Oracle’s PeopleSoft Enterprise and JD Edwards EnterpriseOne applications, providing improved end-user monitoring and service-level management for these applications.

Oracle Real User Experience Insight 6 integrates enterprise-class performance diagnostics with business dashboards and Oracle application-ready accelerators. Key features of the new release include integrated performance diagnostics, full user session replay, and customizable monitoring dashboards.

“With a unique monitoring solution to capture and replay entire user sessions, Oracle Real User Experience 6 enables a shared understanding of application users’ experience and helps to close the traditional gap between business and IT,” says Richard Sarwal, senior vice president of product development at Oracle. “By providing a complete picture of performance analysis and insight into business trends and user preferences, Oracle Real User Experience 6 can accelerate problem resolution for underperforming applications, significantly lower the total cost of ownership, and improve the overall customer experience.”

Oracle Governance, Risk, and Compliance Controls Suite 8.5 Available 

Did You Know?

Decision-Making A Challenge

A survey of 208 business and IT leaders in North America, western Europe, and Asia Pacific found that decision-making based on timely, relevant, and accurate information remains a challenge. Just 3 percent of respondents described their companies as “experts” in using business data to drive better and faster executive decisions, while 24 percent ranked their firms as “advanced practitioners.” 27 percent said their companies make better, faster business decisions than their key competitors, and 55 percent said too much operational information can unnecessarily slow down decision-making.
Source: The Economist Intelligence Unit, CSC, and Oracle

BI Pros Unsure About Social Media

A survey of 125 business intelligence (BI) practitioners worldwide revealed that 63 percent are “undecided” about the value of data collected from social media sites such as Twitter and Facebook. Another 23 percent said social media data is “overrated.”
Source: Kognitio

Most Companies Protecting PC Data

53 percent of all organizations have deployed software or a service for PC backup, according to a Web survey of 252 IT and business professionals. More than 32 percent of organizations rely on individual employees to back up PC data themselves.
Source: IDC

Server Planning Eludes IT Leaders

In a survey of 441 U.S. and U.K.-based IT decision-makers at companies with 100 to 500 employees, 51 percent admitted making mistakes in server capacity planning, with 36 percent buying too few servers and 15 percent buying too many.
Source: Kroll Ontrack

Oracle Governance, Risk, and Compliance Controls Suite 8.5, now shipping, includes new versions of Oracle Transaction Controls Governor and Oracle Application Access Controls Governor. The suite continuously monitors automated controls in enterprise applications to enforce policies, strengthen the integrity of critical business processes, and mitigate exposure to fraud and error.

Oracle Transaction Controls Governor is a policy-authoring engine that enables ad hoc definition and analysis of access, master data, and transaction controls across systems without requiring technical skills. It uses a visual approach to support the construction of custom controls by business users. As they specify steps, articulate control flow, and apply filters, users are able to define highly specific rules in a simple way. Oracle Transaction Controls Governor uses statistical logic and algorithms to analyze patterns and systematically uncover control weaknesses and out-of-policy transactions. With fewer false positives, control results are more accurate and can be relied on with more confidence. An adapter framework for connecting to any business application allows organizations with several versions of enterprise resource planning financial applications from multiple vendors to manage controls heterogeneously.

Oracle Application Access Controls Governor provides improved graphical simulation capabilities to allow users to graphically look into access points, easily identify segregation-of-duties conflicts, and simulate what-if scenarios to evaluate treatment options. By previewing the effects of cleanup if proposed conflict resolutions were implemented, organizations can sensibly decide on and apply remediation plans.

“The enhancements in the Oracle Governance, Risk, and Compliance Controls Suite reduce the time and cost customers spend on errors and remediation and maximize their business performance,” says Stephanie Maziol, product marketing director for governance, risk, and compliance applications at Oracle.

Oracle Business Process Analysis Suite 11g Released

The latest release of Oracle’s integrated product suite for designing, modeling, simulating, and optimizing business processes is now available: Oracle Business Process Analysis Suite 11g. Based on IDS Scheer’s ARIS Design Platform, Oracle Business Process Analysis Suite 11g delivers more-complete integration with Oracle SOA Suite to improve business and IT collaboration and maximize operational efficiency. Oracle Business Process Analysis Suite 11g provides customers with a unified solution that enhances collaboration, helps reduce costs, enhances visibility, and streamlines the development and execution of business processes.

Oracle Business Process Analysis Suite 11g offers comprehensive process modeling capabilities for methodology-driven process design and a common process model in a unified environment, enabling both business and IT users to utilize the best tools for their respective requirements. The latest release also improves process lifecycle management by simplifying process change management and delivers greater business visibility through improved process visibility and reporting. In addition, it includes rich reporting capabilities along with the ability to capture context around supporting systems, products, services, organizations, strategy, risks, and objectives to help enterprises plan and optimize their process improvement initiatives.

“Now business and IT users have the right set of tools designed for their individual needs—business users design process models with Oracle Business Process Analysis Suite 11g, and IT uses the same process models for execution with Oracle SOA Suite. With this latest release, our customers can reduce the gap between IT and business,” says Amlan Debnath, senior vice president of product development at Oracle.

Oracle GoldenGate Delivers Fast Real-Time Data Integration

Now available, Oracle GoldenGate is a data integration solution that delivers fast real-time data integration and bulk data transformation. Oracle GoldenGate also provides reliable data quality, instant business intelligence, higher online transaction processing (OLTP) performance, and 24/7 data availability for mission-critical systems.

Oracle GoldenGate allows real-time data movement between heterogeneous source and target systems with minimal overhead on the IT infrastructure, enabling real-time business intelligence solutions; multidirectional data synchronization for distributed systems; downtime-free system upgrades; disaster recovery; and migrations between heterogeneous databases, OS platforms, and servers.

“Oracle GoldenGate helps organizations harness the value of their IT investments and improve business operations by providing continuous access to business-critical information in real time—resulting in improved business intelligence across the enterprise, with more-accurate and more-timely analysis of business performance,” says Hasan Rizvi, senior vice president for Oracle Fusion Middleware.

Web Locator

 Oracle SQL Developer 2.1
Oracle Application Integration Architecture 2.5 Process Integration Packs
Oracle Real User Experience Insight
Oracle Governance, Risk, and Compliance Controls Suite
Oracle Business Process Analysis Suite
Oracle GoldenGate
Oracle and Silver Creek Systems
Oracle Audit Vault
Oracle Enterprise Single Sign-On Anywhere

Oracle Buys Product Data Quality Provider Silver Creek Systems

Oracle has acquired Silver Creek Systems, a provider of product data quality solutions. Silver Creek’s DataLens product data quality solution is designed to simplify complex product descriptions commonly found in many industries, enabling enterprises to more accurately manage product data. Accurate product data improves time to market for new products, enhances supply chain execution, increases operational efficiencies, and facilitates better business decisions across the enterprise.

The addition of Silver Creek products complements Oracle’s information management offerings to provide a more complete and more integrated solution.

“With the addition of Silver Creek, Oracle is extending its industry-leading data integration offering with complementary solutions to enhance product data quality and help customers get more-accurate and more-consistent product data for use across their enterprise,” says Hasan Rizvi, senior vice president for Oracle Fusion Middleware.

Oracle Audit Vault Streamlines Database Audit Process

Oracle has released Oracle Audit Vault, which includes new reporting and alerting capabilities that automate and streamline the database audit process. The new release includes report scheduling, notification, attestation, and archiving capabilities that can help organizations lower the cost of complying with internal and external data privacy and protection mandates. New entitlement reports provide up-to-date snapshots of Oracle Database users, privileges, and profiles, which allow auditors to track changes to database access.

The new release also includes compliance reports to specifically address the Sarbanes-Oxley Act, the Health Insurance Portability and Accountability Act, and the Payment Card Industry Data Security Standard regulatory requirements for database activity monitoring and audit. Oracle Audit Vault also now includes automated cleanup of audit trail data from supported Oracle and non-Oracle databases once that audit data has been securely consolidated in the Oracle Audit Vault repository.

“This new release of Oracle Audit Vault will allow organizations to further automate their database activity monitoring and auditing processes, reducing the overall cost of meeting regulatory requirements and securing critical data,” says Vipin Samar, vice president of database security at Oracle. “Oracle consulted with IT auditors to help ensure that the new Oracle Audit Vault entitlements and compliance-specific reports contain the information needed to pass real-world database audits.”

Oracle Enterprise Single Sign-On Anywhere Supports Private Clouds

Now available, Oracle Enterprise Single Sign-On Anywhere lets enterprises host single-tenant enterprise single sign-on in a private cloud. Oracle Enterprise Single Sign-On Anywhere extends Oracle Enterprise Single Sign-On Suite to provide employees, partners, suppliers, and other enterprise affiliates with secure access to Web-based, client/server, and mainframe enterprise applications. With Oracle Enterprise Single Sign-On Anywhere, enterprises can increase operational efficiencies, reduce costs, enhance security, boost productivity, and accelerate regulatory compliance.

“With the release of Oracle Enterprise Single Sign-On Anywhere, Oracle is the first major identity management vendor to offer a private-instance, transparent-install model for enterprise single sign-on delivered anytime, anywhere,” says Amit Jasuja, vice president, Oracle Identity Management. “Now, users can just sign on to a Web portal page and download and activate the Oracle client that is preloaded with authorized credentials for all user-entitled resources.” 

Send us your comments