Thursday Jan 16, 2014

A preview of Oracle Data Integrator 12c and Oracle Warehouse Builder Webcast - Jan 23rd

It has been a busy close to 2013 with Oracle Data Integration announcing a lot of significant releases in its product line. Oracle Data Integrator 12c (ODI12c) was released along with Oracle Golden Gate. Then came the release of the Management pack for Oracle Data Integrator in December. This year the availability of the migration utility to migrate Oracle Warehouse Builder objects to Oracle Data Integrator was announced. Join us as we discuss in detail all these products, their workings and features on the 23rd of January. Below is a quick preview of the contents of the webcast.

With its declarative design and flow based design for the user, boosted performance for the administrators and enterprise architects and increased integration with enterprise software ODI12c continues to deliver on its performance and productivity based themes.

Hadoop support is enhanced through Knowledge Modules for Hadoop standards, connectivity support to load data into HDFS, generate HiveQl and more. With its extended heterogeneous connectivity ODI12c ensures full connectivity for all enterprise data. This release also sees tighter integration points with Oracle GoldenGate for real time data requirements.

With ODI becoming the strategic ELT technology for Oracle, the OWB migration utility was made available late 2013 to provide a phased migration approach for our OWB customers to ODI. Tighter integration between ODI and OWB also allows run time integration (managing of OWB repository from ODI topology, execution and monitoring of OWB jobs from  ODI) between the two technologies.  We discuss the objects supported, gotchas, supported versions and support policies for the migration in the webcast.

The announcement of the availability of Management pack for Oracle Data Integrator now allows for consolidation of monitoring and managing of all your ODI infrastructure.

We invite you to join us as we discuss these developments in ODI and to get your questions answered by an expert panel.

Tuesday Jan 07, 2014

Oracle GoldenGate 12c - Announcing Support for Microsoft and IBM

Oracle GoldenGate 12c further advances Oracle's leadership in real-time, heterogenous data replication technology with simplified configuration, extreme performance, and improved high availability solutions.  Continuing our release process Oracle GoldenGate 12c, we are pleased to announce the support for Microsoft SQL Server 2008/2012, IBM DB2 LUW, and IBM DB2Remote.  This release includes optimizations for each platform, capture, and intelligent, coordinated delivery capabilities.   The product delivers seamless transition to private cloud and real-time data replication between databases on public cloud and on premises environments to meet businesses current and future-needs.    Keep tuned for additional announcements as more platforms are released. 

Media is available for download on the Oracle Technology Network (OTN), and the Oracle Software Delivery Cloud (OSDC).

Monday Jan 06, 2014

Low Downtime E-Business Suite Migrations using Oracle GoldenGate

Who likes to work work weekends and holidays to migrate a production database to new hardware or to upgrade to a new version?      In many cases working the weekend is unavoidable and often these types of activities have to be done while minimizing business activities that generating revenue.   But let’s face it, current migration methods haven’t changed a whole lot in twenty years;  take the system down Friday night, migrate the data to the new system in bulk or upgrade the database in place,   bring the system back up, unit test and hope Monday morning that everything works.    The techniques have changed and things have definitely improved on the efficiency side of the equation, but downtime for the business still exists.   As IT professionals and DBAs all know, months of planning and preparation go into making these types of event successful but things can go wrong.    “The best laid schemes of Mice and Men oft go awry, And leave us nothing but grief and pain, For Promised Joy - Robert Burns 1785."    For years customers have been asking for a better way to migrate or upgrade the underlying Oracle database for E-Business Suite with a low amount of downtime.    

Oracle ACS (Advanced Customer Services) developed a services based solution to  deliver low downtime, low risk migrations and upgrades using Oracle GoldenGate as the enabling technology. Oracle GoldenGate has a long track record of successful migrations and upgrades with little or no downtime. Combining this technology with the services provided by Oracle ACS and customers now have an option significantly reduce their downtime when migrating or upgrading their Oracle databases. The Oracle ACS Migration Service uses functions integrated in the Oracle Database for the initial load of the target system and Oracle GoldenGate for ongoing data synchronization (see image below). The process is suitable for all Oracle E-Business Suite products on an Oracle Database of any size. The end result is a database migration with low amount of downtime for business users. 

