Category 225
Discussion List
-
Getting error while start and stop of the odiAgentSummary: Not able to start ODI Agents scripts used for Agent Start sudo systemctl start agentodi.service Content (required): This is the current status of the agent: age… -
JNPE error with Reusable Mapping ComponentSummary: Mappings having reusable mapping components throw a fatal validation error: JNPE at ReusableMappingComponent.findrmcattributeforsignatureattribute. Please check…Debadrita Ghosh-Oracle 21 views 1 comment 1 point Most recent by Narasimharao Popuri-Oracle Data Integration -
Can OCI Data Integration connect with "Azure Data Lake GEN2"Summary: Hi All, Can anyone help to let me know if OCI Data Integration can connect with "Azure Data Lake Gen2" or in general terms "Azure Cloud DB GEN2"? Content (requi…
-
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… -
Unable to start ODI instanceSummary: I'm not able start my ODI instance from terminal suddenly. earlier i used to start from here and access ODI studio. Content (required): Version (include the ver…
-
Real time replication of data from FusionSummary: Is there any solution/product available that allows replication of data from Fusion ERP using Golden Gate Services? Content (required): Version (include the ver… -
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 11 views 4 comments 1 point Most recent by Bapiraju Swamy Vuda-Oracle Data Integration -
How to Configure microsoft 365 Email for sending emails via ODI - Missing OptionsSummary: We have ODI 12.2.1.4.0 on prem ODI And how are we supposed to use Microsoft 365 EMail exchange for sending emails. Content (required): Microsoft 365 email authe…
-
Connecting Oracle Golden Gate Cloud Instance to Oracle Fusion Cloud(ERP/HCM) DATABASESummary: Data Replication from Oracle Fusion Cloud(ERP/HCM) DATABASE to Oracle Autonomous Data Warehouse Content (required): How can we leverage Oracle Cloud Golden Gate… -
Is ODI Marketplace built on OCI Gen 2?Summary: Customer wants to keep track of the platform on which Oracle's services are built. As part of that initiative, Customer wants to know if the ODI Marketplace the…
-
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 41 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 62 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 61 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 11 views 0 comments 2 points Started by Debadrita Ghosh-Oracle Data Integration
-
Oracle Integration Cloud and ADPSummary: Hello everyone, Is it possible to build an OIC integration to ADP? Are there connectors in OIC for ADP? Thank you in advance for your help. Content (required): …Daniel McMillian 31 views 1 comment 0 points Most recent by Narasimharao Popuri-Oracle Data Integration
-
ODI Load Plan as REST API ServiceSummary: We have requirement for calling ODI load plan in VBCS UI so as to refresh data or run the data load. Currently we are using ODIInvoke webservice which is config…
-
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 31 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 84 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 31 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
-
Individual mapping is running fine but while running same in load plan getting failedSummary: Individual mapping is running fine but while running same in load plan getting failed with error message : Table or View doesn't exist Solution to resolve to sa…Indra Sardana-Oracle 11 views 5 comments 0 points Most recent by Indra Sardana-Oracle Data Integration
-
Populate "Last Extract Date" parameter in OCI Data Integration pipelineSummary: Unable to pass a value to the parameter type "Last Extract Date" in an OCI Data Integration pipeline. Content: Hi Experts, I'm new with OCI Data Integration and… -
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 73 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 …
-
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…
-
question: are there tools in oci data integration for create zip file from files eg: in bucket?Summary: Content (required): are there tools in oci data integration for create zip file from files eg: in bucket? have a capability to create zip files present on Oracl…
-
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…