Tuesday May 06, 2014

No Way Out, But to Consolidate

IT teams receive pressures on multiple fronts: Business groups demand new application services delivered faster and continuous, high-quality IT service to support highly dynamic and competitive business operations. In the meanwhile IT teams are asked to reduce costs and improve ROI from existing systems in highly complex and siloed environments.

In the midst of this conundrum, the only way out for IT leadership is to consolidate and leverage cloud architecture. Especially consolidation at the database level and implementing a private database-as-a-service (DBaaS) environment is a transformative approach to delivering database functionality to end users in an agile, efficient, and scalable way.  It helps organizations improve resource utilization, and lower both capital and operational expenditures.

Oracle Database 12c is designed to support database consolidation with many new features for deploying shared database environment. The new multitenant architecture, simplified management capabilities, improvements to security and compliance, along with robust and flexible Maximum Availability Architecture, are only a few of the key differentiators.

While this all sounds good and logical for IT teams, when it comes to moving to a private database cloud, they face yet another major challenge: How do we move our critical systems to a new environment without interrupting our operations. In today’s 24/7 world, especially customer-facing systems cannot tolerate hours or days of downtime. For some of them, even few minutes of downtime can bring high costs to the business. As in each major project, risk involved with moving to a new system is a real deterrent factor too.

Oracle GoldenGate 12c offers the core capabilities to enable this major move to a database as a service environment. With its optimized support for Oracle Database 12c multitenant architecture and heterogeneous data replication capabilities, Oracle GoldenGate allows organizations to avoid business disruption while the systems are moving to a consolidated, DBaaS environment. In addition, Oracle GoldenGate offers a failback option to the old environment, or a phased migration option by running old and new systems simultaneously in active-active mode, to minimize risks. Oracle GoldenGate’s heterogeneity includes all major database vendors and operating systems including SQL Server, DB2 (LUW, z/Os, iSeries), Sybase ASE, HP NonStop and more. 

In our webcast Zero Downtime Consolidation to Oracle Database 12c with Oracle GoldenGate 12c on May 13th 10am PT we will present this solution with specific architecture examples and comparison to other database upgrade options.

Zero Downtime Consolidation to Oracle Database 12c with Oracle GoldenGate 12c

May 13th, 10am PT/ 1pm ET

If your organization needs to improve agility, increase innovation, and reduce costs, I invite you to join this webcast to learn how to remove the risk and business interruption barriers to move to an agile and cost-efficient private database cloud.

User Interface and Terminology Changes in ODI 12c - Part 2

In the first blog post in this series we have covered many of the UI changes made in ODI 12c. In this second blog post we will continue covering some of the changes made at the Mapping level.

Declarative Flow-Based Design

The first major change you are probably going to see when using ODI 12c coming from earlier versions is that we have augmented the ODI Declarative Design concept with Flow-Based elements. The goal has been to take ELT/ETL Mapping design to the next level by providing greater flexibility and advanced features like new Mapping Components while still keeping the Logical and Physical representations separate. What it means in practice is that you can now do more with ODI Mappings such as writing to multiple targets or ordering your transformations the way you want it while still being more productive than you would be in a conventional ETL tool.

As an example I’ve added below a screenshot of an ODI 11g Interface and then a screenshot of its corresponding Mapping in 12c:

Aggregate Functions

In ODI 11g aggregate functions were directly entered in the target datastore mapping expressions and the group by expression was automatically created by ODI.

In ODI 12c aggregates must now be performed using the Aggregate Component which is found in the Mapping Component palette. The Aggregate component allows you to specify manually the group by and having clauses which wasn’t possible in earlier ODI releases.

Using aggregate functions in a target datastore expression will now trigger a Mapping validation error and prevent its execution.


Doing a distinct operation in ODI 11g required checking the ‘Distinct Rows’ checkbox in the Target Properties panel in the Flow tab. In 12c doing a distinct operation is more straightforward and is defined explicitly using the Distinct Component which is available from the Mapping Components palette.


Filters can still be defined in a similar way to ODI 11g by simply drag and dropping a source Datastore attribute into the Diagram area surrounding it. It is also possible to use the new Filter Component from the Mapping Components palette. The Filter Condition is then provided in the Properties of the Filter Component.


Joins are created using the new Join Component from the Mapping Components palette. Outside of a Dataset Component (which we will review later), it is not possible anymore to drag and drop a column from one source Datastore to another one to create a join like in ODI 11g. Once you have added the Join Component into the Mapping diagram you can type the Join expression manually or drag and drop columns/attributes from the source datastores into the Join Component to build the Join expression graphically.

Ordered Joins

If you are using ordered joins in ODI 12c make sure you check the ‘Join Order’ checkbox and provide an order number in the ‘User Defined’ field. If no value is provided in the ‘User Defined’ field the ‘Join Order’ checkbox will automatically be unchecked by ODI. Those fields are available in the Condition panel of a Join Component Properties window as shown below.


The Lookup wizard found in ODI 11g has been replaced by a new Component named Lookup. We also spent some time optimizing the Lookup parameters to make it more intuitive and powerful. It is now, for example, possible to define what happens if there are multiple rows matched or if no records are being matched.

We still have many more enhancements to cover, stay tuned for the last post in this blog series!


Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality


« May 2014 »