One common question that comes up regarding this specific migration service is “Oracle GoldenGate provides zero downtime migrations for other applications, why not E-Business Suite?”   The reason why the migration service is a low downtime solution and not zero is that E-Business Suite uses Oracle Advanced Queues, which under meta data tables use the ANYDATA data type. This particular data type is not currently supported by Oracle GoldenGate and as such has to be moved in bulk. These tables typically have a very small amount of data and prior to cutting over to the new target environment, these tables are moved from the source to target as a complete unit.   A small amount of time is needed to perform this action. 

For additional details about the Migration Services available for Oracle E-Business Suite, please refer to this Oracle Migration Service for Oracle E-Business Suite data sheet. You can hear about this new solution and Oracle GoldenGate 12c on Feb 12th 10am PT in our upcoming webcast: Introducing Oracle GoldenGate 12c: Extreme Performance Simplified.

Friday Nov 15, 2013

Advanced Replication for The Masses – Oracle GoldenGate 12c for the Oracle Database.

Customer requirements for data replication are reaching very high levels.   The demand is for continuous, uninterrupted flow of data in real-time while lowering IT costs and improving efficiencies. This part of the market constitutes the middle to upper end of the data replication market and customers are broadly educated and well versed in replication technologies as never before. As a result, they demand well-designed, well-engineered, and well-crafted products – possessing advanced features that compliment their evolving IT systems.

Vendors offer a wide variety of replication products and services, but with the exception of Oracle these other vendors rely on brute force log scraping, inefficient fetching of data types not supported or encrypted, and heavy reliance of manual configuration and tuning when dealing with highly tolerant RAC systems or high data volumes.    Oracle GoldenGate 12c is at the forefront and differentiates itself in the market by providing a truly well-designed, well-engineered and smart solution for the Oracle database.

What are the key new features of Oracle GoldenGate 12c for the Oracle database?

  • Support for Database 12c Multitenant feature which allows smooth transitions to private cloud deployments.
  • The new Integrated Delivery for Oracle Database. This feature enables simpler and more powerful configurations with a streamlined process model that coordinates multiple parallel apply processes, which improve performance for high volume implementations. 
  • Enhanced high availability via integration with Data Guard Fast Start Failover
  • Improved security with tighter integration with the Oracle wallet

Oracle GoldenGate is at the vanguard of extreme performance and the one standout feature of the 12c release is Integrated Delivery.    Oracle GoldenGate now leverages a lightweight streaming API built into Database 12c for Oracle GoldenGate. The Smart Product Design of the Oracle GoldenGate 12c Integrated Delivery feature enables simpler and more powerful configurations that coordinate multiple parallel apply processes to improve performance for high volume implementations. 

This high performance feature leverages numerous database parallel apply servers for automatic dependency aware, parallel apply. What this means is that Integrated Delivery will automatically balance transactions across these apply processes and coordinate the transactions to maintain order and insure referential integrity, while delivery data at speeds not feasible by other vendors.

Oracle GoldenGate 12c has many other new features for the Oracle database. You can learn more about GoldenGate 12c by downloading our new resources and watching the replay of the executive video webcast with customer and partner speakers.

Thursday Aug 15, 2013

Putting Data to Work Using Enterprise Data Quality

