Wednesday Oct 01, 2014

Data Integration At OOW14 -Recapping days 1,2 and 3

It has been an action packed three days here in San Francisco at the Oracle Open World 2014 event for Data Integration.

Day 1

It all started with the keynote presentations by the executives stressing Oracle's focus around Cloud, Big Data and Mobile developments. Thomas Kurien's session addressed Data Integration's key role in binding the applications, moving data and simplifying access to Big Data.

Jeff Pollock, in his session "Unlocking Big Data Silos in the Cloud" then addressed the various customer best practices and architectural considerations to implement a full or partial cloud based business solution and how Oracle Data Integration products fit in. An interesting real life example was that of the UK Conservatory using Oracle Data Integration in the cloud.

 Product update sessions for the Oracle Data Integrator and Oracle GoldenGate revealed how much of the upcoming releases focus on not  just integrating the products and covering for heterogeneous data source compatibility but also on cloud and Big Data features. Customer testimonials from various well known brands like DirectTV, Canon and LinkedIn further cemented Oracle Data Integration Solution's success.

 Day 2

The highlight of the day was the Fusion Middleware Innovation Awards, awarded to the most innovative use of Oracle technology to solve business needs that can be showcased as best practices to be emulated by customers in the industry. Net Servicos de Communicacao from Brazil and Griffith University from Australia walked away with the awards for the Data Integration category.

Day 2 also saw product updates with Data Quality and how Oracle is now extending its capabilities considerably into the metadata management space to help govern and bring transparency to data within the organization. Enterprise Metadata Management was an area that was of particular interest (a demonstration of which, in the product booth has been always packed with eager visitors).

 Day 3

Oracle Data Integration is one of four pillars key to Oracle's Big Data Strategy stressed Senior Vice president Balaji Yelamanchili. Building on the concept of Data Reservoir, the session "Tapping into the Big Data Reservoir with all Data" explored how it is fully supported by Oracle with Oracle GoldenGate providing real time incremental feed into the reservoir and Oracle Data Integrator doing the data transformations within the reservoir.

The Big Data Lite page offers a great environment that can be downloaded and explored to see all these concepts and technologies in action.

Day 4 is packed with sessions about Cloud Data Integration, Metadata Management, Achieving Zero Downtime migrations and a host of other insightful sessions. Check out the full list here to plan accordingly.


Streaming Relational Transactions to Flume using Oracle GoldenGate

In prior articles, we have introduced architectures for streaming transactions from Oracle GoldenGate to HDFS, Hive, and HBase. In this article we are adding to this list by presenting a solution for streaming transactions into the Flume service. 

Apache Flume is a distributed, fault tolerant, and available service for efficiently collecting, aggregating, and moving large amounts of streaming data into HDFS. It can be configured into a variety of distribution mechanisms, such as delivery to multiple clusters, or rolling of HDFS files based on time or size. 

As shown in the diagram below, streaming database transactions to Flume is accomplished by developing a custom handler using Oracle GoldenGate's Java API and Flume's Avro RPC APIs.

The custom handler is deployed as an integral part of the Oracle GoldenGate Pump process.   The Pump process and the custom adapter are configured through the Pump parameter file and custom adapter's properties file. The Pump process executes the adapter in its address space. The Pump reads the Trail File created by the Oracle GoldenGate Capture process and passes the transactions to the adapter. The adapter then writes the transactions to a Flume Avro RPC source at the given host/port defined in the configuration file. The Flume Agent streams the data to the final destination; in the supplied example Flume writes into an HDFS directory for subsequent consumption by Hive. 

A sample implementation of the Flume Adapter for Oracle GoldenGate is provided at the My Oracle Support site as Knowledge Base article 1926867.1

Are you at Oracle OpenWorld?

The week isn’t over just yet!

Oracle Data Integration has nine pods located throughout Moscone South where you can meet the product management and development teams. You will find us in the Fusion Middleware, Database, Application and Big Data areas this year.

