Oracle Integration and Consolidation Products

Exclusive offer: get 50% off this eBook here
Oracle Information Integration, Migration, and Consolidation

Oracle Information Integration, Migration, and Consolidation — Save 50%

The definitive book and eBook guide to Oracle Information Integration and Migration in a heterogeneous world

$32.99    $16.50
by Tom Laszewski | August 2011 | Enterprise Articles Oracle

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.

 

Oracle Information Integration, Migration, and Consolidation

Oracle Information Integration, Migration, and Consolidation

The definitive book and eBook guide to Oracle information integration and migration in a heterogeneous world

        Read more about this book      

(For more resources on Oracle, see here.)

Data services

Data services are at the leading edge of data integration. Traditional data integration involves moving data to a central repository or accessing data virtually through SQL-based interfaces. Data services are a means of making data a 'first class' citizen in your SOA.

Recently, the idea of SOA-enabled data services has taken off in the IT industry. This is not any different than accessing data using SQL, JDBC, or ODBC. What is new is that your service-based architecture can now view any database access service as a web service. Service Component Architecture (SCA) plays a big role in data services as now data services created and deployed using Oracle BPEL, Oracle ESB, and other Oracle SOA products can be part of an end-to-end data services platform. No longer do data services deployed in one of the SOA products have to be deployed in another Oracle SOA product. SCA makes it possible to call a BPEL component from Oracle Service Bus and vice versa.

Oracle Data Integration Suite

Oracle Data Integration (ODI)Suite includes the Oracle Service Bus to publish and subscribe messaging capabilities. Process orchestration capabilities are provided by Oracle BPEL Process Manager, and can be configured to support rule-based, event-based, and data-based delivery services. The Oracle Data Quality for Data Integrator, Oracle Data Profiling products, and Oracle Hyperion Data Relationship Manager provide best-in-class capabilities for data governance, change management hierarchical data management, and provides the foundation for reference data management of any kind.

ODI Suite allows you to create data services that can be used in your SCA environment. These data services can be created in ODI, Oracle BPEL or the Oracle Service Bus. You can surround your SCA data services with Oracle Data Quality and Hyperion Data Relationship to cleanse your data and provide master data management. ODI Suite effectively serves two purposes:

  • Bundle Oracle data integration solutions as most customers will need ODI, Oracle BPEL, Oracle Service Bus, and data quality and profiling in order to build a complete data services solution
  • Compete with similar offerings from IBM (InfoSphere Information Server) and Microsoft (BizTalk 2010) that offer complete EII solutions in one offering

The ODI Suite data service source and target data sources along with development languages and tools supported are:

Data source Data target Development languages and tools
ERPs, CRMs, B2B systems, flat files, XML data, LDAP, JDBC, ODBC Any data source SQL, Java, GUI

The most likely instances or use cases when ODI Suite would be the Oracle product or tool selected are:

  • SCA-based data services
  • An end-to-end EII and data migration solution

Data services can be used to expose any data source as a service. Once a data service is created, it is accessible and consumable by any web service-enabled product. In the case of Oracle, this is the entire set of products in the Oracle Fusion Middleware Suite.

Data consolidation

The mainframe was the ultimate solution when it came to data consolidation. All data in an enterprise resided in one or several mainframes that were physically located in a data center. The rise of the hardware and software appliance has created a 'what is old is new again' situation; a hardware and software solution that is sold as one product. Oracle has released the Oracle Exadata appliance and IBM acquired the pure database warehouse appliance company Netezza, HP, and Microsoft announced work on an SQL Server database appliance, and even companies like SAP, EMC, and CICSO are talking about the benefits of database appliances.

The difference is (and it is a big difference) that the present architecture is based upon open standards hardware platforms, operating systems, client devices, network protocols, interfaces, and databases. So, you now have a database appliance that is not based upon proprietary operating systems, hardware, network components, software, and data disks. Another very important difference is that enterprise software COTS packages, management tools, and other software infrastructure tools will work across any of these appliance solutions. One of the challenges for customers that run their business on the mainframe is that they are 'locked into' vendor- specific sorting, reporting, job scheduling, system management, and other products usually only offered from IBM, CA, BMC, or Compuware. Mainframe customers also suffer from a lack of choice when it comes to COTS applications. Since appliances are based upon open systems, there is an incredibly large software ecosystem.

