Oracle Data Integrator
Discussion List
-
Is there a historical data store or PVO for Person Type?Summary: PVO for Person Type is not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Type. Available… -
Is there a historical data store or PVO for Person Name?Summary: PVO for Person Name is not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Name. Available…
-
Is there a historical data store or PVO for Person Email Address?Summary: PVO for Person Email Address is not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Email …
-
Is there a historical data store or PVO for Person Address?Summary: PVO for Person Address are not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Address. Av…
-
Calling OCI Function From ODISummary: HI Team, Can we call a Rest API generated from OCI from ODI 12c? If yes, then please provide us the steps. Content (required): Version (include the version you …
-
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…
-
Getting error while start and stop of the odiAgentSummary: Not able to start ODI Agents scripts used for Agent Start sudo systemctl start agentodi.service Content (required): This is the current status of the agent: age…Ritesh Kashyap-Oracle 153 views 3 comments 0 points Most recent by Ritesh Kashyap-Oracle Data Integration
-
Is Effective Date Disabled checkbox shared to all offerings?Summary: Effective Date Disabled checkbox is selected to other offerings too when I only enabled it on the offering I have created. Content (required): When I tried to s…
-
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 888 views 7 comments 0 points Most recent by Ankur Shrivastava Data Integration -
Unable to connect to ODI AgentSummary: I have installed ODI12c in my system and trying to connect agent. Even if the NodeManager is up, weblogic server is in "FAILED_NOT_RESTARTABLE" state. And when …
-
Error while trying to delete ODI foldersSummary: An error was thrown while trying to delete some folders from ODI MP repository. It was thrown on both manual deletion and deletion via SDK. The folders have map…Debadrita Ghosh-Oracle 134 views 6 comments 3 points Most recent by Debadrita Ghosh-Oracle Data Integration -
Supports incremental not working when Disabled Effective Date field is checked in BICC.Summary: For some data store, Supports incremental is not working when Disabled Effective Date field is checked in BICC. Content (required): Why for some data store Supp…
-
Triggering Full Load in BICC from ODI MarketplaceSummary: Have anyone worked on Triggering of FUll Load in Fusion BICC directly from ODI marketplace? Any advise appreciated. Content (required): We are able to trigger B…Moumita Samanta-Oracle 44 views 2 comments 0 points Most recent by SukantaBarari-Oracle Data Integration -
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…Partha Kar-Oracle 82 views 3 comments 0 points Most recent by Debadrita Ghosh-Oracle Data Integration
-
ODI Web Edition is giving Driver class name must not be empty while setting up data loadSummary: ODI Web Edition is giving Driver class name must not be empty while setting up data load Content (required): I have setup connect to ERP Cloud as type Oracle BI…
-
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…Jahnavi-Oracle 273 views 13 comments 0 points Most recent by Bala Mahalingam-Oracle Data Integration -
How to configure CLI to control objects in OCI Object StorageSummary: I have a requirement to upload the EPM backup files from file server to object storage via ODI. I am able to upload the file to object storage via uploadobjects…Ritesh Kashyap-Oracle 31 views 1 comment 0 points Most recent by SukantaBarari-Oracle Data Integration
-
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 41 views 3 comments 0 points Most recent by SukantaBarari-Oracle Data Integration -
JNPE error with Reusable Mapping ComponentSummary: Mappings having reusable mapping components throw a fatal validation error: JNPE at ReusableMappingComponent.findrmcattributeforsignatureattribute. Please check…Debadrita Ghosh-Oracle 92 views 4 comments 2 points Most recent by Debadrita Ghosh-Oracle Data Integration
-
Invalid credentials for supervisor password after ODI Web configurationSummary: Configured ODI Web Stack with ATP database and getting invalid credentials even after using the password configured during data repository configuration Content…
-
Getting provisioning message for ODI Web EditionSummary: I am getting Provisioning and below message every time I open data transformations screen to launch Web ODI screen The requested resource is currently unavailab…
-
recommendation for the VM of the ODI on Market PlaceSummary: Dear All Do you have any recommendation for the VM of the ODI on Market Place, please ? OCPUs, RAM, Disk etc. Content (required): Recommendation for the VM of t… -
Unable to start ODI instanceSummary: I'm not able start my ODI instance from terminal suddenly. earlier i used to start from here and access ODI studio. Content (required): Version (include the ver…
-
Is there any way to call multiple Load Plans from different servers and agents one after another?Summary: Is there any way to call multiple Load Plans from different servers and agents one after another? Content (required): We are having a requirement like to call m…Bapiraju Swamy Vuda-Oracle 21 views 4 comments 1 point Most recent by Bapiraju Swamy Vuda-Oracle Data Integration -
In ODI variable expected output is date but o/p generating as timestampIn Definition Variable Data Type : Alphanumeric Query : Select sysdate from dual ; O/P generating : 06-04-2023 12:00:00 Where as expected O/P : 06-Apr-2023 Tried setting…Indra Sardana-Oracle 61 views 17 comments 0 points Most recent by Anirban Basu-133546 Data Integration
-
ODI using SQL Unloader generate CSV FileSummary: ADW as a source system We are using ODISQLUNLOAD to generate comma separated CSV files . We are using union to cominbe the table columns and header Now as a res…Indra Sardana-Oracle 153 views 3 comments 0 points Most recent by Indra Sardana-Oracle Data Integration
-
Using ODI and ADW as source can we generate Parquet file as outputSummary: Using ODI and ADW as source can we generate Parquet file as output ,if yes any support document on same.Indra Sardana-Oracle 111 views 5 comments 1 point Most recent by Indra Sardana-Oracle Data Integration
-
Pass JSON as a startup parameter to ODI scenarioSummary: Hi team, We have a requirement to generate a JSON request in ODI, pass it to an API and log the same request details in a database table. We created an ODI proc…Debadrita Ghosh-Oracle 42 views 0 comments 3 points Started by Debadrita Ghosh-Oracle Data Integration
-
DB link feature works between On-Prem Oracle DB to Oracle ADW?Summary: We need to create a DB link between On-Prem database and Cloud (ADW) database, is there any specific steps we need to taken care before doing this? Or Could you…Bapiraju Swamy Vuda-Oracle 155 views 2 comments 2 points Most recent by Bapiraju Swamy Vuda-Oracle Data Integration
-
Is on-prem ODI 12.2.1.3 needs to be upgraded to latest version 12.2.1.4 before migrating to Cloud?Summary: Hi Team, Customer is planning to migrate entire DWH to Oracle cloud. Currently we are using ODI 12.2.1.3 & Oracle 19c DB in an on-prem environment. I need to un…Shaik Gousimiya-Oracle 111 views 6 comments 8 points Most recent by Shaik Gousimiya-Oracle Data Integration