For additional details on the Oracle Data Integration Solutions track at OpenWorld, make sure to check us out!  There are still many more sessions to attend before the end of the conference!

Friday Sep 26, 2014

Oracle GoldenGate and Oracle Data Integrator on the Oracle BigDataLite 4.0 Virtual Machine

Oracle's big data team has just announced the Oracle BigDataLite Virtual Machine 4.0, a pre-built environment to get you started on an environment reflecting the core software of Oracle's Big Data Appliance 4.0. BigDataLite is a VirtualBox VM that contains a fully configured Cloudera Hadoop distribution CDH 5.1.2, Oracle DB 12.1.0.2.0 with Big Data SQL, Oracle's Big Data Connectors, Oracle Data Integrator 12.1.3, Oracle GoldenGate, and other software.

The demos for Oracle GoldenGate and Oracle Data Integrator show an end-to-end use case of the fictional Oracle MoviePlex on-line movie streaming company. It shows how to load data into a Data Reservoir in real-time, process and transform the data using the power of Hadoop, and utilize the data on an Oracle data warehouse, either by loading the data with Oracle Loader for Hadoop or by using Hive tables within Oracle SQL queries with Oracle Big Data SQL. 

Please follow the demo instructions to try out all these steps yourself. If you would like to build the ODI mappings from scratch, try our ODI and Big Data Hands-on Lab.  Enjoy! 

Data Quality, Data Governance & Metadata Management @OOW14

As you pack our bags for the Open world this year, the importance of Data Quality and Data Governance has only increased with the addition of Big Data and Cloud technologies. This Open World includes sessions that range from dealing with traditional on premise standardization and cleansing of data to understanding how managing your enterprise metadata increases your ability to understand data provenance. Also meet with customers, partners and product experts who have built a complete data management platform that includes not just data movement, but have implemented data quality and data governance enterprise data initiatives and the benefits that accrue from them.

Here are some hot Data Quality and Data Governance Sessions

Data Quality Maturity Journey: Building Toward Strong Enterprise Data Quality [CON7776]

Oracle Enterprise Data Quality: Product Overview and Roadmap [CON7780]

The Essential Core of Data Governance with Oracle Enterprise Data Quality [CON7775]

Oracle Enterprise Data Quality Introduction [HOL9438]

Demos:

Oracle Data Integrator, Oracle GoldenGate, and Oracle Enterprise Data Quality

Trusted Data with Oracle Enterprise Data Quality Solutions

Metadata Management Sessions:

Oracle Data Integration and Metadata Management for the Seamless Enterprise [CON7923]

Demo: Oracle Enterprise Metadata Management: Trust Your Data

We will keep bringing you regular updates on the happenings from OpenWorld. Meanwhile you can see all the Data Integration related sessions right here.

Thursday Sep 25, 2014

ODI 12c - Migration from OWB to ODI - PLSQL Procedures Pt 2

In the first part of this blog post I showed you how PLSQL procedures could be invoked from ODI and help you benefit from supporting such functionality in the tool and increasing performance. Here in part 2, I'll show how the map can be changed in OWB and subsequently migrated using the migration utility.

Remember the original mapping design in OWB used a transformation operator to invoke the PLSQL procedure, the same mapping can be modified by replacing that transformation component with a construct operator to build the ref cursor and also a table function operator, see below for the original map design at the top and the modified one below with the ref cursor and table function;


The mapping can be configured to be further optimized by specifying extraction and loading hints in order to tune performance for your system;


You will have to enable the parallel DML capabilities for the OWB mapping also. With this design you can test/ensure it works and then use it in a migration. Why go through all this? You may want to try and optimize existing mappings in OWB, or when migration your map may be more complex and you do not wish to reconstruct it (perhaps the mapping is large and complex upstream from the PLSQL procedure). Doing this will save that work, you need to remove the PLSQL procedure plus target attribute mappings and insert the cursor and table function.