Oracle Exadata

Oracle Exadata is the only database appliance that runs both data warehouse and OLTP applications. Oracle Exadata is an appliance that includes every component an IT organization needs to process information—from a grid database down to the power supply. It is a hardware and software solution that can be up and running in an enterprise in weeks instead of months for typical IT database solutions.

Exadata provides high speed data access using a combination of hardware and a database engine that runs at the storage tier. Typical database solutions have to use indexes to retrieve data from storage and then pull large volumes of data into the core database engine, which churns through millions of rows of data to send a handful of row results to the client. Exadata eliminates the need for indexes and data engine processing by placing a lightweight database engine at the storage tier. Therefore, the database engine is only provided with the end result and does not have to utilize complicated indexing schemes, large amounts of CPU, and memory to produce the end results set. Exadata's capabilities to run large OLTP and data warehouse applications, or a large number of smaller OLTP and data warehouse applications on one machine make it a great platform for data consolidation.

The first release of Oracle Exadata was based upon HP hardware and was for data warehouses only. The second release came out shortly before Oracle acquired Sun. This release was based upon Sun hardware, but ironically not on Sun Sparc or Solaris (Solaris is now an OS option). The Exadata source and target data sources along with development languages and tools supported are:

Data source Data target Development languages and tools
Any (depending upon the data source this may involve an intensive migration effort) Oracle Exadata SQL, PL/SQL, Java

The most likely instances or use cases when Exadata would be the Oracle product or tool selected are:

  • A move from hundreds of standalone database hardware and software nodes to one database machine
  • A reduction in hardware and software vendors, and one vendor for hardware and software support

Keepin It Real
The database appliance has become the latest trend in the IT industry. Data warehouse appliances like Netezza have been around for a number of years. Oracle has been the first vendor to offer an open systems database appliance for both DW and OLTP environments.

Data grid

Instead of consolidating databases physically or accessing the data where it resides, a data grid places the data into an in-memory middle tier. Like physical federation, the data is being placed into a centralized data repository. Unlike physical federation, the data is not placed into a traditional RDBMS system (Oracle database), but into a high-speed memory-based data grid. Oracle offers both a Java and SQL-based data grid solution. The decision of what product to implement often depends on where the corporations system, database, and application developer skills are strongest.

If your organization has strong Java or .Net skills and is more comfortable with application servers than databases, then Oracle Coherence is typically the product of choice. If you have strong database administration and SQL skills, then Oracle TimesTen is probably a better solution.

The Oracle Exalogic solution takes the data grid to another level by placing Oracle Coherence, along with other Oracle hardware and software solutions, into an appliance. This appliance provides an 'end-to-end' solution or data grid 'in a box'. It reduces management, increases performance, reduces TCO, and eliminates the need for the customer having to build their own hardware and software solution using multiple vendor solutions that may not be certified to work together.

Oracle Coherence

Oracle Coherence is an in-memory data grid solution that offers next generation Extreme Transaction Processing (XTP). Organizations can predictably scale mission critical applications by using Oracle Coherence to provide fast and reliable access to frequently used data. Oracle Coherence enables customers to push data closer to the application for faster access and greater resource utilization. By automatically and dynamically partitioning data in memory across multiple servers, Oracle Coherence enables continuous data availability and transactional integrity, even in the event of a server failure.

Oracle Coherence was purchased from Tangosol Software in 2007. Coherence was an industry-leading middle tier caching solution. The product only offered a Java solution at the time of acquisition, but a .NET offering was already scheduled before the acquisition took place. The Oracle Coherence source and target data sources along with development languages and tools supported are:

Data source Data target Development languages and tools
JDBC, any data source accessible through Oracle SOA adapters Coherence Java, .Net

The most likely instances or use cases when Oracle Coherence would be the Oracle product or tool selected are:

  • When it is necessary to replace custom, hand-coded solutions that cache data in middle tier Java or .NET application servers
  • Your company's strengths are in application servers Java or .NET

