Tuesday May 24, 2016

Oracle GoldenGate for Big Data 12.2.0.1.1 update is available now!

Oracle GoldenGate for Big Data 12.2.0.1.1 update is available

I am pleased to announce the general availability of Oracle GoldenGate for Big Data 12.2.0.1.1.



What’s new in Oracle GoldenGate for Big Data 12.2.0.1.1 ?

  • New Formats – Avro OCF and Sequence File
Oracle GoldenGate for Big Data can now write data in Avro Object Container Format (OCF) and HDFS Sequence File format.

  • Automatic Metadata / DDL updates to Hadoop.
Oracle GoldenGate for Big Data can now automatically provide DDL updates to Hive/HCatalog. Oracle GoldenGate for Big Data can also automatically provide the versioned schema files to HDFS directories as well.

  • Data Conversion – Hex Encoding and Character replacements
You will now be able to deliver your CDC data in hex encoding format in addition to base24 format. Oracle GoldenGate for Big Data will be able to find and replace using regular expressions. You can now include primary key in JSON format. Oracle GoldenGate for Big Data can convert time-stamp to ISO8601 format. .

  • Security Improvements – Oracle Wallet Integration and Kafka SSL
Oracle GoldenGate for Big Data can now integrate with Oracle Wallet. Kafka integration now provides integration with Kafka SSL which is available from Kafka 0.9.x.
  • Kafka Multiple Topic support
Oracle GoldenGate for Big Data can now automatically create target topics based on the source tables, if you would like to segregate the data from one table to a topic.
  • · Newer Certifications and many more !!!

Note: The 12.2.0.1.1 installer is available as an update installer for 12.2.0.1.0. So please look carefully for the update release file which contains the description with 12.2.0.1.1 release version.

More information on Oracle GoldenGate 12.2.0.1.1

Friday May 20, 2016

Using Oracle Data Integrator (ODI) for Loading to Oracle Cloud’s Human Capital Management (HCM)

The A-Team is on a roll…

To load data into Oracle Cloud’s Human Capital Management (HCM) with Oracle Data Integrator (ODI) – check out the following blog:

Oracle Data Integrator (ODI) for HCM-Cloud: a Knowledge Module to Generate HCM Import Files

HCM is unique in that it uses a dedicated file format that contains both metadata and data. As far as the data is concerned, the complete hierarchy of parent and children records must be respected for the file content to be valid. This article explores a new Integration Knowledge Module (KM). This KM allows us to leverage ODI to prepare the data and generate the import file. Then, traditional Web Services connections can be leveraged to load into HCM.

Monday May 16, 2016

More About Using and Connecting ODI to the Cloud!

More about ODI and the Cloud from the A-Team. Thanks Christophe!

This article covers connecting Oracle Data Integrator (ODI) to the Cloud – with details about web services and security policies. This has all been made simple with ODI 12.2.1 – just follow the simple configuration steps and off you go.

Connecting Oracle Data Integrator (ODI) to the Cloud: Web Services and Security Policies

Happy reading!

Thursday May 12, 2016

Looking for Cutting-Edge Data Integration & Governance Solutions: Nominate NOW for the 2016 Excellence Awards

It is nomination time!!!

This year's Oracle Cloud Platform Innovation – Excellence Awards will honor customers and partners who are creatively using Oracle products. Think you have something unique and innovative with Oracle Data Integration & Governance products?

We'd love to hear from you! Please submit today in the Data Integration & Governance category. This year’s nomination process is a little bit different in the sense that the forms are fully online.

The deadline for the nomination is Monday, June 20, 2016. Win a free pass to Oracle OpenWorld 2016!

Let’s reminisce a little…

For details on the 2015 Big Data, Business Analytics, and Data Integration Winners: amazon.com, Caixa Bank, Serta Simmons Bedding, Skanska, Scottish & Southern Energy and Tampa International Airport, check out this blog post.

For details on the 2014 Data Integration Winners: NET Serviços and Griffith University, check out this blog post.

For details on the 2013 Data Integration Winners: Royal Bank of Scotland’s Market and International Banking and The Yalumba Wine Company, check out this blog post.

For details on the 2012 Data Integration Winners: Raymond James Financial and Morrisons Supermarkets, check out this blog post.

We hope to honor you!