When the migration utility migrates this, it will migrate the entire logical design and also the hints you have specified. You will see the following mapping in ODI;

You will have to add the enable parallel DML code into the begin mapping command and then the code will be equivalent and performing as such. For details of the OWB to ODI migration utility see here, it's also worth checking various other useful resources such as the migration in action demo here and Stewart Bryson's 'Making the Move from Oracle Warehouse Builder to Oracle Data Integrator 12c' article here (useful tip on database link mechanics in ODI).

ODI 12c - Migrating from OWB to ODI - PLSQL Procedures

The OWB to ODI migration utility does a lot, but there are a few things it doesn't handle today. Here's one for our OWB customers moving to ODI who are scratching their heads on the apparent lack of support for PLSQL procedures in ODI... With a little creative work you can not only get those mappings into ODI but there is potential to dramatically improve performance (my test below improves performance by 400% and can be easily further tuned based on hardware).

This specific illustration will cover the support for PLSQL procedures (not functions) in OWB and what to do in ODI, OWB takes care of invoking PLSQL procedures mid-flow - it did this by supporting PLSQL row-based code for certain (not all) map designs out of the box - PLSQL procedure invocation was one case this was done. The PLSQL that OWB generated was pretty much as efficient as it could have been for PLSQL (used bulk collect and many other best practices you didn't have to worry about as a map designer) but it was limited in the logical map support (couldn't have a set-based operator such as join after a row based only operator such as a PLSQL transformation) - it was also PLSQL not SQL.

Here we see how with a simple pipelined, parallel enabled table function wrapper around your PLSQL procedure call, how you capture the same design in ODI 12c and/or get the mapping migrated from OWB. I think the primary hurdle customers have is what is the option going forward. To solve this, we will just leverage more of the Oracle database; table functions and parallelize the <insert your favorite word> out of it!

The mapping below calls a PLSQL procedure and OWB generated PLSQL row based code for this case, the target is getting loaded with data from the source table and the 2 output parameters of the PLSQL procedure;

When you try and migrate such a mapping using the OWB to ODI migration utility, you'll get a message indicating that the map cannot be migrated using the utility. Let's see what we can do! The vast majority of mappings are set-based, generally a very small subset are row based PLSQL mappings. Let's see how this is achieved in ODI 12c.

I did a test using the generated code from OWB - no tuning just the raw code for the above mapping - it took ">">">12 minutes 32 seconds to process about 32 million rows and invoke the PLSQL procedure and perform a direct path insert into the target. With my ODI 12c design using a very simple table function wrapper around the PLSQL procedure I can cut the time to 3 minutes 14 seconds!! Not only can I do this, but I can easily further optimize it to better leverage the Oracle database server by quickly changing the hints - I had a 4 processor machine, so that's about as much as I could squeeze out of it.

Here is my map design in ODI 12c;

The table function wrapper to call the PLSQL procedure is very simple, line 7 is where I call the PLSQL procedure, I use the object instance in the call and pipe the data when the call is made;

  1. create or replace function TF_CALL_PROC(input_values sys_refcursor) return TB_I_OBJ pipelined parallel_enable(PARTITION input_values BY ANY) AS
  2.   out_pipe i_obj := i_obj(null,null,null,null,null,null,null,null,null);
  3. BEGIN
  4.   LOOP
  5.     FETCH input_values INTO out_pipe.prod_id, out_pipe.cust_id,out_pipe.time_id,out_pipe.channel_id,out_pipe.promo_id,out_pipe.quantity_sold,out_pipe.amount_sold;
  6.     EXIT WHEN input_values%NOTFOUND;
  7.     MYPROC(out_pipe.prod_id,out_pipe.status,out_pipe.info);
  8.     PIPE ROW(out_pipe);
  9.   END LOOP;
  10.   CLOSE input_values;
  11.   RETURN;
  12. END;