Oracle TimesTen

Oracle TimesTen is a data grid/cache offering that has similar characteristics to Oracle Coherence. Both of the solutions offer a product that caches data in the middle tier for high throughput and high transaction volumes. The technology implementations are much different. TimesTen is an in-memory database solution that is accessed through SQL and the data storage mechanism is a relational database. The TimesTen solution data grid can be implemented across a wide area network (WAN) and the nodes that make up the data grid are kept in sync with your back end Oracle database using Oracle Cache Connect. Cache Connect is also used to automatically refresh the TimesTen database on a push or pull basis from your Oracle backend database. Cache Connect can also be used to keep TimesTen databases spread across the global in sync.

Oracle TimesTen offers both read and update support, unlike other database in- memory solutions. This means that Oracle TimesTen can be used to run your business even if your backend database is down. The transactions that occur during the downtime are queued and applied to your backend database once it is restored.

The other similarity between Oracle Coherence and TimesTen is that they both were acquired technologies. Oracle TimesTen was acquired from the company TimesTen in 2005. The Oracle TimesTen source and target data sources along with development languages and tools supported are:

Data source Data target Development languages and tools
Oracle TimesTen SQL, CLI

The most likely instances or use cases when Oracle TimesTen would be the Oracle product or tool selected are:

  • For web-based read-only applications that require a millisecond responseand data close to where request is made
  • For applications where updates need not be reflected back to the user in real-time

Oracle Exalogic

A simplified explanation of Oracle Exalogic is that it is Exadata for the middle tier application infrastructure. While Exalogic is optimized for enterprise Java, it is also a suitable environment for the thousands of third-party and custom Linux and Solaris applications widely deployed on Java, .NET, Visual Basic, PHP, or any other programming language. The core software components of Exalogic are WebLogic, Coherence, JRocket or Java Hotspot, and Oracle Linux or Solaris. Oracle Exalogic has an optimized version of WebLogic to run Java applications more efficiently and faster than a typical WebLogic implementation.

Oracle Exalogic is branded with the Oracle Elastic cloud as an enterprise application consolidation platform. This means that applications can be added on demand and in real-time. Data can be cached in Oracle Coherence for a high speed, centralized, data grid sharable on the cloud. The Exalogic source and target data sources along with development languages and tools supported are:

Data source Data target Development languages and tools
Any data source Coherence Any language

The most likely instances or use cases when Exalogic would be the Oracle product or tool selected are:

  • Enterprise consolidated application server platform
  • Cloud hosted solution
  • Upgrade and Consolidation of hardware or software

Oracle Coherence is the product of choice for Java and .NET versed development shops. Oracle TimesTen is more applicable to database-centric and shops more comfortable with SQL.

Oracle Information Integration, Migration, and Consolidation The definitive book and eBook guide to Oracle Information Integration and Migration in a heterogeneous world
Published: September 2011
eBook Price: $32.99
Book Price: $54.99
See more
Select your format and quantity:
        Read more about this book      

(For more resources on Oracle, see here.)

Information Lifecycle Management

Information Lifecycle Management (ILM) is a supporting solution for physical federation, data consolidation, and business intelligence. What all these data integration solutions have in common is that the database where the information is being stored continues to grow as daily activity is added to the centralized database. This is not only an issue of data storage costs, but also performance of the applications that access these databases and the cost of managing growing volumes of data. ILM provides a mechanism to automatically move data from primary high speed storage to lower cost storage.

Oracle Information Lifecycle Management

Oracle ILM is a combination of features that are part of the Oracle database and a lightweight GUI that can be used to build an ILM solution. These Oracle database features include Oracle table partitioning, Oracle advanced table compression, and Virtual Private Database (VPD). Oracle VPD is used in an ILM solution by eliminating the number of rows returned to end users based upon what data the user has the authority to access, therefore maintaining the performance as data volumes grow. Oracle ILM Assistant uses some of these features and is a GUI tool to help implement Oracle ILM. The Oracle ILM Assistant allows you to define lifecycle definitions, a calendar of events, simulates the impact of partitioning on a table, advises how to partition a table, and generates and schedules scripts to move data when required. The Oracle ILM Suite source and target data sources along with development languages and tools supported are:

