Tuesday Jun 21, 2016

Oracle Data Integrator (ODI) 12.2.1.1.0 Now Available

Oracle Data Integrator 12.2.1.1.0 is now available! Please visit the ODI OTN page for downloads, documentation, related collateral and other useful links.

Take a look here for the latest details of this release – and read on for some highlights:

Hyperion Essbase and Hyperion Planning Knowledge Modules

Hyperion Essbase and Hyperion Planning Knowledge Modules have been made available out of the box with Oracle Data integrator and support the latest version (11.1.2.4) of these Hyperion Applications.

Integrated Capture/Delivery support in GoldenGate Knowledge Modules

The GoldenGate Journalization Knowledge Modules (JKMs) for Oracle databases have been updated and now support Integrated Capture and Delivery. This updated functionality can improve performance and provides better scalability and load balancing.

Support for Cubes and Dimensions
Core ETL – ELT enhancements have been made; where ODI now provides support for two types of dimensional objects: Cubes and Dimensions. Users can create and use Cubes and Dimensions objects directly in Mappings to improve developer productivity with out of the box patterns that automate the loading of dimensional objects. This also allows for improved Type 2 Slowly Changing Dimensions and brand new Type 3 Slowly Changing Dimensions support with ODI.


Big Data Configuration Wizard
A brand new Big Data Configuration wizard is now available in the ODI Studio Gallery and provides a single entry point to configure the Topology objects for Hadoop technologies such as Hadoop, Hive, Spark, Pig, Oozie, etc.

Let us know how you are using ODI – and try out this new version to keep up with what’s current!

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.


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

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!

Friday Feb 19, 2016

Oracle GoldenGate Adapter for MongoDB

Oracle GoldenGate can now integrate with Mongo DB using the GoldenGate Adapter for MongoDB. GoldenGate Adapter for MongoDB 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 MongoDB. It can handle automatic DDL replication and supports inserts, updates and deletes into MongoDB.

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/MongoDB%20Adapter

Compatibility Matrix:

  • GoldenGate for Big Data: 12.2.0.1.0 (All platforms)
  • MongoDB Server : 2.4, 2.6, 3.0 3.2
  • MongoDB Java Driver: 3.2.2


Tuesday Feb 16, 2016

More Tips on Oracle Data Integrator (ODI) for the Cloud from the A-Team

Check out this week’s post from Cecile Franchini of the A-Team, the title says it all: Tips for ODI in the Cloud: ODI On-Premise with DBCS.

If you are considering connecting to the Cloud and using Oracle DBCS – Oracle Database Cloud Service – ODI on-premise can help get the job done.

Tuesday Feb 02, 2016

A-Team Article: Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services

Benjamin Perez-Goytia of the Data Integration Solutions A-Team provides a very matter of fact summary regarding Cloud Integration with Oracle Data Integrator (ODI). For all the details: Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services.

The blog post details how to integrate Oracle Data Integrator (ODI) on-premise with cloud services.  Cloud computing is a service or utility in high demand and enterprises find themselves with a mix of on-premise data sources and cloud services.  Ben describes how Oracle Data Integrator (ODI) on-premise can enable the integration of both on-promise data sources and cloud services.

Happy reading! For more A-Team reads on ODI, browse through the A-Team Chronicles.

Tuesday Jan 26, 2016

ODI 12c KMs are now available for Oracle Hyperion Planning and Essbase

Oracle Essbase and Oracle Hyperion Planning Knowledge Modules (KMs) are now available for Oracle Data Integrator 12.2.1. The patches containing the KMs are available for download on My Oracle Support. Patch# 20109114 contains Oracle Essbase KMs and Patch# 21903914 has Oracle Hyperion Planning KMs. The KMs support latest version (11.1.2.4) of these Hyperion Applications.  All the features available in their corresponding 11g KMs are available in these 12c KMs as well.

Monday Jan 25, 2016

Oracle Metadata Management (OMM) 12.2.1 is now available!

Metadata Management is essential to solving a wide variety of critical business and technical challenges which include how report figures are calculated, understanding the impact of changes to data upstream, providing reports in a business friendly way in the browser and providing reporting capabilities on the entire metadata of an enterprise for analysis and improvement. Oracle Metadata Management is built to solve all these pressing needs for customers in a lightweight browser-based interface.

With Oracle Metadata Management 12.2.1, you will find many new features and enhancements. To list just a few:

Oracle Metadata Management is now based upon 100% Java delivery and installation allowing support for Windows as well as variation Linux/Unix deployments. This provides all UI features and any bridges which are executable in a Java and Linux/Unix based environment, specifically 100% java based bridges including JDBC database bridges (Oracle, Teradata, DB2, SQL Server, etc.), big data bridges (Hadoop Hive, HCatalog), and other popular bridges such as CA ERwin xml, Informatica PowerCenter xml, Tableau BI, etc.

Oracle Metadata Management configuration architecture visualization is now based upon an HTML 5 based implementation which includes better scalability, performance and overall layout quality, and supports iPad and other tablets.

Oracle Metadata Management provides two primary user interfaces for access, analysis, management and administration. The Metadata Manager UI provides a more technical interface for those who are managers of the metadata or administrators of the repository. The Metadata Explorer UI is designed for optimized search, analysis and reporting, as well as more control over the context (configuration version) presented to given users.

Oracle Metadata Management is now offering detailed DI data flow lineage analysis on demand only (in real time), instead of pre-calculating. This enhancement means that harvesting times are reduced by about 80%!

Oracle Metadata Management has a great number of new or enhanced bridges covering RDBMS, Big Data, Data Modeling, Data Integration, and Business Intelligence.

More details on the bridges and all the New Features for this release can be found here.

You can download Oracle Metadata Management 12.2. 1 here!

Friday Dec 18, 2015

Oracle Management Pack for Oracle Data Integrator for Enterprise Manager 13.1 is out! Make the most of the value of your Oracle Data Integrator investments!

We’ve mentioned before that to help you make the most of Oracle Data Integrator, and to deliver a superior ownership experience in an effort to minimize systems management costs, Oracle’s Management Pack for Oracle Data Integrator is a great addition! As a quick refresher: this product leverages Oracle Enterprise Manager Cloud Control's advanced management capabilities to provide an integrated and top-down solution for your Oracle Data Integrator environments. Management Pack for Oracle Data Integrator supports both 11g (11.1.1.7.0 and higher) and 12c versions of Oracle Data Integrator (12.1.2, 12.1.3 and 12.2.1).

Management Pack for Oracle Data Integrator provides a consolidated view of your entire Oracle Data Integrator infrastructure. This enables users to monitor and manage all their components centrally from Oracle Enterprise Manager Cloud Control.


In review, important capabilities include:

Performance Monitoring and Management

Management Pack for Oracle Data Integrator streamlines the monitoring of the health, performance, and availability of each and all components of an Oracle Data Integrator environment – this includes Master and Work Repositories, Standalone and JEE agents, as well as source and target Data Servers.

Configuration Management

To ensure that the configurations of all critical Oracle Data Integrator components in production environments are consistent with staging or test environments, Management Pack for Oracle Data Integrator provides Configuration Snapshots to save working configurations into the Management Repository or into an external XML file. These snapshots can then be compared with the active configuration in staging or test environments, or against any historical snapshot. Configuration Comparison is the next logical step which thus allows you to ensure the consistency of configurations in your application environment. Going one step further, Configuration History keeps track of all configuration changes, which can help in diagnosing performance problems that may be related to configuration changes along the way.

Service Level Management

Management Pack for Oracle Data Integrator allows for a proactive method to monitor Oracle Data Integrator environments at all levels. Many out of the box metrics are automatically collected for each Oracle Data Integrator component (repositories, agents, sources, targets…) which then provides users the ability to set up alerts based on critical or warning thresholds. Notifications can be provided to users in various ways through emails or Simple Network Management Protocol (SNMP) options.

Historical Analysis and Reporting

While real-time metrics certainly come in handy, there is also something to be said for historical collection of data! Management Pack for Oracle Data Integrator stores collected metrics and configurations data in a central repository –allowing users to thus analyze the metrics in various incremental views that include; last 24 hours, last 7 days, last 31 days. In addition, customizable service and system dashboard functionality allows users to create reports on various services and systems for service level availability, usage, performance, and business indicators – all in an effort to facilitate strategic trend analysis and reporting.

In a nutshell, Oracle Management Pack for Oracle Data Integrator benefits include: reducing the costs associated with monitoring the overall Oracle Data Integrator infrastructure and providing visibility into complex Oracle Data Integrator deployments across the enterprise, minimizing troubleshooting and performance tuning efforts as well as improving the overall ability to efficiently monitor Service Level Agreement compliance using powerful alerting capabilities. (For additional detail and to review another blog on the subject, click here.)

