My Oracle Support Banner

OBIA 796x: Informatica Product Support Overview and Guidelines (Doc ID 2087667.1)

Last updated on AUGUST 16, 2019

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.1 to 7.9.6.4 [Release V7]
Oracle Business Intelligence Data Warehouse Administration Console
Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11g]
Information in this document applies to any platform.

Details

Overview

The purpose of this document is to clarify which Informatica SRs can be routed to the OBIA / BI Applications Support Team.

Informatica is bundled as an ETL tool for OBI Application versions 796x, it contains the mappings to load only the target warehouse as Oracle Business Analytics Warehouse (OBAW) 

The last version of OBIA shipped with Informatica as an ETL tool is BI Apps 7.9.6.4

Please Note: OBIA/BIApps 11g uses Oracle Data Integration (ODI) for the ETL tool NOT Informatica)

Some other Oracle Products also use Informatica as an ETL tool such as:

Any Informatica problems specific to the other products should be routed to the respective product support teams.

Actions

Below are some key BIApps Informatica Implementation and Licensing Guidelines:

  1. The OEM Informatica and DAC licenses are for use exclusively with BI Applications. BI Applications users can extend the applications and create additional areas of analysis provided that it is done within the BI Applications warehouse. Users can also leverage the Informatica ETL to extract from the warehouse provided that they do not do any transformations in this form of data movement. These options provide users with a considerable amount of flexibility to leverage the BI Applications and add custom content and extensions. Users that are interested in a standalone ETL for a straight home grown development project should consider the Oracle Data Integrator or Informatica direct offerings.
  2. OBIA provides an OEM limited use license of Informatica not an Enterprise license. If you do not own licenses for OBIA than the Informatica software that comes bundled with the media pack are not sufficient. You need to get those installers and packs from Informatica directly.
  3. The Informatica license document is included with BIApps Install.  It lists all the restrictions about the Informatica license use so please review it before logging any SR.
  4. Data Integration Service (DIS) data cleansing etc is not part of the BIApps Infa License - you will get an error [LDTM_0084] The license does not have option to run Transformation Machine. We do not provide a license for DQ if you need this feature it needs to licensed separately from Informatica.
  5. The Pushdown Optimization Option is not part of Oracle’s OEM of Informatica. Users can go to Informatica to purchase the necessary additional license.
  6. Users do not need to license the OEM version we provide if they already have an Informatica license in house,  provided the version matches exactly to the supported and certified BIApps INFA version including patch level.  Any issues logged with out of box Oracle provided ETL which end up being Informatica problems, Support will work with Informatica directly to resolve. Any issues related to the Informatica features that are not part of the OEM (such as the grid option) should be sent directly to Informatica since we do not have a lot of experience with them.
  7. For Supported Informatica Versions for each BIApps release please review respective BIApps SRSP document on OTN - we recommend users are on the latest supported Informatica version:

=>Please Note: OBIA/BAIApps will only support customer who are using Informatica with OBIA Mappings and Warehouse as a integrated solution standalone Informatica is not part of OBIA-BIApps offering.

 

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 <Internal_Only><External_Search>The purpose of this document is to clarify which Informatica SRs can be routed to the OBIA / BI Applications Support Team.
Informatica was bundled as an ETL tool for OBI Application versions 796x, it contains the mappings to load only the target warehouse as Oracle Business Analytics Warehouse (OBAW). The last version of OBIA shipped with Informatica as an ETL tool is BI Apps 7.9.6.4. Any Informatica questions specific to the other products should be routed to the respective product support teams.
Please Note: OBIA/BIApps 11g uses Oracle Data Integration (ODI) for the ETL tool NOT Informatica)
</External_Search></Internal_Only>
 Overview
Actions
Contacts
  
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.