Data source

Data target

Development languages and tools

Oracle

Oracle

GUI, CLI, SQL, PL/ SQL

The most likely instances or use cases when Oracle ILM would be the Oracle product or tool selected are:

  • Growing database volumes where data has become difficult to manage and maintain
  • Increased hardware, software, and support costs because of exponential data growth

Oracle ILM is a package of Oracle products (partitioning) that have existed for quite some time. Oracle does put a GUI on top of these products to make managing Oracle data archiving in less expensive storage easier.

Oracle-to-Oracle

Oracle-to-Oracle data integration is treated separately as Oracle offers products hat have been optimized for moving data between Oracle database instances. These products can only be used when both the source and target databases are Oracle databases. Oracle has had a long history of Oracle-to-Oracle-based solutions, including Oracle Replication Server and Oracle imp/exp. These key legacy Oracle-to-Oracle integration solutions have been replaced by Oracle Streams and Oracle Data Pump, respectively.

Oracle Streams

Oracle Streams is a log-based solution that enables the propagation and management of data, transactions, and events in a data stream either within an Oracle database, or from one Oracle database to another. The stream routes published information to subscribed destinations. Streams supports capture and apply from Oracle to non- Oracle systems. However, the apply or capture from non-Oracle systems must be custom-coded, or through an Oracle Transparent or Generic Gateway. In addition, messages can be sent to and received from other message queuing systems such as MQ Series and Tibco through the Oracle Message Gateway.

Oracle Streams replaced the Oracle Replication Server in 2006 as the Oracle replication product of choice. Oracle Replication was originally a trigger-based solution and this was perceived negatively by the customers. Oracle Streams offered log-based solution which was more to the liking of enterprise customers. The Oracle Streams source and target data sources along with development languages and tools supported are:

Data source

Data target

Development languages and tools

Oracle

Oracle

SQL, PL/SQL, CLI

The most likely instances or use cases when Oracle Streams would be the Oracle product or tool selected are:

  • High speed near real-time Oracle-to-Oracle replication
  • Oracle disaster recovery solution

Oracle Data Pump

Oracle Data Pump is a replacement for the original EXP and IMP utilities. Available from Oracle 10g, Data Pump is the new export and import mechanism that provides increased performance and more features then EXP/IMP. As from Oracle 11g, original IMP/EXP is no longer supported for general use, but is still available for use with Oracle 10g or earlier databases. Oracle Data Pump can be used for logical backup of schema/table, to refresh the test system from production, database upgrades (either cross-platform, or with storage reorganization), and moving data from production to offline usage (such as a data warehouse, ad hoc query). Data Pump complements other Oracle database features such as RMAN physical backups and Oracle Warehouse Builder for Load operations. The Oracle Data Pump source and target data sources along with development languages and tools supported are:

Data source

Data target

Development languages and tools

Oracle

Oracle

CLI

The most likely instances or use cases when Oracle Data Pump would be the Oracle product or tool selected are:

  • Creation of test and QA databases
  • Cloning of Oracle databases
  • Database upgrades

Oracle Data Pump is the choice when it comes to moving between databases when real-time streaming is not possible because of network bandwidth constraints, or network connectivity is not even possible. When a high speed network is available, Oracle Streams will probably be the best option.

Oracle XStream Oracle

XStream is a new product released with Oracle 11g. The underlying technology is based upon Oracle Streams. XStream consists of Oracle database components and application programming interfaces (APIs) that enable client applications to receive data changes from an Oracle database and send data changes to an Oracle database.

Oracle XStream provided several capabilities which are above and beyond Oracle Streams:

  • In-memory exchange of messages to the target database, application, or queue
  • Sending Oracle database changes through a message to a Java or C application

Data source

Data target

Development languages and tools

Oracle

Oracle (in theory could be any database, a flat file, or another application)

SQL, PL/SQL, CLI

The most likely instances or use cases when Oracle XStream would be the Oracle product or tool selected are:

  • High speed in-memory messaging
  • Capturing and sending Oracle database changes to applications, queues, other Oracle databases or non-Oracle databases

Application integration

