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 22.214.171.124, IDE Version: 126.96.36.199.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
The first step in protecting web services is to authenticate and authorize the web service requests. Authentication in web services is the process of verifying that the user has valid credentials to access the web services and authorization is the process of validating that the authenticated user has appropriate privileges to access the web services. Besides restricting access to users with valid credentials and proper privileges, Oracle WSM can track who accessed which service and when—to provide detailed audit trails. In this article, Sitaraman Lakshminarayanan explores how Oracle Web Services Manager can be leveraged to authenticate and authorize the web services requests.Read Oracle Web Services Manager: Authentication and Authorization in full
A navigation model defines the elements and hierarchy of a navigation. In WebCenter, you can have different navigation models. This way you can customize the model for specific needs. WebCenter lets you manage navigation models both at design time and runtime. This way, it is very easy for administrators who manage the portal to edit the navigation models. This article describes the creation and management of navigation models to guide the user through your portal and managing the page hierarchy.
In this article by Yannick Ongena, author of Oracle WebCenter 11g PS3 Administration Cookbook, you will learn about:
- Creating a navigation model at runtime
- Adding a folder to a navigation model
- Adding a link to a navigation model
- Managing the page hierarchy
A portlet is a component of software that can be part of a page. In consequence, a page can be enriched by many portlets allowing us to grab the contents of various sources of data. This article by Plinio Arbizu, author of Web 2.0 Solutions with Oracle WebCenter 11g, will help us to understand the concept associated with this technology and how it can apply to our projects with Oracle WebCenter.
During this article, you will learn the following:
- JSF specification concepts
- The types of portlets you can build with WebCenter
- Developing a portlet using ADF
- Integrating portlets with custom Applications
In this article by Andy Penver, we will cover the following:
- Introducing Workflow Builder
- Installing the database objects
- Creating an advanced queue
- Building a workflow
- Creating a business event
- Viewing a workflow status and monitoring progress
- Adding a function
- Creating a lookup
- Creating a subprocess
- Sending notifications and processing responses
- Calling an API