Extract Transform Load - ETL
Discussion List
-
Upgrade from ODI Studio to OCI Data IntegrationSummary: We've received a request from a client regarding the possibility of upgrading their current version of ODI Studio to OCI Data Integration (Cloud Infrastructure … -
Can an EPM Agent AftExport Writeback Event Script return an error back to EPM Cloud Data Exchange?Summary: We are using EPM Integration Agent to writeback data from FCCS and PBCS integrations to an on-prem database table and then run a script in the Agent AftExport e…
-
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…
-
EPM Agent EBS Preseeded QuerySummary: From Planning I set up a "EBS GL Balance" app and can execute the Preseeded Query against the agent, I see the query string it in the log. How do I modify the "…
-
ODI-10207 Uncategorized exception during transaction system usage.In ODI 12c when I try to run the job or run the simulation. I am getting the above error. Did anyone also face this error previously? ODI-10207 Uncategorized exception d… -
Example of a BefExport.py that runs a SQL statement on an OnPremise Database before an ExportI am trying to export data from PBCS to an On-Premise Database using EPM Integration Agent. The Data Load Rule process works and it saves the data on the table. However,…Marco Antonio Rossodivita 5 views 0 comments 1 point Started by Marco Antonio Rossodivita Data Integration
-
Oracle Data transforms: Use DB Sequence in Data flowSummary: Hi, I want to load a target table using Oracle Data transforms and populate ID column using a sequence. How could I achieve it? Thank you for your help. Content…
-
duplicate source value from fileI had a value in source file suppose 1234, this I want to map to 2 target values, source is file target is EPM Dimension custom application, I can't use logic group as i…
-
Maturity of OCI Data Integration versus ADW Data StudioHi, What is the maturity and feature parity of OCI Data Integration versus ADW Data Studio ? Is there a comparison sheet available ? Which one should we use for integrat… -
Restart Oracle Data Integration pipeline from the failed stateHello everyone, Currently, we are using the Oracle Cloud Data Integration pipeline to run tasks that consist of data loader tasks, data integration flow and Oracle SQL p…
-
Which oracle technologies allow me to move data from postgres to snowflake?Summary: Oracle GoldenGate is a Oracle and non-Oracle database and data store replication tool. Content (please ensure you mask any confidential information): Attend an …
-
Getting Error while connecting to PostgreSQL from ODISummary: Error while connecting to PostgreSQL from ODI12c. Error Message :oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeEx…
-
How to load .mdb (Access File) into Oracle Table using ODISummary: .mdb File will be placed on the ODI server and need to be loaded into Oracle Table using ODI 12c. Content (please ensure you mask any confidential information):…Ritesh Kashyap-Oracle 21 views 2 comments 0 points Most recent by Ritesh Kashyap-Oracle Data Integration
-
Pass Url-encoded parameters when creating OIC REST ConnectionContent Hello, I am trying to access my client environment from OIC which requires an access token first. I am able to retrieve the access token from Postman successfull…
-
oracle data transform in OCIIn Oracle Data transform in OCI, can we able to define the user privileges for different user. Supervisor has all access whereas can we able to provide only read access …Amirthavalli Chidambaram 11 views 0 comments 0 points Started by Amirthavalli Chidambaram Data Integration
-
RCU creation in ODI-MPWe are getting below error while trying to create RCU in ODI-MP. Both Ingress and Egress rules were set between ODI-MP and ADW and vice versa. Please suggest if any one …Bapiraju Swamy Vuda-Oracle 21 views 1 comment 0 points Most recent by Debadrita Ghosh-Oracle Data Integration -
How to configure ODI to use RESTful Services with OAUTH2Summary: How to configure ODI to use RESTful Services with OAUTH2 We can use Oracle Web Services Manager for ODI to use RESTful Services with OAUTH2 but what all configu… -
Integration UsecaseSummary On Prem DB to SaaS IntegrationContent Dear Experts, We are evaluating PaaS offerings to implement the following Integration use case : Integrate transactional da…Raghavendra Manchigiah-109385 69 views 4 comments 0 points Most recent by Priyanka Girdhar Data Integration
-
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 …
-
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 97 views 3 comments 0 points Most recent by Debadrita Ghosh-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 55 views 3 comments 0 points Most recent by SukantaBarari-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
-
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 121 views 6 comments 8 points Most recent by Shaik Gousimiya-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 …
-
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…
-
Hi team, we are planning to integrate Oracle golden gate using peoplesoft source systemSummary: we are planning to integrate Oracle golden gate using people-soft as source system for a customer to fetch the delta data. Content (required): We are planning t…Shaik Gousimiya-Oracle 31 views 2 comments 4 points Most recent by Shaik Gousimiya-Oracle Data Integration
-
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… -
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 331 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Data Integration -
Connecting On Premise ODI with Oracle UCM ServerWe need to extract data (BICC Extracts) from Oracle UCM Server, can we connect from on-premise ODI 12.2.1.3 or 12.2.1.4 version to Oracle UCM? Any suggestions?SaurabhJaiswal-Oracle 31 views 0 comments 0 points Started by SaurabhJaiswal-Oracle Data Integration -
Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only …