This is a very simple table function (with enough metadata you could generate it), it uses table function pipelining and parallel capabilities - I will be able to parallelize all aspects the generated statement and really leverage the Oracle database. The above table function uses the types below, it has to project all of the data used downstream - whereas OWB computed this, you will have to do that.

  1. create or replace type I_OBJ as object (
  2.  prod_id number,
  3.  cust_id number,
  4.  time_id date,
  5.  channel_id number, 
  6.  promo_id number,
  7.  quantity_sold number(10,2),
  8.  amount_sold number(10,2),
  9.  status varchar2(10),
  10.  info number
  11.   );
  12. create or replace type TB_I_OBJ as table of I_OBJ; 

The physical design in ODI has the PARALLEL(4) hints on my source and target and I enable parallel DML using the begin mapping command within the physical design.

You can see in above image when using Oracle KMs there are options for hints on sources and targets, you can easily set these to take advantage of the hardware resources, tweak these to pump the performance throughput!

To summarize, you can see how we can leverage the database to really speed the process up (remember the 400%!), also we can still capture the design in ODI and on top of that unlike in OWB, this approach let's us carry on doing arbitrary data flow transformations after the table function component which is invoking our PLSQL procedure - so we could join, lookup etc. Let me know what you think of this, I'm a huge fan of table functions I think they afford a great extensibility capability.  

Tuesday Sep 23, 2014

Data Integration - Hands On labs, Demos and Awards at OOW14

 Posted for Doug Reid

We are just days away from the start of Oracle OpenWorld 2014. The Data Integration team has a solid line-up of product and customer sessions for you to attend this year, plus five hands-on labs, and numerous demonstration pods in Moscone South.

On Monday we kick the track off with Jeff Pollock’s “Unlocking Big Data Silos in the Enterprise or the Cloud” at 10:15AM in Moscone South 304. In this session Jeff will discuss how Oracle Data Integration removes data silos and seamlessly enables the adoption of big technologies and hybrid cloud environments. Over the rest of the week we have a number of deep dive sessions that build out the themes that Jeff discusses in his keynote. Jeff will also be presenting “Tapping into the Big Data Reservoir with All Data” on Wednesday at 3:30PM in Moscone West 3022.

Monday is also when the team will provide product updates on our latest releases of Oracle Data Integrator and Oracle GoldenGate. Here are the session details:

  • · Oracle GoldenGate 12c New Features and Options Product Update - 2:45PM Moscone South 302
  • · Oracle Data Integrator: Product Update and Future Strategy - 4:00PM Moscone South 270

 On Tuesday morning, the team will provide an update on Oracle Enterprise Data Quality at 10:45AM in Moscone South 236.

 There are so many great session on our track this year, but I would like to highlight these:

  • · Oracle GoldenGate and the Cloud – Tuesday 12PM Moscone South 302
  • · Making the Move from Oracle Warehouse Building to Oracle Data Integrator – Tuesday 5PM Moscone South 236
  • · The Essential Core of Data Governance with Oracle Enterprise Data Quality – Wednesday 2PM Moscone West 3022.
  • · Solving Big Data’s Big Problem with Data Preparation and Enrichment in the Cloud – Thursday 12PM Moscone South 270.

 Other key events to keep on your schedule are:

 Oracle Fusion Middleware Innovation Awards – Tuesday 5PM YBCA Theater

International Oracle GoldenGate User group (Birds of a Feather) Meeting – 6PM Moscone South 301

For our hands-on labs this year, we will be located in the Hotel Nikko located at 222 Mason Street. All of the labs this year for the Data Integration track will be held in the Nikko Ballroom II. This year we have five labs for the DIS track, these are:

  • · Oracle GoldenGate 12c New Features Deep Dive
  • · Oracle GoldenGate 12c Heterogeneous Replication
  • · Oracle Data Integrator 12c New Features Deep Dive
  • · Oracle Data Integrator for Big Data
  • · Oracle Enterprise Data Quality Introduction