Application integration takes many of the products and technologies we discussed in this article to provide a complete integration solution for orchestrating agile, user-centric business processes across your enterprise applications. The products that are bundled with the Oracle SOA Suite are the foundation of Oracle Application Integration Architecture (AIA), so this Oracle SOA product suite will be discussed first.

Oracle's Application Integration Architecture (AIA) offers pre-built solutions at the data, process, and user interface level, delivering a complete process solution to business end users. All Oracle AIA components are designed to work together in a mix-and-match fashion and are built for easy configuration, ultimately lowering the cost and IT burden of building, extending, and maintaining integrations.

Oracle SOA Suite

The products included in this suite are: Oracle BPEL Process Manager, Oracle Human Workflow, Oracle Integration Adapters (Oracle SOA Adapters), Oracle Business Rules, Oracle Business Activity Monitoring, Oracle Complex Event Processing, Oracle Service Bus, Oracle B2B, Oracle Business Process Management (BPM), and Oracle Web Services Manager. These products can all be purchased together or separately.

Oracle Advanced Queuing

Message-based application and data integration is one of the oldest forms of integration used by companies. Message Orientated Middleware (also known as MOM) uses message queues and formatted messages to exchange information between applications or databases. MOM solutions such as those from Tibco, IBM, and Microsoft are well known in the market. Oracle Advanced Queuing (AQ) has been a component of the database since Oracle Database version 8.0.3, but is not as well known as other IT vendor solutions, since it is Oracle database-based and the main interface to AQ is PL/SQL. Oracle Advanced Queuing (AQ) provides database- integrated message queuing functionality. Oracle AQ leverages the Oracle database so that messages can be stored persistently, propagated between queues on different machines and databases, and transmitted using Oracle Net Services, HTTP(S), and SMTP.

Oracle AQ supports both point-to-point and publish-subscribe (topics) forms of messaging. A point-to-point message is aimed at a specific target. Senders and receivers decide on a common queue in which to exchange messages. Each message is consumed by only one receiver. A publish-subscribe message can be consumed by multiple receivers. Publish-subscribe messaging has a wide dissemination mode—broadcast, and a more narrowly aimed mode—multicast, also called point- to-multipoint.

Oracle Application Information Architecture

Just as the name implies, Application Integration Architecture, this solution from Oracle is not a product but an architecture. Due to it's architecture, the solution is a combination and integration of Oracle products to provide you with the holy grail of EII in a common architecture. The architecture consists of Oracle BPM and BPA, Oracle Service Bus, Oracle BPEL, Oracle B2B, and all of the Oracle technology and application SOA adapters.

The first step in building an AIA solution is to model your business processing environment using business process management and business process automation tools. Oracle provides products for Business Process Management (BPM) and Business Process Automation (BPA) through a pre-integrated portfolio of products that span modeling tools for business analysts, developer tools for system integration, business activity monitoring for dashboards, and user interaction for process participants.

The next step is to define and create all of your integration points. Oracle Integration B2B has built-in adapters for RosettaNet, EDI, ebXML, and low-level protocols like TCP/IP, HTTP, FTP, SOAP, MIME, SMTP, and more. This means trading partner IT infrastructure can be installed and configured in weeks, not months. Oracle SOA application and technology adapters, explained in the article Oracle Tools and Products, are used to integrate your own technologies and applications.

The last step is to 'wire' everything together within your AIA environment. Oracle Service Bus integrates with Oracle BPEL, Oracle BAM, and Oracle Fusion Middleware, while Oracle JDeveloper provides development capabilities for applications that use Oracle SCA facilities. Using Oracle JDeveloper, integrating applications becomes a drag-and-drop exercise using pre-packaged adapters for file, database, message queues, and COTS access. The AIA source and target data sources along with development languages and tools supported are:

Data source

Data target

Development languages and tools

Any data source

Any data source

GUI, SQL, Java, .NET

The most likely instances or use cases when AIA would be the Oracle product or tool selected are:

  • SOA application and data integration based upon a pre-built architecture blueprint and set of Oracle products
  • Future proofing your EII, EIS and EAI infrastructure

Oracle AIA is exactly that—an architecture. This means that it includes products that you use to build an application integration solution. The particular products you use depends on you. Oracle AIA is where Oracle is headed for its entire database, Fusion Middleware, and application products, so it is probably in your best interest to align yourself with this architecture.

Products matrix summary

We have discussed each product in detail and provided use cases to help guide you as you move towards a more current information integration architecture. Before we end this article, we believe that providing you with a matrix will help in your decision making.

Product

Data or App-centric

SQL, CLI or Java-based API

Data replication

Trans formations

DB or Fusion family

Initial data load capable

When to use

SQL Loader

Data

SQL, CLI

No

Yes

DB

Yes

Data migration

OWB

Data

SQL, PL/ SQL

Yes

Yes

DB

Yes

Data migration

Migration Workbench

Data

SQL, CLI

No

Yes

DB

Yes

Data migration

ODI

Data

SQL

Yes

Yes

Fusion

Yes

Data migration, Data integration

Performance and Tuning Packs

Data

SQL

n/a

n/a

DB

n/a

Data migration

GoldenGate

Data

CLI

Yes

Yes

Fusion

Yes

Data integration

CDC Adapters

Data

Java

Yes

No

Fusion

No

Data integration

MDM

Data

Java

Yes

Yes

DB

Yes

Information federation

Data Quality & Profiling

Data

Java

n/a

n/a

Fusion

n/a

Data migration, data integration, information federation

Gateways and HS

Data

SQL

No

Yes

DB

Yes

SQL based Information federation

OBI EE

Data

Java

No

No

Fusion

No

Presentation based information integration

SOA Adapters

Data and App

Java

No

Yes

Fusion

No

SOA integration, information integration

WebCenter Portals

Data and App

Java

No

No

Fusion

n/a

Presentation-focused information integration

BAM

Data and App

Java

No

No

Fusion

n/a

Presentation-focused information integration

ODI Suite

Data

SQL, Java

Yes

Yes

Fusion

Yes

Information integration, data migration, SOA integration, application integration

Exadata

Data

SQL, CLI

n/a

n/a

DB

n/a

Data consolidation

Coherence

App

Java

No

No

Fusion

n/a

In memory data grid

TimesTen

Data

SQL

No (Oracle-to-Oracle)

Yes

DB

Yes

In memory data grid

Exalogic

App

Java

n/a

n/a

Fusion

n/a

In memory data grid

ILM

Data

SQL, CLI

No

n/a

DB

n/a

Information integration, data archiving

Streams

Data

SQL, PL/ SQL

Yes

Yes

DB

No

Oracle-to- Oracle data migration and integration

Data Pump

Data

CLI

No

No

DB

Yes

Oracle-to- Oracle data migration and integration

External Tables

Data

SQL, PL/ SQL

No

Yes

DB

Yes

SQL-based data integration

Stream

Data

SQL, CLI

Yes

Yes

DB

No

Oracle-to- Oracle data migration and integration

SOA Suite

App and Data

Java

No

Yes

Fusion

No

Web services-based data and application integration

Oracle AQ

Data

SQL, PL/ SQL

No

No

DB

No

Message-based application integration, message-based data movement

AIA

App and Data

Java

No

Yes

Fusion

n/a

SOA and web services information integration

As this matrix shows, certain Oracle products are focused on a specific use case or task. You have options with products depending upon your developer's strengths: Java, PL/SQL, SQL, scripting using CLI, or even .NET. There is some overlap in the Oracle EII and data migration product offerings. However, even when there is overlap, one product has a strength that the other product does not have that makes it more appropriate for the problem you are solving. For example, there is overlap in OWB and ODI. OWB may be a great solution for building an Operational Data Store when your developers are PL/SQL gurus and your target database is Oracle. If your developers are Java and SQL proficient and your target ODS is Teradata, DB2, or some other RDBMS, then the solution for your ODS would be ODI, or perhaps ODI Suite.

Most companies are building a service-orientated information integration architecture. This is why using the components that are part of the Oracle Application Information Architecture (AIA) are important to start implementing an Enterprise Application Integration (EAI) solution. AIA is the strategic technology for enterprise integration and the integration platform for all Oracle Fusion Application products.

