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

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 from 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


Thursday Feb 18, 2016

Topology Configurations for Web Services in Oracle Data Integrator (ODI) 12.2.1

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

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.

Friday Feb 12, 2016

Complex File Wizard is now available in ODI Studio 12.2.1

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

Oracle Big Data Preparation Cloud Service

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.

To learn more about Oracle Big Data Preparation Cloud Service, visit us at our websites here and here.

 Meanwhile here is a selection of questions that were answered live during the webcast.

Questions

Answers

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

https://www.oracle.com/middleware/data-integration/big-data-preparation-cloud-service/index.html

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.


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