Oracle Management Pack for Oracle Data Integrator is licensed separately. From an installation perspective it is packaged in the Fusion Middleware plug-ins for Enterprise Manager (version 12.1.0.4 and higher) and comes with the base Enterprise Manager 12c or 13c download. There is no separate installation file to download. More information can also be found here.

Try it out! Getting Started with Oracle Fusion Middleware Management Plug-in

Monday Dec 14, 2015

Oracle Data Integrator Webcast Recap: Special Topic - Cloud Application Adapter

If you missed our Oracle Data Integrator Webcast two weeks ago about the simplicity of leveraging Oracle Data Integrator (ODI) with Cloud technologies – take a look here: Oracle Data Integrator Special Topic:  Salesforce.com & Universal Cloud.


With the explosion of the number of Cloud Applications today, the topic is top of mind for many organizations. ODI coupled with Progress DataDirect’s JDBC drivers can be the perfect fit – find out by viewing the webcast! Thanks again to our guest speakers: Sumit Sarkar, Chief Data Evangelist at Progress Software and Christophe Dupupet, Director – A-Team, Cloud Solutions Architects at Oracle.

For additional posts about ODI and the Cloud, browse the A-Team Chronicles – one of the posts you will find: A Universal Cloud Applications Adapter for ODI.

For other ODI webcasts, please view the Oracle Data Integrator Demo Webcast Archives. Our next one will cover ODI’s 12.2.1 New Features and is scheduled for January 14, 2016 at 1pm ET/10am PT. Join us!

Friday Nov 13, 2015

2015 Oracle Excellence Awards… and the Winners for the Big Data, Business Analytics and Data Integration Category are…

Every year at OpenWorld, Oracle announces the winners to its most prestigious awards, the Oracle Excellence Awards. This year, as we have in previous years, we celebrated in style! In an Oscars-like ceremony on Tuesday, October 27th, customers were highlighted for their innovative solutions. Congratulations to all winners!

Let me introduce this year’s 2015 Big Data, Business Analytics and Data Integration category winners:

Amazon.com, an American electronic commerce and cloud computing company, is the largest Internet-based retailer in the United States.

During its growth over the years, Amazon never invested in back office systems and processes believing that they could scale without impact to their business. After almost 15 years of exponential growth into a multi-national and diverse business, Amazon recognized that they needed to address improve their ability to manage financial reporting.

Together with The Hackett Group, they built an EPM and BI solution to ensure they could deliver automated financial reporting and analytics to over 1,000 stakeholders across the company. Using Oracle Data Integrator Enterprise Edition, Application Adaptors for Data Integration, Oracle BI Enterprise Edition, Oracle Essbase, and various Hyperion products – the solution yields huge benefits:

· 100% Positive Feedback from user community, leadership claiming First Successful Financial Systems Implementation

50% + Reduction in Time to Complete Close Process from 10+ days to 5 days

1,000s of Hours Saved per Month across 1,000 users in data analysis & mining

The automation of reporting that the reports and analytic capabilities are correct has truly provided the confidence Amazon.com desired in moving forward and providing modernization and agility in future business decisions.


CaixaBank is a leading Spanish retail bank and insurer. Centering on delivering customer service through innovation and technology, CaixaBank is regarded as a leading financial institution in global innovation and has pioneered the development of new means of payment.

They set out to become a data-driven company using Big Data architecture using Business Analytics tools by: Democratizing use of data for Reporting, Dashboarding and Analysis, Empowering end-user by allowing combine data for discovering Business patterns and niches and Blending Structured and Non-Structured information. Built on top of Exadata and Exalytics, and leveraging Oracle Business Intelligence, Oracle Big Data Analytics, and Oracle Data Integration tools, CaixaBank’s solution:

Enabled 360°Understanding of Customers to offer tailored, on-demand banking and insurance solutions

50,000+ hours saved/year on Big Data Project Development versus previous methods

75 Big Data projects - 16% drives increased economic margin, 14% addresses cost reduction, 27% improves process and saves time – generating 5 Million+ Euros

Their initial success is driving CaixaBank to transition towards a real time driven organization, enabling the monetization of their data relative to business targets.


