Category 225
Discussion List
-
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 42 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle Data Integration -
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… -
Unable to test connection to Azure SQL Server data asset in OCI Data IntegrationSummary: Created a data asset to connect to a sql server database in MS Azure. While testing the connection getting an error related to client IP not allowed to connect …
-
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 …
-
OCI Data Integration - Filter using row_number() over in Data FlowI'm hoping this is something obvious that I'm overlooking. What I'm trying to achieve is filtering a data source (ADW table) by partition and only keeping the top row fo…
-
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 101 views 3 comments 0 points Most recent by Sahithi Kolasani-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 32 views 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…
-
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 -
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 31 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 141 views 2 comments 11 points Most recent by Shaik Gousimiya-Oracle Data Integration
-
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 51 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…Amit Pimparkar-Oracle 34 views 0 comments 0 points Started by Amit Pimparkar-Oracle Data Integration
-
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…Amit Pimparkar-Oracle 21 views 0 comments 0 points Started by Amit Pimparkar-Oracle Data Integration
-
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…
-
ODI Agent unable to run Python Program but local agent is able to runSummary: We have ODI agent and ODI installed in the same machine, we are using ODI Marketplace. With local agent we are able to call python program using odioscommand bu…Sunil Gunturu-Oracle 28 views 1 comment 0 points Most recent by Sunil Gunturu-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… -
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 67 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… -
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 42 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 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 348 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 -
Function strange behavior when invoked via API gatewaySummary: The function behavior is not consistent when I invoke it via API gateway. i have function that merges pdf and writes the merged file to a ftp location. When i t…
-
ODI Text to columnsSummary: Looking for a text to columns function within ODI Content (required): Hello, We're migrating from Alteryx to ODI. The Alteryx tool has a very straight forward "…Brian Watkins-Oracle 12 views 2 comments 0 points Most recent by Brian Watkins-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 … -
Data Entity doesn't load data through Fusion Data AssetSummary: It was creating a Fusion Data Asset and configured the Oracle Business Intelligence Cloud Connector Console. The connections are work fine, but when create a da…