Click here to submit your nomination today – scroll to the bottom of the page and select the appropriate category. And just a reminder: the deadline to submit a nomination is 5pm Pacific Time on June 20th, 2016.


Tuesday May 03, 2016

Loading Amazon Redshift with Oracle GoldenGate

Organizations deploy Oracle GoldenGate to replicate data between heterogeneous databases for both on-premise and public cloud environments. Check out some interesting articles about how to load Amazon Redshift with Oracle GoldenGate from Eddie Ho.  This is a two part series where part one provides a high level solution overview. Part two provides the actual details of a sample implementation. Happy reading!

Part 1 of 2

How to load Amazon Redshift by micro batches with Oracle GoldenGate - Part 1/2 (Overview)

Part 2 of 2

How to load Amazon Redshift by micro batches with Oracle GoldenGate - Part 2/2 (Deep Dive/Design Details)

Wednesday Apr 27, 2016

Call for Proposals for Oracle Open World 2016

The open period to submit your proposals for the upcoming Oracle Open World 2016 is here. 

The open period ends on Monday, May 9, 11:59 p.m. PDT.

If you have a great story about how you use Oracle's Data Integration products this is the best time to highlight your innovation to fellow practitioners, industry leaders and Oracle experts.

This site provides all the details around submissions.

We look forward to hearing from you.


Thursday Apr 21, 2016

Oracle GoldenGate for DB2 for i 12.2.1.0.2 Release is Available

Oracle GoldenGate for DB2 i 12.2.0.1.2 was released on 4/15/2016. You now can download the software from OTN and eDelivery.[Read More]

Oracle GoldenGate for DB2 z/OS 12.2.1.0.2 Release is Available

Oracle GoldenGate for DB2 z/OS  12.2.0.1.2 was released on 4/15/2016. You now can download the software from OTN and eDelivery. [Read More]

Sunday Apr 17, 2016

Oracle GoldenGate Adapter for ElasticSearch

Oracle GoldenGate can now integrate with ElasticSearch using the GoldenGate Adapter for ElasticSearch. GoldenGate Adapter for ElasticSearch can run on the latest Java based Replicat available with Oracle GoldenGate for Big Data 12.2. It uses high performance native Java driver to ElasticSearch. It can handle automatic DDL replication and supports inserts, updates and deletes into ElasticSearch. 

This project has converted to an open-source project for increased contribution from the Java community. The downloadable bundle contains source code, binary (jar) files, sample configuration files and instructions to use (readme.txt). You can download the bundle from URL https://java.net/projects/oracledi/downloads/directory/GoldenGate/Oracle%20GoldenGate%20Adapter%20for%20ElasticSearch

 

Compatibility Matrix:

  • GoldenGate for Big Data: 12.2.0.1.0 (All platforms)
  • ElasticSearch Server : 2.0.0 and above
  • ElasticSearch Java Driver: 2.2.1

Tuesday Apr 05, 2016

How to load data from Excel using ODI 12.2.1 and Progress DataDirect SequeLink

Author: Octavio Oliveira

Background

There is often a need to read data from Excel spreadsheets and integrate it with different target technologies in Data Integration projects. The challenge is that MS Excel only supports ODBC connectivity whereas Oracle Data Integrator (ODI) and many other tools only support JDBC connectivity natively. This is where the Sun JDBC-ODBC Bridge packaged with Sun Java Development Kit (JDK) proved very useful to make the bridge between ODBC and JDBCS. However, starting with JDK 1.8 (required for ODI 12.2.1) the Sun JDBC-ODBC Bridge has been deprecated.