Data Quality is a hot new topic that may not get covered much on our data integration blog [we’re now changing that!]. Oracle Enterprise Data Quality an essential element in the data integration portfolio. You can think of Oracle Enterprise Data Quality as your favorite one-size-swiss-army-multitool which can be applied to any number of data management and governance situations. These cases range from Master Data Management, application integrations, system migrations, BI and data warehousing, and finally governance, risk and compliance solutions. Let’s look at a couple of examples for each case:

  • Master your Data. No matter the type of information you are mastering and syncing—product, customer, supplier, employee, site, citizen, or any other type—you need a data quality process for initial cleanup and load as well as for ongoing duplicate prevention and governance. A sophisticated MDM program will even verify data as it is entered into spoke systems, preventing data quality problems at the source. For some organizations, the idea of implementing a data hub is just too daunting. Implementing an enterprise data quality (EDQ) solution to clean up legacy systems and drive consistent standards won’t deliver as much benefit as a true MDM solution, but it’s a cheaper, faster alternative that can help in the short term and pave the way for a more comprehensive MDM strategy down the road.
  • Drive Application Innovations. Business applications are only as useful as the data they present. The more complex your application landscape, the more likely you are to need a data quality program to drive consistent data across all your systems. EDQ solutions can clean up legacy systems and put preventative verification and governance processes in place to ensure a steady stream of high-quality data for all kinds of systems, such as customer relationship management, human resources, product lifecycle management, and search (especially for solutions based on Oracle Endeca, which thrives on well-structured, well-standardized data).
  • Simplify Migrations. Merging disparate data from many sources requires a disciplined approach to profiling, discovery, standardization, match, merge, case management, and governance. EDQ solutions pave the way to a smooth implementation by providing the tools you need to make sure you maintain data quality as you migrate systems.
  • Improve Business Insights. As with other business applications, BI is a case where putting garbage data in means you’ll get garbage data out. EDQ solutions can be used to standardize and deduplicate the data being loaded into a data warehouse.
  • Deliver on Compliance. Regulatory compliance of all kinds—including policies related to taxes, privacy, antiterror, and antimoney-laundering—require matching up data pulled from a variety of sources. With EDQ solutions, organizations can meet regulatory mandates with capabilities that support everything from simple deduplication of customer lists to matching data against government lists of suspected terrorists.

You can learn more about our Enterprise Data Quality multitool in our upcoming webcast! Unlike swiss army knives it is guaranteed never to rust or stop you in an airport metal detector.

Watch Putting Data to Work Using Oracle Enterprise Data Quality Solutions on Tuesday, August 27 at 10:00 a.m. PT, and learn more about the Oracle Enterprise Data Quality suite of products.

Monday Apr 22, 2013

Enterprise Data Quality: A Key Requirement for Data Integration and Beyond...

If you've been following the recent Oracle Data Integration blogs, then you're no stranger to our latest paper on the five key data integration requirements. Yet, what we haven't mentioned yet is the importance of data quality.  Enterprise data is changing constantly, take a look at the graphic below and you will see what I  mean.  Data degrades at a rapid fire pace and an enterprise-level data quality solution is key to maintaining the trustworthiness as well as reliability in order to make sound business decisions from it. 

As a key component of Oracle Data Integration product family, Oracle Enterprise Data Quality complements Oracle's integration technologies by providing the key steps around cleansing, standardizing, governing and matching information.  In addition, Enterprise Data Quality works with Oracle Master Data Management to help ensure that information inserted into multi-domain hubs is relevant, analyzed and accurate.  One of the key features of Enterprise Data Quality is its on-going governance capabilties, bolstered by case management and dashboards for auditing, profiling, and parsing information - across customer and product data.  The benefits of these features are that users have access to analyze data quality trends over time, continuous monitoring (user established) and rapid discovery of data faults.  Oracle Enterprise Data Quality provides a manageable footprint in the enterprise for both MDM and data integration initiatives.. It acts as as the perfect starting point for understanding the current state of data.  For more information on Oracle Enterprise Data Quality click here

Tuesday Feb 26, 2013

ODI - Slowly Changing Dimensions in 0 to 60

Want to see understand how to setup your datastores for supporting dimension loading concepts such as type 2 slowly changing dimensions? See the viewlet here.  The viewlet provides a very quick look at setting up a datastore for supporting slowly changing dimension data loading using ODI 11g. It uses the IKM Slowly Changing Dimension and shows dimension members being versioned when for example a marital status change happens.


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


« April 2014