Plus Oracle GoldenGate is showcased with Oracle Coherence in the Hands-on Lab “Pushing Database Transactions to JCache with Oracle Coherence and Oracle GoldenGate”. Make sure to register early as all of the labs tend to fill-p prior to the start of OpenWorld.

In terms of demo pods this year, we have nine pods located throughout Moscone south where you can meet the product management and development teams. As Oracle Data Integration Solutions is pervasive in the Oracle stack so are our demo pods at OpenWorld, you will find us in the Fusion Middleware, Database, Application and Big Data areas this year.

For additional details on the Oracle Data Integration Solutions track at OpenWorld, make sure to check out the focus-on document. Click here to view

Keep tuned to our blog during the show for news and highlights from the Data Integration Solutions team. See you there.

Sunday Sep 21, 2014

Big Data Integration At Oracle Open World 2014

Big Data takes central stage at this Open World. And no matter what part of your organization you are in, this open world has sessions that speak to your Big Data needs. Which is why we, at Oracle Data Integration have listed the most exciting sessions to help you narrow down and plan your conference. Hear customer panels discuss how they innovate using Big Data Integration, Data Scientists demystify their art and how Oracle Data Integration helps everyone by simplifying access to Big Data and introducing real time capabilities to Big Data. We look forward to this opportunity to meet with you and help you convert Big Data opportunities into practice.

Here are some of the sessions that come highly recommended.

Oracle Big Data: Strategy and Roadmap [CON8276]

Unlocking Big Data Silos in the Enterprise or the Cloud [CON7877]

Oracle Data Integrator: Product Update and Future Strategy [CON7899]

Enabling Real-Time Data Integration with Big Data [CON7719]

Tapping into the Big Data Reservoir with All Data [CON7934]

Tame Big Data with Oracle Data Integration [CON7922]

User Group: Beyond Data Integration with Oracle Data Integrator 12c and Oracle GoldenGate 12c [SIG8709]

Deep Dive into Big Data ETL with Oracle Data Integrator 12c and Oracle Big Data Connectors [UGF9481]

Big Data 101 and the Oracle Big Data Solution [CON4231]


Use the schedule builder to make sure you take full advantage and plan your conference in advance so that you don’t miss on any of the Big Data Integration action at this Open World. See you there.

Wednesday Sep 17, 2014

Cloud Data Integration Sessions at Oracle OpenWorld

It’s almost time for Oracle OpenWorld and I would like to give you a sneak peek into some of the cloud data integration sessions we are hosting this year.

On Tuesday September 30th we will start with ‘Oracle GoldenGate and the Cloud [CON7774]’. Chai Pydimukkala and Pawan Kumar Kumar will be discussing how Oracle GoldenGate can run in the cloud and be used in the Oracle Cloud.

To learn more about it join us for this session:
Oracle GoldenGate and the Cloud - CON7774
09/30/14 (Tuesday) 12:00 PM - Moscone South - 302

Then on Thursday September 2nd I will have the pleasure to co-present ‘Oracle Data Integration: A Crucial Ingredient for Cloud Integration [CON7926]’ with Sumit Sarkar from Progress DataDirect. In this session we will be explaining how the Oracle Data Integration solutions help businesses integrate with cloud resources such as cloud databases and applications or cloud BI infrastructures. We will cover topics like initializing and synchronizing Oracle DBaaS or performing native E-LT transformations on a cloud data warehousing platform.

We are also very excited to be doing 2 live demonstrations in this session using Oracle Data Integrator and the Progress DataDirect JDBC drivers: extracting data from Salesforce.com as well as integrating and transforming data on Amazon Redshift.

If you are interested in cloud integration make sure you attend this session:
Oracle Data Integration: A Crucial Ingredient for Cloud Integration - CON7926

10/2/14 (Thursday) 9:30 AM - Moscone South - 270

Of course there are also plenty of other Oracle Data Integration sessions you should plan on attending at Oracle OpenWorld this year. For a complete list review our Focus On Data Integration website. See you there!

Monday Sep 15, 2014

You are invited! See the Power of Innovation with Oracle Fusion Middleware

Are you going to be at Oracle OpenWorld? If so, don't miss the opportunity to meet the most innovative Oracle Fusion Middleware projects of 2014. Winners of 2014 Oracle Excellence Awards for Fusion Middleware Innovation will be announced in a special Awards Ceremony on Tuesday September 30th during Oracle OpenWorld.

Oracle Fusion Middleware Innovation Awards honor customers with cutting-edge use of Oracle Fusion Middleware technologies to solve unique business challenges or create business value. Winners are selected based on the uniqueness of their business case, business benefits, level of impact relative to the size of the organization, complexity and magnitude of implementation, and the originality of architecture. Data Integration is among the 9 award categories recognized this year, along with Oracle Exalogic Elastic Cloud, Oracle Cloud Application Foundation, Oracle Service Oriented Architecture, Oracle Business Process Management, Oracle WebCenter, Oracle Identity Management, Oracle Development Tools and Framework, and Big Data and Business Analytics.

If you are planning to attend Oracle OpenWorld in San Francisco or plan to be in the area during Oracle OpenWorld, we hope you can join us, and bring back to your organization real-life examples of Fusion Middleware in action.

   Oracle Excellence Awards Ceremony: Oracle Fusion Middleware: Meet This Year’s Most Impressive Innovators(Session ID: CON7029)

   When: Tuesday September 30, 2014

   Time: Champagne Reception 4:30 pm, Ceremony 5-5:45 pm PT

   Where: Yerba Buena Center for the Arts, YBCA Theater (next to Moscone North) 700 Howard St., San Francisco, CA, 94103


To learn more about last year’s Data Integration winners please read our blog post: 2013 Oracle Excellence Awards for Fusion Middleware Innovation… and the Winners for Data Integration are…

To attend this Award Ceremony, Oracle OpenWorld Badges are required. You can register for this session through the Schedule Builder on the Oracle OpenWorld website. If you are not attending the conference, but will be in the area and would like to join the celebration – please contact us here.

We hope to see you there!

Sunday Sep 14, 2014

Make Data Work at Oracle Open World 2014- Focus on DIS

The single most important thing you can do for your IT roadmap this year is attend Oracle Open World 2014. And to make the best use of your time while at Open World, plan ahead! You can tailor your agenda based on the the Oracle Data Integration Solution Focus On. This will give you a golden opportunity to nail your IT strategy - you can network with experts, get your hands dirty exploring the new Oracle Data Integrator, Oracle Golden Gate features and Oracle Enterprise Data Quality products and understand how to capitalize on every new wave of innovation: mobile, cloud, social, big data, fast data, and internet of things.  

Here are some sessions that are on my radar at this Open World 2014:

A Modern Business Demands a Modern Cloud Platform [GEN8589] - by Thomas Kurian

Unlocking Big Data Silos in the Enterprise or the Cloud [CON7877]

Oracle Data Integrator: Product Update and Future Strategy [CON7899]

Enabling Real-Time Data Integration with Big Data [CON7719]

Oracle Enterprise Data Quality: Product Overview and Roadmap [CON7780]

The Essential Core of Data Governance with Oracle Enterprise Data Quality [CON7775]

Tapping into the Big Data Reservoir with All Data [CON7934]

Oracle Data Integration: A Crucial Ingredient for Cloud Integration [CON7926]

Oracle Data Integration and Metadata Management for the Seamless Enterprise [CON7923]

Oracle GoldenGate 12c New Features and Options Product Update [CON7717]

Making the Move from Oracle Warehouse Builder to Oracle Data Integrator [CON7920]

Oracle Fusion Middleware: Meet This Year’s Most Impressive Innovators [CON7029]

