Extract Transform Load - ETL
Discussion List
-
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 67 views 6 comments 5 points Most recent by Shaik Gousimiya-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… -
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 14 views 2 comments 0 points Most recent by Bharath Raghupathi-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 12 views 2 comments 2 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…
-
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 88 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 14 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 … -
Setting prune time for a PVO extraction using Fusion BICCCSummary: We need to extract Fusion PVO data using BICCC job. We will be creating a job in Fusion BIACM and trigger that job from ODI and load data into ADW. We have a re…Sahithi Kolasani-Oracle 6 views 0 comments 0 points Started by Sahithi Kolasani-Oracle Data Integration
-
Errors while using parallel processing in ODI Load plan.Summary: I have created a load plan in ODI that has 10 scenarios and configured it as parallel processing. These scenarios reads a file and stores them in target tables …
-
Improve productivity with Oracle Cloud Infrastructure Data Integration’s latest release - Nov 5 2021New blog about OCI Data Integration’s newly released: https://blogs.oracle.com/cloud-infrastructure/post/new-oci-data-integration-release-adds-support-for-hierarchical-d…
-
How to ignore trailer row in ODI?Summary How to ignore trailer row in ODI?Content We receive a file which has trailer row at the bottom with total number of rows. Is there a delivered feature in ODI to …
-
Oracle Fusion to Google Cloud BigQueryContent Our DW is Google Cloud BigQuery, and we are exploring ways in which we could push Oracle Fusion data to Google Cloud BigQuery in most cost effective and efficien… -
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…Shabeebah Abdoolsamee 109 views 0 comments 1 point Started by Shabeebah Abdoolsamee Data Integration
-
connecting the OCI DB from the Autonomous WarehouseContent Client is implementing a ADW on cloud. Scenario is as follows: 1. Source: DB available on cloud (node#2) 2. Target: ADW is available on cloud (node#3) 3. ODI ins…Rehan Ahmed Khan-Oracle 7 views 2 comments 0 points Most recent by Anubhav Bhardwaj Data Integration
-
Improve productivity with Oracle Cloud Infrastructure Data Integration’s latest releaseContent New blog about OCI Data Integration’s newly released: https://blogs.oracle.com/cloud-infrastructure/post/improve-productivity-with-oci-data-integrations-latest-r…
-
Migrate On-prem Essbase Data to Oracle EPM CloudContent we have a use case to migrate 1.8 Million or more records from on-premise Hyperion Essbase to Oracle EPM - PBCS cloud SaaS Application. We see limitation on FDME… -
New Oracle Cloud Infrastructure Data Integration release adds pipelines and orchestrationContent We're excited to announce a new release of Oracle Cloud Infrastructure Data Integration. This release adds new transformations, connectors, and two of the most h…
-
Can we connect to LDAP using ODI or OIC?Summary Can we connect to LDAP using ODI/OIC?Content Is it possible to connect to LDAP using ODI? We did like to get the group membership of a certain AD stored in our c…
-
New Oracle Cloud Infrastructure Data Integration release focuses on connectivity and transformationsContent We're excited to announce a new release of Oracle Cloud Infrastructure Data Integration. This release expands connectivity options, transformation capabilities, …
-
Using Oracle Cloud Infrastructure Data Integration with MySQL Database Service and HeatwaveContent Virtually all data types from any data source can be integrated into the MySQL Database Service and HeatWave. When you need to collect data from diverse sources …
-
Best approach to read Excel Spreadsheet using odi 12cSummary Best approach to read Excel Spreadsheet using odi 12cContent Hi Team, Can you please suggest an approach to read the Excel files using odi , do we need ODBC/JDBC… -
API Endpoint to provide a List of UsersSummary Looking for an API Endpoint to provide a List of UsersContent I am assisting the development of a Rest API between Oracle Cloud and a third-party mobile app. As …
-
Error while trying to create a connection to an oracle data integrator cloud service agentSummary When trying to save a database connection associated with a data preparation agent, the following error occurs: Unable to update Oracle DB Client in GG instance …
-
question on ODI from marketplaceSummary multiple agents possible ?Content as I understand ODI from marketplace comes with its own embedded repository (which is not Oracle database, but mysql). in such …
-
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 40 views 3 comments 0 points Most recent by RamRayaprolu Data Integration
-
Can ODICS Connect to Fusion CloudSummary Connecting ODICS to Fusion CloudContent Hello Experts!! I am trying to move data from fusion cloud to PaaS DBCS. We are currently using BICC and Datasync. Can OD…