Luckily there are many third-party JDBC-ODBC bridges out there that can be used with ODI. In this blog post we will be using a solution provided by Progress DataDirect named SequeLink (https://www.progress.com/connectors/sequelink).

[Read More]

Monday Mar 28, 2016

Leveraging Oracle Data Integrator (ODI) with the Amazon Elastic MapReduce (EMR) Cloud Service

Another interesting article from our A-Team – read on!

Benjamin Perez-Goytia recently published Using Oracle Data Integrator (ODI) with Amazon Elastic MapReduce (EMR). He provides details on how to use Oracle Data Integrator (ODI) with the Amazon Elastic MapReduce (EMR) cloud service.  Amazon EMR is a big data cloud service and a member of the Amazon Web Services (AWS) cloud computing services, offered by Amazon.com.

Thanks Benjamin!

Thursday Mar 24, 2016

How to connect to GoldenGate Cloud Service 

After you create a GoldenGate Cloud Service (GGCS) instance, you can then connect to the virtual machine to perform the setup. The How to connect to GoldenGate Cloud Service provides the instructions on how you can connect to GGCS instances using SSH in PuTTY on Windows and SSH command from LINUX. You can also connect to GGCS instance via SFTP.

I would also recommend you to refer to the Getting Started with GoldenGate Cloud Service Tutorial for additional information.

To reach Jinyu or send your suggestions/questions, you can follow @jinyu512.

Wednesday Mar 23, 2016

Getting Started with Oracle GoldenGate Cloud Service

GoldenGate Cloud Service (GGCS), is a cloud based real-time data integration and replication service, which provides seamless and data movement from various on-premises relational databases to databases in the cloud with sub-seconds latency while maintaining data consistency and offering fault tolerance and resiliency. This blog provides an overview.[Read More]

Thursday Mar 17, 2016

Oracle GoldenGate Cloud Service Executive Webcast

We are proud to announce the availability of the much awaited Oracle GoldenGate Cloud Service.

Oracle GoldenGate Cloud Service builds on top of Oracle’s on premises GoldenGate solution, the industry leading data replication and real time streaming engine. Oracle GoldenGate Cloud Service combines the flexibility of a scalable cloud service that can be consumed on a subscription basis along with the powerful data streaming capability of an enterprise solution.

fig 1:Oracle GoldenGate Cloud Service Overview

Oracle GoldenGate Cloud Service 

Oracle GoldenGate Cloud Service

  1. Enables migration to the cloud from heterogeneous databases to the Oracle Cloud platform. This includes moving data from Amazon RDS for Oracle among other data sources. Oracle GoldenGate Cloud Services ensures security and reduces risks to the data streaming process through its high-throughput encryption based data delivery. Oracle delivers all this with minimal negative impact on the critical source and business application systems.
  2. Is critical for well performing global real time reporting and analytics. Oracle GoldenGate Cloud Service delivers real time data into the cloud allowing the population and maintenance of cloud based data centers and data warehouses. A cloud based global data reserve allows intensive business analytics queries to be offloaded to avoid impacting source data systems. Globally located cloud data centers allow these queries to be offloaded to data the geographically closest location to the user.
  3. Helps easy dev/test in the cloud with live production data. Oracle GoldenGate Cloud service enables fast, elastic and web driven provisioning to create sandboxes in the cloud complete with real time data to help replicate production like environments for development and testing. Among other advantages, this allows customers to test and validate time sensitive business decisions with production data.

Fig 2: Take advantage of existing skills and architecture to extent data centers into the cloud. 

Learn More

 Here is a quick product overview video about Oracle GoldenGate Cloud Service. For more information around Oracle GoldenGate Cloud Service visit our home page here.

GoldenGate Cloud Service Executive Webcast

Join us for our executive webcast featuring Amit Zavery, Senior Vice President, Oracle Cloud Platform and Integration Products and Jeff Pollock, Vice President of Product Management at Oracle discuss Oracle's latest cloud offering. Joining them will be Paul Stracke from Paychex to provide more customer perspective.

Mark your calendars today and join us on 10 AM PST on the 7th of April. Register here.

Thursday Mar 10, 2016

Oracle GoldenGate Plug-in for Oracle Enterprise Manager 13.1 is released

Oracle GoldenGate Plug-In 13.1.1 for Oracle Enterprise Manager Cloud Control 13.1 is released.

Oracle GoldenGate Plug-In 13.1.1 is certified to work with Enterprise Manager 13.1 and Oracle GoldenGate Core 11.2.1.0.20+, 12.1.2.0.1, 12.1.2.1.0 and 12.2.0.1.0(latest) versions.

You may download the software for online or offline upgrade from the following locations

Please refer to the following links for more information:

  • Documentation Oracle GoldenGate for Enterprise Manager 13.1.1.0.0

  • Documentation Oracle Enterprise Manager Cloud Control 13.1.1.0.0

  • Learn more about Oracle GoldenGate Management Pack

  • Learn more about Oracle Enterprise Manager Cloud Control

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
« May 2016
SunMonTueWedThuFriSat
1
2
4
5
6
7
8
9
10
11
13
14
15
17
18
19
21
22
23
25
26
27
28
29
30
31
    
       
Today