Oracle Data Integrator
Discussion List
-
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 22 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 62 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 173 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 112 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 41 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 162 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 123 views 6 comments 8 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 62 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 42 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 199 views 7 comments 0 points Most recent by Amrita Gupta-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 … -
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 41 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…
-
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 102 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…
-
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 32 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 142 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 42 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 32 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 22 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…
-
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 …Mandar -Oracle 364 views 4 comments 0 points Most recent by Venkat Koduvayur-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 43 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