Oracle Data Integrator
Discussion List
-
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…Nilanjan Biswas-Oracle 13 views 2 comments 0 points Most recent by Nilanjan Biswas-Oracle 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…
-
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 21 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 62 views 6 comments 4 points Most recent by Shaik Gousimiya-Oracle Data Integration -
Getting error while connecting to Rest Service in ODI using OdiInvokeRESTfulServiceSummary: When testing Rest Service connection, getting following error- PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException .Facing thi…Indra Sardana-Oracle 32 views 8 comments 0 points Most recent by Indra Sardana-Oracle Data Integration
-
ODI is picking old version of python instead of latest version of PythonMultiple version of Python is installed and ODI market place is picking old version of python instead or latest version while calling in ODI command tool. How to resolve…Indra Sardana-Oracle 21 views 5 comments 0 points Most recent by Indra Sardana-Oracle Data Integration
-
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… -
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 51 views 7 comments 0 points Most recent by Amrita Gupta-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 41 views 2 comments 1 point Most recent by Indra Sardana-Oracle Data Integration
-
Does ODI-Marketplace (free version) allow for SFTP of file from on-premise to Object/Block storageSummary: We plan to have IPSec VPN connectivity between OCI and Customer Data Center Customer plans to have some files placed on-premise in a windows directory We would …
-
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 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… -
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 84 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 -
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 41 views 2 comments 10 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 12 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…