This article, by Joseph Sydney Gomez and Sarma Anantapantula, gives us a high level view of the optional Essbase System 9 components that are available in the System 9 Suite with the Essbase database, the common foundation for all the other components to launch from. With components like Essbase Planning or Hyperion Smart Office, there's enough to make even the stodgiest accountant's head spin.Read Oracle Essbase System 9 Components in full
High Availability (HA) has become an important factor in computer system design in recent years. Systems can't afford to be down, not even for a minute, as they may be mission critical, life supporting, regulatory, or the financial impact may be too great to bear. Oracle has played a major role in developing a number of HA solutions, one of which is Real Application Clusters (RAC). Oracle Streams is heavily integrated with RAC out of the box and requires no additional configuration. This is not true for GoldenGate, where the Manager process has to be made "RAC aware".
In this article by John P. Jeffries, author of Oracle GoldenGate Implementer's Guide, we learn how to configure GoldenGate in a RAC environment and explore the various components that effectively enable HA for data replication and integration.Read Oracle GoldenGate 11g: Configuration for High Availability in full
Performance tuning is one of the main aspects of any IT project. Many leave it to the end and then realize that it is not possible to make the necessary changes without significant additional investment or time constraints. Performance must be considered at the beginning and throughout the lifetime of your project. Closely coupled to the design, this article hones in on individual performance tuning methods.
In this article by John P. Jeffries, author of Oracle GoldenGate Implementer's Guide, we learn the following:
- Balancing load across multiple processes
- Splitting large or transaction intensive tables across parallel process groups
- Adding additional Replicats to a process group
- Improving Replicat throughput by reducing commit delay
- Exploring the GoldenGate 11.1.1 new features
- Tuning the network
In this article by Ankur Gupta, author of the book Oracle GoldenGate 11g, we have been provided with a ready, step-by-step approach to perform various GoldenGate Administration tasks. With these recipes in hand, we will easily be able to implement and manage Oracle GoldenGate in an efficient way.
In this article we will cover the following recipes:
- Upgrading Oracle GoldenGate binaries
- Table structure changes in GoldenGate environments with similar table definitions
- Table structure changes in GoldenGate environments with different table definitions
- Resolving GoldenGate errors using the logdump utility
- Undoing the applied changes using the reverse utility
- Creating an Integrated Capture with a downstream database for compressed tables
The most important step in any IT development project is the design. This must be the first step as changes to the design at a later stage will cost time and money. Get the design right and your system will continue to perform well as the user base increases.
In this article by John P. Jeffries, author of Oracle GoldenGate Implementer's Guide, we will discuss the following areas to help answer some of the questions that influence the decision making process.
- Methods for replicating data: What do we want to achieve?
- Networking: How do we make our solution resilient to network outages?
- Performance and scalability: Will our solution support future non functional requirements?
- Backup and recovery: Can we restore service quickly with no data loss?
- Hardware: What is the size of our budget? Do we need powerful servers? Can we cluster lower spec machines?
Pivots are one of the most widely used tools for analyzing and presenting data. Interactive Reporting Pivots provide the business analyst with a very effective method to summarize and analyze a dataset, providing the ability to quickly modify, compute, and rearrange data while easily repopulating the dataset with new data. Pivots are very useful in presenting data, where the sections can be analyzed individually or included in Dashboards and Reports. The focus of this article is to demonstrate the features of the Pivot used to effectively analyze and present content.
This article by Edward J. Cody, author of The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11, covers:
- Creating pivots
- Methods for adding content
- Managing pivot headings
- Analyzing content
Packt author Tom Laszewski speaks about his latest Oracle book: Oracle Information Integration, Migration, and ConsolidationRead Oracle Information Integration, Migration, and Consolidation in full
In early 2010, when you went to the Oracle Technology Network (OTN) website, it had just one link called Information Integration. This link led you to a simple web page that had information on Oracle-to-Oracle database-centric migration and integration tools such as SQL Loader, Data Pump, Oracle Streams, and Oracle Data Guard. The OTN website has been updated, but still lacks comprehensive coverage of the Oracle Information Integration stack.
In the previous article by Tom Laszewski, co-author of Oracle Information Integration, Migration, and Consolidation, we took a look at some oracle tools and products. In this article we will take a look at data services, data consolidation, data grid, information lifecycle management, oracle-to-oracle data integration, and application integration.Read Oracle Integration and Consolidation Products in full
An application module in the ADF Business Components framework of JDeveloper, represents a basic transactional unit that implements specifc business use cases. It encompasses a data model comprising a hierarchy of view objects and optionally other application module instances, along with a number of custom methods that together implement a specifc business use case.
In this article, Nick Haralabidis, the author of Oracle JDeveloper 11gR2 Cookbook will cover:
- Creating and using generic extension interfaces
- Exposing a custom method as a web service
- Accessing a service interface method from another application module
- A passivation/activation framework for custom session-specifc data
- Displaying application module pool statistics
- Using a shared application module for static lookup data
- Using a custom database transaction
The Siebel CRM user interface supports the end user's desire to quickly navigate forward and backward while carrying out tasks. This article by Alexander Hansal, author of Oracle Siebel CRM 8 Developer's Handbook introduces the concept of drilldowns, the thread bar, and toggle applets and shows us how these navigation elements can be configured in Siebel Tools. The article is structured as follows:
- Understanding drilldown objects
- Creating static drilldowns
- Creating dynamic drilldowns
- Configuring the thread bar
- Configuring toggle applets
Many business requirements are very detailed and complex. For example, the end user community could demand that one field is updated automatically when another field has been changed. To solve this kind of requirement in Siebel CRM, developers can define so called user properties as an extension to the standard properties of object types such as business components, fields or applets. This important configuration option allows developers to define specialized application logic while staying within safe declarative boundaries. In this article by Alexander Hansal, author of Oracle Siebel CRM 8 Developer's Handbook, we will discuss the following topics:
- Understanding user properties
- Business component and field user properties
- Applet, control, and list column user properties
- Viewing user properties
Oracle SQL Developer Tool is a stand alone program that connects to Oracle as well as third-party databases which can be used to perform a variety of tasks from running simple queries to migration of databases from third party vendor products to Oracle. Please review the following articles on the earlier versions 1.1 and 1.2: MS Access Queries with Oracle SQL Developer 1.2 Tool and Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2.
In the present article by Dr. Jayaram Krishnaswamy the latest version of this tool [Oracle SQL Developer 188.8.131.52, IDE Version: 184.108.40.206.22.49. 33] will be described and some details of how to use this tool with SQL Server 2005 will be discussed. While the default installation is ready to connect to Oracle and Access databases the other third-party products such as SQL Server 2005, MySQL and Sybase require additional JDBC drivers. This article describes how you may connect to SQL Server 2005 and SQLExpress servers using the JDBC drivers. The Scratch Editor interface which accepts an SQL Statement from a 3rd party and translates into PL/SQL code is described. This feature was also available in the earlier version.Read Oracle SQL Developer Tool 1.5 with SQL Server 2005 in full
In early 2010, when you went to the Oracle Technology Network (OTN) website, it had just one link called Information Integration. This link led you to a simple web page that had information on Oracle-to-Oracle database-centric migration and integration tools such as SQL Loader, Data Pump, Oracle Streams, and Oracle Data Guard. The OTN website has been updated, but still lacks comprehensive coverage of the Oracle Information Integration stack. In this article by Tom Laszewski, co-author of Oracle Information Integration, Migration, and Consolidation, we will provide you with the relevant information, so that you can use the right Oracle Enterprise Information Integration (EII) or data migration product for your data migration, consolidation, and information integration projects.
This article covers the Oracle integration, migration, and consolidation products, tools and technologies in terms of the following taxonomies: data migration, physical federation, virtual federation. The focus of this article is to cover the great breadth and depth of Oracle products, not all the finer details.Read Oracle Tools and Products in full
Workflows are one of the most used and useful features of UCM. They give you the power to quickly set up reviews and approvals for documents, web pages, product documentation, "stage gates" for project management artifacts, "virtual voting" on government legislation, gathering digital signatures, and SOX compliance reviews.
This article by Dmitri Khanine, author of The Oracle Universal Content Management Handbook covers things you'd be doing most of the time as well as other important things you ought to know about workflows. More specifically you will learn:
- How to set up and change Content Server workflows—allowing you to get up to speed really fast, walking you step by step through an automation of a real-world approval process.
- Hidden (and frequently overlooked) facts about content life cycle that will help you locate and reclaim your disappeared content items.
In this two-part article series by Tarry Singh, we will have a look at the meaty aspects of the Oracle VM Manager and explore it's management aspects.
The following topics will be covered in this article:
- Getting started with the Oracle VM Manager
- Managing Servers and Server Pools
Read Oracle VM Management in full
In this article by Hector R. Madrid, we will discuss about the Oracle Wallet Manager. The Oracle Wallet Manager (OWM) is the tool used by Oracle to manage the authentication processes. It is a key tool for managing most of the authentication and security related tasks in an Oracle environment, this includes; authenticating users, providing SSL communication, and configuring the Transparent Data Encryption (TDE) feature, among others. There are two modes to work with the Oracle Wallet, the first one is by using the Java Oracle Wallet Manager console and the second one is by means of the mkwallet command line version, this method is suitable for batch processing. The Wallet is a very sensitive element; there are several ways to store it, not only in its file at the file system level, but also in the registry (for Windows platforms only). It can also be stored in an LDAP compliant directory.Read Oracle Wallet Manager in full
In this article by Bob Griesemer, author of Oracle Warehouse Builder 11g R2: Getting Started 2011, we'll discuss briefly what a Time dimension is, and then we'll dive right into the Warehouse Builder Design Center and create one. A Time dimension is a key part of most data warehouses. It provides the time series information to describe our data. A key feature of data warehouses is being able to analyze data from several time periods and compare results between them. The Time dimension is what provides us the means to retrieve data by time period.Read Oracle Warehouse Builder: Creating the Time Dimension in full
Data warehouses are becoming increasingly common as businesses have realized the need to be able to mine the information they have stored in the electronic form in order to provide a valuable insight into the operation of their business and how best to improve it. The Warehouse Builder contains a number of objects, which we can use in designing our data warehouse, that are either relational or dimensional. OWB currently supports designing a target schema only in an Oracle database.
In this article by Bob Griesemer, author of Oracle Warehouse Builder 11g R2: Getting Started 2011, we will cover:
- Creating a target user and module
- OWB design objects
This article is a two-part series. In this article by Deepak Vohra, we will use the XML document representation of a result set generated with an SQL query to modify a relational database table. You will learn to set the environment, create a Web RowSet, modify a database table with Web RowSet, create a new row, read a row, update a row, delete a row, update the database table and also get acquainted with JDBC 4.0 Version.Read Oracle Web RowSet - Part1 in full
In this two-part article series by Deepak Vohra, we will use the XML document representation of a result set generated with an SQL query to modify a relational database table. In the first part we set the environment, create a Web RowSet, modify a database table with Web RowSet, and create a new row. In this article we will learn to read a row, update a row, delete a row, update the database table and also get acquainted with JDBC 4.0 Version.Read Oracle Web RowSet - Part2 in full