This is one conference you don't want to miss. The weather will be gorgeous, the sessions loaded with information to help you succeed, and you get to network with the brightest minds in the valley. Get your comfortable shoes on, and head over to San Francisco. Register today! Oracle Open World 2014 Registration and Focus On Data Integration.

Tuesday Sep 09, 2014

ODI 12c - Models in Data Modeler and ODI

Ever wondered how to get your models from Oracle SQL Developer Data Modeler (SDDM) in to ODI data models? The most common practice is to generate and execute the physical DDL scripts from SDDM to the target database. Another technique is possible leveraging the ODI SDK and the SDDM SDK - that's what I will illustrate here. There is an example script posted here on the java.net site.

There is an end to end demo viewlet below to see the script in action, check it out;

https://blogs.oracle.com/dataintegration/resource/viewlets/odi_models_from_sddm_viewlet_swf.html

The viewlet shows the transformation script in action creating the ODI model from the Data Modeler design, here's a peek at the script in action;

In the viewlet you will see how I added the groovy scripting engine as an engine for SDDM - I can then leverage my groovy skills and the ODI SDK to build the script and provide useful capabilities.

This script is publicly available at link above, take, enhance and comment! Join the communities on LinkedIn for Oracle Data Integration and the OTN forum to learn and exhange with other members of the community.

Monday Sep 08, 2014

Big Data Reservoirs: Getting from Big Data to Valuable Data

Big data’s potential has been widely exclaimed. But many organizations are challenged by the need to collect, store, and analyze the ever-growing amounts and varieties of data that constitute big data.

Big data reservoirs—large holding areas where all kinds of data can be stored and analyzed—are a logical first step in building a next-generation information architecture. In the world of big data, we don’t often know what the value of the data will be. A big data reservoir allows for ad hoc discovery, organization, and enrichment of this data before it traverses to more refined sets of analytics tools.

Because the data volumes are large and the variety of data types unpredictable, big data reservoirs have to be cost-effective and flexible. Not surprisingly, Hadoop and NoSQL databases are the preferred choices for creating big data reservoirs.

But moving data from a big data reservoir into actionable systems requires complex manipulation, comparison, and real-time updates to keep data accurate and systems in synch. Oracle Data Integrator fulfills the critical need of performing complex data manipulations and moving data in and out of big data reservoirs. The latest release, Oracle Data Integrator 12.1.3, is replete with new features designed specifically for the challenges of handling big data. And Oracle GoldenGate works in perfect harmony with Oracle Data Integrator to keep data reservoirs updated with the latest real-time information.

Oracle Data Integrator also delivers leading capabilities for dealing with yet another big data challenge: heterogeneous data. Big data comes in many different forms, from transactional data to social media logs and more, and Oracle Data Integrator can handle all of it. Oracle Data Integrator is the standard for extract, load, and transform operations for Oracle Applications. And it now supports data loading from relational databases into Apache Hadoop Distributed File System (HDFS), Hive, and HBase environments, and from HDFS and Hive into relational databases. In addition, Oracle Data Integrator now supports JavaScript Object Notation and can use Sqoop to integrate Hadoop from non-Hadoop or relational data.

Register for the upcoming Oracle webcast to learn more about best practices using big data reservoirs to unlock the value in your enterprise big data.

Thursday Sep 04, 2014

Oracle GoldenGate is Certified on IBM z/OS 2.1

Starting in Oracle GoldenGate 11.2.1.0.23, Oracle GoldenGate for DB2 z/OS is certified on z/OS 2.1. For more information about Oracle GoldenGate for DB2 z/OS, please refer to the following documentation:

To run on z/OS 2.1, the minimum version of Oracle GoldenGate patch release is as follows:

  • 11.2..1.0.23 18794269 ORACLE GOLDENGATE V11.2.1.0.23 FOR IBM DB2 9.1 ON Z/OS (Patch)


About

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

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today