Serta is the #1 mattress manufacturer in the United States and one of the most recognized home furnishing brands in the marketplace. In an effort to modernize the antiquated and inefficient ERP system to service financial reporting, and provide IPO readiness, they quickly implemented a scalable solution across the enterprise leveraging Oracle BI Foundation Suite, Oracle Endeca Information Discovery, various Hyperion products, Essbase Analytics Link for Hyperion Financial Management, Oracle Data Relationship Management, and Oracle Data Relationship Governance.

Together with Grant Thornton, the solution took 7 months, and yields:

Scalable, integrated platform delivered improved system stability thanks to consolidated, standardized, data acquisition and better quality data

Which in turn, improved the reliability and confidence in self service analytics

90% faster to produce Standardized Reporting - 9 business days saved per month

275% improvement in availability of data, allowing users to access and provide timely analysis of the data

This solution has provided Serta Simmons some truly amazing results, where the overhead cost reduction is in the millions due to higher quality speedier information, providing a strong foundation for future expansion of this solution.


Skanska AB, founded in 1887, is one of the world’s leading project development and construction groups, with expertise in commercial and residential projects and public-private partnerships. Skanska creates sustainable solutions and aims to be a leader in quality, green construction, work safety, and business ethics

Skanska needed to optimize its monthly management reporting – including shipping data to a 3rd party for augmenting. They wanted to simplify development and testing of new information solutions and reports, and ensure that users could quickly and easily adapt the collection and analysis of information to meet new requirements.

In a centralized, single cloud environment for management reporting worldwide, Skanska is using Oracle BI Cloud Service. The solution benefits include:

Full data load to “ready to analyze” in < 5 minutes

17 days to implement

Oracle BI Cloud Service is proving reliable, being constantly accessible to 60K users via mobile devices in this global organization.


Scottish and Southern Energy, SSE is involved in producing, distributing and supplying electricity and gas and other energy related services. Within the UK, the focus on energy companies and power generation industry is in the spotlight, with growing regulation and joint assessment of competition in the energy market. To ensure that Scottish & Southern Energy (SSE) and subsequently, the SSE Generation directorate, can continue to operate in this ever changing environment, whilst developing and retaining a competitive edge over its market rivals, data on its entire business, and the way it manages and uses that data will need to be a key focus.

SSE was looking for an agile and rapid delivery of mobile accessible BI dashboards which otherwise would have taken their internal IT teams a considerable amount of on premise infrastructure design and provisioning. The Oracle BI Cloud enabled functionality to be surfaced in an extremely short amount of time using real Generation business data to present to senior executives.

SEE found:

Cloud Infrastructure is more Cost and Time effective; 6 weeks of work compared to 6 months

Increased confidence within internal SSE business community for delivering right solution

Management Dashboard key enabler for more effective and quicker decisions by leadership team

The advantages that are available to SSE in utilizing ‘Cloud’ based solutions in regards to speed, flexibility and agility in conjunction with the on premises solutions. SSE finds it is able to integrate data from multiple sources into “Single Source of Truth” and in turn make long term informed decisions vital for the future sustainability of SSE.


Tampa International Airport is one of the region's most significant economic engines, with a total economic output of more than $7 billion. The airport and its tenants employ more than 7,500 people on the airport campus and support more than 81,000 jobs in the community.

Tampa International Airport set out to modernize their infrastructure and data acquisition strategy knowing better data integration and business analytics would strengthen their business and customer loyalty. Sitting on top of Exadata, Exalogic, and Exalytics, Tampa International Airport combined Oracle Data Integrator and Oracle GoldenGate with Oracle BI Foundation Suite for better analytics around passengers, parking, concessions, baggage claim, etc. In 6 months, the completed project yields major benefits:

With better analysis helping them add new routes, they have seen a 6.7% Yearly Passenger Increase, the largest in year-over-year growth in a decade, with international traffic increasing by more than 14%

4.6% increase in revenues driven by greater analysis of the Authority’s parking, concessions and rental car businesses resulting in greater spend per passenger

150% reduction in Time to Complete Planning & Forecasting Process via more efficient resource and people management

The success has provided Tampa International Airport sets a shift in paradigm – for a more proactive, strategic and operational excellence – all in an effort to better serve their customers.

CONGRATULATIONS to our Big Data, Business Analytics and Data Integration category winners!

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
« June 2016
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
22
23
24
25
26
27
28
29
30
  
       
Today