Oracle Data Integrator
Discussion List
-
Is there a way to use Object Storage logical folders while using the "LKM BICC to ADW Copy" ?Summary: Currently we are building data warehouse using Fusion saas data. We are using BICC for data extraction and ODI to consume the BICC extracts. We are using "LKM B…Bharath Raghupathi-Oracle 11 views 2 comments 0 points Most recent by Bharath Raghupathi-Oracle Data Integration -
ODI mapping failing with the error message - “Read timed out”ODI mapping is failing with the error message - "Read time out" Error Message : java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0…Indra Sardana-Oracle 1 view 1 comment 0 points Most recent by Bharath Raghupathi-Oracle Data Integration -
Options to extract data from BIP Report and load it to ADW via ODIContent (required): I wanted to know what is the best way or options to extract data from the BIP Report (in Fusion) and load this data to ADW with the use of ODI. We ar… -
How to read an Excel file via ODI 12c?Summary: Hi Team, Could anyone please guide me on the below requirements related to excel file parsing using ODI - Read the excel file placed in a local folder via ODI 1…
-
Error Connecting to BICC url using ODISummary: Error Connecting to BICC url using ODI Content (required): Hi All , While connecting to BICC through ODI topology, we are facing error as below. Agent is j2ee a…
-
Error while installing ODI in window m/c Error message : The permanent log directory is unknownWhile installing ODI on local machine in Window m/c getting error message : :::::::::::::::::::::::::::: at oracle.as.install.engine.InstallEngine.startOperation(Install…Indra Sardana-Oracle 21 views 5 comments 0 points Most recent by Indra Sardana-Oracle Data Integration
-
Can we use ODI to retrieve and parse an Excel spreadsheet hosted on SharePoint?Summary: Hi Team, The requirement is to retrieve and parse an Excel spreadsheet hosted on SharePoint via ODI 12c. Content (required): Is there any OOTB KM we can use to …
-
PLS-00172: string literal too long while loading BICC PVO data using ODI MarketplaceSummary: We are trying to load data from Fusion BIACM JournalEntryLinePVO into ADW using ODI-Marketplace. This Job fails with below error. ERROR ----------- ODI-1590: Th…Sahithi Kolasani-Oracle 31 views 3 comments 0 points Most recent by Sahithi Kolasani-Oracle Data Integration -
Issue with "BICC to ADW Copy" LKMSummary: Hello, While running mappings with "BICC to ADW Copy" LKM, data loads are failing with ORA-20006: Unsupported object store URI error message. We are using We ar…Bharath Raghupathi-Oracle 21 views 6 comments 0 points Most recent by Bharath Raghupathi-Oracle Data Integration
-
Unable to load BICC PVO using ODI-MSummary: Recently we are coming across the following error randomly for some of the PVOs. ODI-1590: The execution of the script failed. Caused By: javax.script.ScriptExc…Sahithi Kolasani-Oracle 1 view 0 comments 0 points Started by Sahithi Kolasani-Oracle Data Integration
-
How to integrate Kafka with ODI 12c Market Place and bring data to ADW DBSummary: We have a new requirement where we need to integrate Kafka to ODI 12c Market Place. Content (required): I went through this document where it is mentioned how t…
-
Integrating ODI12c with HadoopHello Team, Need some inputs on integration of ODI with Hadoop as a target with transformations. Has anyone done similar setup with ODI 12c? Would like to have a quick c…Amit Pimparkar-Oracle 11 views 1 comment 0 points Most recent by Shaik Gousimiya-Oracle Data Integration
-
How to generate authentication token to pull the source files via API service calls using ODI12c ?Summary: Is there a way to generate and pass the authentication token dynamically for each file for the Restful API calls? Content (required): We need to pull json files…Shaik Gousimiya-Oracle 31 views 2 comments 9 points Most recent by Shaik Gousimiya-Oracle Data Integration -
Connecting On Premise ODI to Oracle BI Cloud ConnectorSummary: Hi Team, We are looking to create the connection with BICC(Business Intelligence Cloud Connector) through ODI- On Premises (ODI 12.2.1.3 or 12.2.1.4 version). a…
-
BICC Cloud Connector technology for on premise ODI12cHello Experts, we need to extract Fusion data to object storage from on premise ODI 12c. However unlike ODI MP where we have Oracle BI Cloud Connector technology drivers…Amit Pimparkar-Oracle 11 views 0 comments 0 points Started by Amit Pimparkar-Oracle Data Integration
-
Fusion Data Extraction to on premise DBHi Experts We are working with a large telecom customer in India who is in process of Fusion implementation across modules. They want to leverage on premise setup for th…
-
CICD integration with ODI ( Git/ Subversion)Hello Team, Need some details around challenges faced during CICD integration with ODI 12c ( Git/ Subversion). Please let us know if anyone implemented the same. Regards…
-
Loading Data in FBDI Template file using ODISummary: Loading Data in FBDI Template file using ODI Content (required): Hi, Customer wants to load data into FBDI template file using ODI. Source is staging table (Ora…
-
IBM DB2/400 Connectivity Issue in ODISummary: We are trying to connect to IBM DB2 / 400 database in ODI but getting driver issue after configuring and testing connection in topology Content (required): As s…
-
Connecting to Amazon S3 using ODISummary: Connecting to Amazon S3 using ODI Content (required): Hi, We need information about how to connect/Configure Amazon S3 using ODI 12c.Kindly guide if anyone has …
-
Triggering FCCS Data Management Job from ODISummary: Trigger Data Management job and extract data files from FCCS to ODI/ADW. Content (required): We are able invoke REST API GET and POST Methods from Soap and trig… -
Need SNP Query for data lineage from source 2 target table in mapping involving re-usable mappings.Summary: Need SNP Query for data lineage from source to target table in mapping involving re-usable mappings. Content (required): We have several mappings in our project…Sunil Gunturu-Oracle 11 views 1 comment 0 points Most recent by SukantaBarari-Oracle Data Integration
-
ODI CS to ODI MP migration pathSummary: We have a customer on ODI CS, who are looking to migrate to ODI Market Place (since ODI CS is being sunsetted). Seeking advice on the best approach to migrate f… -
Positioning Data Integration Tool - ODI on MP vs OCI - DISummary: Which data integration tool to propose for ETL/ELT use case to load data from Fusion and other data sources to ADW - ODI on MP or OCI - DI Content (required): L…
-
How can we import Master and Work repository with code components when present in multiple folders?Summary: Master and Work repository with code components present in multiple folders, how can we import to new instance in single go? Content (required): We have receive…Bapiraju Swamy Vuda-Oracle 31 views 2 comments 9 points Most recent by Bapiraju Swamy Vuda-Oracle Data Integration -
Agent test failed while creating it inside Master repository in ODI StudioSummary: Content (required): Hi team, While I have installed the ODI Studio and started installing schemas through RCU facility, I was getting errors initially while cre…
-
ODI source connection supportSummary: We are trying to check if ODI supports connectivity to the oracle sources listed below - 1.CPQ 2.Oracle Field Service(OFS) 3.Global Trade Management. Looking fo…
-
ODI Salesforce integrations are very slow, looking for performance enhancement possibilitesSummary: We have an integration setup using ODI, which extracts data from Salesforce. While it works fine, the processes take a long time to run. We created equivalent p…
-
EDQ Topology Connection failing when Testing with Java Agent (On Prem ODI)Summary: EDQ Topology Connection failing when Testing with Java Agent (On Prem ODI), but works fine with Local Agent Content (required): We are having Oracle PCA where O…
-
Unable to import code from higher ODI version to lowerSummary: While we are trying to import ODI code from higher ODI version to lower, we are facing the error ODI-14255: Import file has repository version 05.02.02.11 newer…Sahithi Kolasani-Oracle 51 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Data Integration