Oracle Data Integrator - Some Information

The Oracle Data Integration Suite at-a-glance:

Oracle adds Data Integration Suite to middleware family
Source: http://searchoracle.techtarget.com/news/article/0,289142,sid41_gci1297749,00.html

The suite also combines Oracle's SOA-based Business Process Management and change management capabilities with Oracle-Hyperion's Master Data Management (MDM) capabilities. Oracle acquired Hyperion last March as part of an ongoing, high-profile acquisition spree.

Potential Data Integration Suite buyers also have the option to incorporate Oracle's in-memory data grid technology. Analysts say that storing data in-memory reduces performance overhead and speeds up the process of retrieving data that exists on the virtual or middleware layer.

The new suite, which comes with the Oracle Data Integrator E-LT technology, also incorporates two relatively new products -- Oracle Data Profiling and Oracle Data Quality for Oracle Data Integrator -- which were developed in conjunction with Harte-Hanks Trillium Software.

Oracle says the two products extend the data quality features of Data Integrator to provide added data governance capabilities.

Oracle Data Profiling is a quality monitoring tool that allows users to assess the quality of their data through metrics, to discover or infer rules based on this data, and to monitor the evolution of data quality over time, according to Oracle.

Oracle Data Quality for Data Integrator employs a rules-based engine to help users ensure data quality and conduct name and address cleansing as data integration efforts move forward.

With the new Data Integration Suite, Oracle is sending the message that "no matter what solution you have, no matter where you go, you don't have to worry about where your data is," Wang said. "You can keep a single source of truth with Oracle."


The new Oracle Data Integration Suite includes the following:-
- Oracle Data Integrator
- Oracle BPEL Process Manager
- Oracle Enterprise Service Bus
- Oracle Application Server
- Oracle-Hyperion Data Relationship Manager
- Oracle B2B Engine
- Oracle Business Rule Engine

Optional features are priced separately and include:
- Oracle Data Quality for Data Integrator
- Oracle Data Profiling
- Coherence Data Grid
- Legacy Adapters
- Applications Adapters
- B2B Adapters
- Unstructured Content Adapters

Oracle Data Integrator 10g Suite includes:

Oracle Data Integrator Agent
Oracle Data Integrator Designer
Oracle Data Integrator Operator
Oracle Data Integrator Security Manager
Oracle Data Integrator Topology Manager
Oracle Data Integrator Metadata Navigator
Oracle Data Integrator Lightweight Designer
Oracle Data Integrator Driver for XML
Oracle Data Integrator Driver for LDAP
Oracle Data Integrator Knowledge Modules
Oracle Data Profiling
Oracle Data Quality for Data Integrator

Good to start with:
a. ODI OTN Article: http://www.oracle.com/technology/pub/articles/rittman-odi.html
b. Very useful White paper to understand Data Services and ODI Features -
http://me.jtpollock.us/pubs/
c. Gartner Research -
http://www.gartner.com/DisplayDocument?id=599407&ref=g_sitelink
d. ODI Documentation -
http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/htdocs/
1013_support.html
e. ODI Main Product Page -
http://www.oracle.com/technology/products/oracle-data-integrator/index.html

Will write more on each of interesting ODI features like CDC, developing Custom Knowledge Modules, Human Workflow integration, and developing BI dashboards, and many more.

Cheers,
Ananthalakshmi

Purchasing - Advanced Pricing Integration 11.5.10 and R12

Please review the following documents which gives insight on the Advanved Pricing Integration in Purchasing products in Release 11.5.10 and R12.

1. PO Integration with QP Whitepaper.doc - Published in Metalink, note 394490.1 -
Oracle Purchasing Integration with Oracle Advanced Pricing – Release 11.5.10
2. R12 Purchasing User Guide -
http://download.oracle.com/docs/cd/B40089_06/current/html/docset.html
3. Attached Power Point presentation on the R12 Pricing Integration changes.

In overview, in R12 qualifiers can be set based on Contract Purchase Agreements as well as Blanket and Global Blanket Agreements and we support only goods based lines, and the following line types are not supported for the Advanced Pricing Integration.

No. Type Name Value Basis Purchase Basis
1 Rate based Temp Labor Rate Temp Labor
2 Fixed Price Temp Labor Fixed Price Temp Labor
3. Fixed Price Services Fixed Price Temp Labor
4. Amount Based Services Fixed Price Services

Also, Internal requisitions will not be priced against advanced pricing setup.

Please review the PO Integration with QP Whitepaper for the supported/unsupported Advanced Pricing features in Purchasing. The details listed in this doc is applicable to both 11.5.10 and R12, except few delta changes to support Blanket Agreements in R12, and in 11.5.10, we can only qualify the price list/modifier,etc based on Contract Purchase Agreement(CPA).

Advanced Pricing has the Promotional Limits feature since 11.5.9 to monitor the spend limits against a promotional discount modifier, the limit can be either Hard/Soft limit and you can monitor the discount applied/generate reports, etc. Purchasing does not have integration for Promotional Limits feature till R12.

Cheers,
Ananthalakshmi

White Paper: Oracle iProcurement: Enhanced Catalog Content Management,Online Authoring and Content Security Model in Release 12

I have released a white paper on "Oracle iProcurement: Enhanced Catalog Content Management,Online Authoring and Content Security Model in Release 12" to help
iProcurement Customers better understand the new Unified Catalog Model and the Content Security Features introduced in Oracle iProcurement Release 12.

Please download this whitepaper from http://www.metalink.oracle.com, Note#560749.1.

Cheers,
Ananthalakshmi