The real trick is in understanding business drivers, business requirements, and day-to-day information usage patterns. Once you have these, the previous matrix can make the decision much easier. Keep in mind that AIA is strategic to Oracle and Oracle business applications (Oracle PeopleSoft, Oracle E-Business Suite, Siebel, and more) that you probably use today in your company.

Products not covered

There are two sets of data-related content management—unstructured data products that were not covered in this article:

  • Oracle XMLType data type (a database feature)
  • Oracle Content Management

This database feature and Oracle product suite were not covered as this article focuses on relational database information integration and data migration. Certainly, the Oracle XMLType data type can be used to consolidate and manage XML formatted documents. Oracle's Enterprise Content Management (ECM) Suite, mostly acquired from Stellent, is a best-of-breed ECM solutions encompass Document and Records Management, Web Content Management, Digital Asset Management, Imaging and Business Process Management, Information Rights Management, and Risk and Compliance. However, the Oracle ECM product line also does not fall into traditional relational databases-based integration or migration.

Summary

Oracle has come a long way since it was a database-centric data integration company. Many of the newest solutions were acquired. Oracle has not only moved more towards a middle tier model, but also to a heterogeneous offering. The cause for this move may have been the heterogeneous technologies Oracle acquired (GoldenGate, Collaxa/Oracle BPEL), COTS acquisitions (JDEdwards legacy version only runs on DB2 iSeries) or recognition by Oracle that not everyone is on an Oracle database. Whatever the cause, Oracle has now embraced heterogeneous information integration.


Further resources on this subject:


Oracle Information Integration, Migration, and Consolidation The definitive book and eBook guide to Oracle Information Integration and Migration in a heterogeneous world
Published: September 2011
eBook Price: $32.99
Book Price: $54.99
See more
Select your format and quantity:

About the Author :


Tom Laszewski

Tom Laszewski has over 20 years of experience in databases, middleware, software development, management, and building strong technical partnerships. He is currently the Cloud Migration Director in Oracle's Server Technology organization. He established the initial business and technical relationships with Oracle's migration SIS and tools partners. His main responsibility is successful completion of migration projects initiated through the Oracle partner ecosystem and Oracle Sales. These migration projects involve mainframe service enablement and integration, mainframe re-host and re-architecture, and Sybase, DB2, SQL Server, Informix database migrations, and migrations to the Oracle Cloud product offerings. Tom works on a daily basis with TCS, Infosys, and niche migration systems integrators, customer technical architectures, CTOs and CIOs, and Oracle account managers to ensure the success of migration projects. Most recently, Tom is spending a significant amount of his time enabling Cloud computing service providers on the Oracle software and hardware stack. This involves architecting future-proof cloud infrastructure solutions utilizing Oracle Exadata, Oracle Exalogic, Oracle Virtual Server, Sun Blade Servers, Oracle Database, Oracle Fusion Middleware, and Oracle Enterprise Linux.

Before Oracle, Tom held technical and project management positions at Sybase and EDS. He has provided strategic and technical advice to several start-up companies in the Database, Blade, XML, and storage areas. Tom holds a Master of Science in Computer Information Systems from Boston University.

Books From Packt


Oracle Warehouse Builder 11g R2: Getting Started 2011
Oracle Warehouse Builder 11g R2: Getting Started 2011

Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting
Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting

Oracle Database 11g – Underground Advice for Database Administrators
Oracle Database 11g – Underground Advice for Database Administrators

EJB 3.0 Database Persistence with Oracle Fusion Middleware 11g
EJB 3.0 Database Persistence with Oracle Fusion Middleware 11g

Oracle ADF Enterprise Application Development—Made Simple
Oracle ADF Enterprise Application Development
—Made Simple

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation
Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

Oracle Enterprise Manager Grid Control 11g R1: Business Service Management
Oracle Enterprise Manager Grid Control 11g R1: Business Service Management

Oracle GoldenGate 11g Implementer's guide
Oracle GoldenGate 11g Implementer's guide

No votes yet

Post new comment

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
g
n
u
5
a
c
Enter the code without spaces and pay attention to upper/lower case.
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software