Wednesday Mar 23, 2016
Thursday Mar 17, 2016
By Madhu Nair on Mar 17, 2016
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
- 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.
- 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.
- 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.
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
By Thomas Vengal-Oracle on Mar 10, 2016
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 22.214.171.124.20+, 126.96.36.199.1, 188.8.131.52.0 and 184.108.40.206.0(latest) versions.
You may download the software for online or offline upgrade from the following locations
Offline Download Oracle GoldenGate for Enterprise Manager 220.127.116.11.0
Online Download Oracle GoldenGate for Enterprise Manager 18.104.22.168.0
Please refer to the following links for more information:
Friday Feb 19, 2016
By Thomas Vengal-Oracle on Feb 19, 2016
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
- GoldenGate for Big Data: 22.214.171.124.0 (All platforms)
- MongoDB Server : 2.4, 2.6, 3.0 3.2
- MongoDB Java Driver: 3.2.2
Thursday Feb 18, 2016
By Ayush Ganeriwal-Oracle on Feb 18, 2016
There are a couple of enhancements added in outbound Web Services invocation support in Oracle Data Integrator (ODI) 12.2.1. You can now configure the Web Service end point URLs in the Topology definition instead of hard coding it in the ODI Tools parameters. Logical Schema of such topology configuration can be then used directly in the OdiInvokeWebService tool parameters. Now ODI also allows you to invoke a WebService that is protected by OWSM policies and register those OWSM policies as part of Physical Schema definition.
To register the Web Services definition a new technology, “SOAP Web Service”, is added in the Topology where you create the Data Server for the Web Service and register its WSDL URL.
The Services, Ports, user credentials, OWSM policies for the endpoint service from the WSDL are configured as the Physical Schemas.
You can then create a Logical schema for it and bind it with Physical Schema through Context mapping. Such logical schema and context can be specified in the OdiInvokeWebService tool instead of hard coding Web Service URL and other parameters.
To learn more about the Topology Configurations for Web Services, there is an Oracle by Example tutorial available providing step by step instructions on using the feature: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_newfeatures/ascii_files.html#section3s1
Additionally the new features introduced in Oracle Data Integrator 12.2.1 are also documented in our New Features white paper.
Tuesday Feb 16, 2016
By Sandrine Riley-Oracle on Feb 16, 2016
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.
Friday Feb 12, 2016
By Julien Testut-Oracle on Feb 12, 2016
In the new Oracle Data Integrator 12.2.1 release the Native Format Builder wizard which is used by the Complex File technology is available directly within ODI Studio. Previously users had to use JDeveloper with the SOA Extensions to access it. The Native Format Builder wizard is used to parse a complex file structure and build a Native Schema (nXSD) description out of it, Oracle Data Integrator then uses this nXSD to reverse-engineer, read and write information from complex files.
You can find more information about the Native Format Builder and the Complex File technology in our documentation: http://docs.oracle.com/middleware/1221/odi/develop-connectivity-km/complex_files.htm#ODIKM1397
In addition you can find an Oracle By Example tutorial which will walk you through how to use this feature: https://apexapps.oracle.com/pls/apex/f?p=44785:24:103532390093139:::24:P24_CONTENT_ID,P24_PROD_SECTION_GRP_ID,P24_PREV_PAGE:12572,,24
Finally all the new features introduced in Oracle Data Integrator 12.2.1 are documented in our New Features white paper.
Thursday Feb 04, 2016
By Madhu Nair on Feb 04, 2016
In case you missed the recent executive webcast on Big Data Preparation Cloud Service, do not worry you can watch the replay here.
Senior Vice President of Development, Amit Zavery outlines the importance of cloud based data integration technologies and the emphasis that Oracle is placing on enabling not just the IT but also the business analysts with cutting edge requirements. He lays out the importance of streamlining the data preparation and data wrangling process to not just be a necessary step towards analytics, but an enriching and empowering step towards self service data preparation.
Oracle Big Data Preparation Cloud Service
The webcast also featured Jeff Pollock, Vice President of Product Management, moderating the discussion and Vinay Kumar, Co-founder and CEO of Blue Cloud Innovations. Both of them also stressed the importance of a cloud based technology to bridge the IT-Business gap and how self service data wrangling when done right imparts great value, brings up rich recommendations and helps streamline and automate the data preparation pipeline.
About Big Data Preparation Cloud Service (BDP)
BDP is not just built for Big Data. It is built for business data of any size, from small departmental data to large enterprise data to massive internet data. The technology is based on Apache Spark ML and Natural Language Processing with semantic knowledge graphs on the Oracle Cloud. This means that it is more efficient in mapping relationships and recommendations, it offers a higher quality of of automation and better data enrichment.
Meanwhile here is a selection of questions that were answered live during the webcast.
Please describe the scalability of this Big Data Preparation and Cloud Service.
Big Data Preparation runs native on Hadoop and Spark - it is able to handle large datasets leveraging the distributed processing the provisioned hadoop cluster. For more information about our service please follow these links: http://cloud.oracle.com/bigdatapreparation
How does does the customer wait for their 'wrangled data" to be returned to them?
Depending on the use case, the customer may use the provided download results wizard or may leverage RESTful API's to automate the downloading of the prepared data from the Oracle Storage Cloud.
Can we use it with Data visualization service/BICS?
Yes. BDP produces a tab delimited output file that can be uploaded into either BICS or DVCS for analysis in Visual Analyzer. In the upcoming quarterly update, BDP will support direct integration with BICS - where BDP will be able to publish directly to BICS data store using the Datasync API.
I know you touched on this a few minutes ago, but I need a little more clarification on something. Did you state that the developer can possibly be eliminated in processing this data, or will it still be mandatory to have coding involved to acquire data?
The intent is not to eliminate IT entirely from the process but rather to empower business users and domain experts to be able to review and prepare potentially valuable datasets without getting IT involved too early in the process. Once a dataset has been validated by the business as being valuable and the process needs to be automated and operationalized, then IT would be involved and could leveraged the provided set of RESTful API's to process similar datasets as part of an automated process.
Could you compare it with Amazon AWS QuickSight Spice, Machine Learning tools?
They are two entirely different tools. AWS QuickSight is a Cloud Based BI tool that allows users to build data visualizations - BDP is purely a data preparation tool that prepares data for visualization and analytics.
Tuesday Feb 02, 2016
By Sandrine Riley-Oracle on Feb 02, 2016
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.
Monday Feb 01, 2016
By Mackbell-Oracle on Feb 01, 2016
In keeping with our foundation principles, the focus for this release has been Usability, Manageability, Heterogeneity, and Performance.
What’s New in Oracle GoldenGate 12.2 (Replication Simplification)
GoldenGate Platform Features –for Oracle, SQL Server,
Sybase, Teradata, Informix, TimesTen, DB2 LUW, NonStop SQL/MX, PostgreSQL, and
MySQL Automatic Heartbeat Table Metadata in Trails Parameter
Insight One Billion Trail
Files For the Oracle Database For SQL Server For Teradata For DB2 LUW
Record end-to-end replication lag and view details with a database view. Valid for heterogeneous configurations as well.
No need to generate a definitions file or use SOURCEDEFS/ASSUMETARGETDEFS.
Lookup parameter definitions from GGSCI with INFO PARAM, get the list of running parameters for a process with SEND … GETPARAMINFO, and pre-validate parameter files with the new checkprm utility.
Trail file sequence length has increased to nine digits; a 1000x increase and effectively one billion trail files.
More information on
Oracle GoldenGate 12.2
GoldenGate Platform Features –for Oracle, SQL Server, Sybase, Teradata, Informix, TimesTen, DB2 LUW, NonStop SQL/MX, PostgreSQL, and MySQL
Automatic Heartbeat Table
Metadata in Trails
One Billion Trail
For the Oracle Database
For SQL Server
For DB2 LUW
Tuesday Jan 26, 2016
By Ayush Ganeriwal-Oracle on Jan 26, 2016
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 (126.96.36.199) 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
By Sandrine Riley-Oracle on Jan 25, 2016
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.
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!
Tuesday Dec 22, 2015
By Thomas Vengal-Oracle on Dec 22, 2015
Much awaited Oracle GoldenGate for Big Data 12.2 is released today and it is available for download at OTN.
Let me give you a quick recap on Oracle GoldenGate for Big
Data. Oracle GoldenGate for Big Data streams transactional data into big data
systems in real-time, raising the quality and timeliness of business insights. Oracle
GoldenGate for Big Data offers also provides a flexible and extensible solution
to support all major big data systems.
Oracle GoldenGate for Big Data
- Same trusted Oracle GoldenGate architecture used by 1000’s of customers
- Data delivery to Big Data targets including NoSQL databases
- Support for Polyglot, Lambda and Kappa architectures for streaming data
- Less invasive on source databases when compared to batch processing such as Sqoop or ETL processes
- Simple ingestion for 1:1 data architecture for populating “raw data” zones
- Real-time data delivery for streaming analytics/apps
proven at scale with high performance
Architecture – GoldenGate for Big Data 12.2 versus 12.1
New Features in 188.8.131.52: