Category 225
Discussion List
-
How to change server time in ODI Market place.Summary: Hi we have ODI Market Place and the time zone is UTC, How to make it to UTC + 3. Content (required): Hi we have ODI Market Place and the time zone is UTC, How t…Sunil Gunturu-Oracle 102 views 6 comments 2 points Most recent by Himanshu Nayak-Oracle Data Integration -
Implementing Decline reason requirement in OTM?Hi, What is the approach to implementing the decline reason requirement, and what are the different ways to develop the solution in OTM Cloud? Thanks.
-
ODI-10207 Uncategorized exception during transaction system usage.In ODI 12c when I try to run the job or run the simulation. I am getting the above error. Did anyone also face this error previously? ODI-10207 Uncategorized exception d… -
Example of a BefExport.py that runs a SQL statement on an OnPremise Database before an ExportI am trying to export data from PBCS to an On-Premise Database using EPM Integration Agent. The Data Load Rule process works and it saves the data on the table. However,…Marco Antonio Rossodivita 2 views 0 comments 1 point Started by Marco Antonio Rossodivita Data Integration
-
EPM Data exchange: unable to save data load ruleWe are facing two issues with regards to data load rules in data exchange (data load rule between to EPM environments/applications): We are not able so adjust and save e…
-
Oracle Data transforms: Use DB Sequence in Data flowSummary: Hi, I want to load a target table using Oracle Data transforms and populate ID column using a sequence. How could I achieve it? Thank you for your help. Content…
-
ODI Market Place accessIs there any way to access ODI-MP apart from VNC viewer/ Tiger VNC & Mobaxterm Due to customer security policies the above three applications are not accepting is there … -
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…
-
rrSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
In ODI, How to use same mappings if source technology is changed from MS SQL Server to OracleSummary: Hi Team, We are having one situations where MS SQL Server database objects are replicated to Oracle database for one Schema and we are having mappings which are…Dhiren Gangani-Oracle 24 views 5 comments 0 points Most recent by Dhiren Gangani-Oracle Data Integration
-
ODI Marketplace - External AuthenticationSummary: Does ODI Marketplace support for External Authentication with Azure AD / IDCS / OAuth Content (please ensure you mask any confidential information): Version (in…
-
Is ODI12c On-premise supported with Oracle DB 23 or Oracle DB23aiSummary: Is ODI12c On-premise supported with Oracle DB 23 or Oracle DB23ai Content (please ensure you mask any confidential information): Version (include the version yo…
-
Unable to retrieve data from object storage to OCI data integration data sourceSummary: Unable to retrieve data from object storage to OCI _DI due to the following error : : DIS_DATA_XPLORER_0015 - Failed to generate code Caused by: java.lang.NullP…
-
Positioning Data Integration Tool - ODI on MP vs OCI - DISummary: Which data integration tool to propose for ETL/ELT use case to load data from Fusion and other data sources to ADW - ODI on MP or OCI - DI Content (required): L…
-
Can I manage GoldenGate operations with Terraform?Summary: Attend our CCC webcast on using Terraform to provision and manage OCI GoldenGate deployments. Content (please ensure you mask any confidential information): Reg…
-
What is the best way to sync Oracle Cloud ERP data to Oracle Autonomus DatabaseSummary: We are currently using Oracle Integration Cloud application to integrate other systems with our Oracle Cloud ERP (SaaS) application. In most of the integrations…Pradeep Moganti 205 views 1 comment 0 points Most recent by Rohit Varma - Architect Data Integration
-
How to connect to OCI Services (Ex: OCI Queues)Summary: We would like to configure OCI Queues as a data source in OCI DI. Only option to use "Generic REST" as data source. Generic REST is limited to Basic Auth or OAu…Rohit Varma - Architect 11 views 0 comments 0 points Started by Rohit Varma - Architect Data Integration
-
duplicate source value from fileI had a value in source file suppose 1234, this I want to map to 2 target values, source is file target is EPM Dimension custom application, I can't use logic group as i…
-
Maturity of OCI Data Integration versus ADW Data StudioHi, What is the maturity and feature parity of OCI Data Integration versus ADW Data Studio ? Is there a comparison sheet available ? Which one should we use for integrat… -
Restart Oracle Data Integration pipeline from the failed stateHello everyone, Currently, we are using the Oracle Cloud Data Integration pipeline to run tasks that consist of data loader tasks, data integration flow and Oracle SQL p…
-
Which oracle technologies allow me to move data from postgres to snowflake?Summary: Oracle GoldenGate is a Oracle and non-Oracle database and data store replication tool. Content (please ensure you mask any confidential information): Attend an …
-
Error While Connecting to BICC - protocol is disabled or cipher suites are inappropriateWe are facing connection issue like “No appropriate protocol (protocol is disabled or cipher suites are inappropriate)” for below Oracle BI Cloud Connector topology. Err… -
What SNP table contains the columns indicating whether a mapping attribute is set to update?Good morning everyone, Am developing a script that queries the SNP tables to find all columns that shouldn't update but do. I managed to work my may down from snp_folder…
-
Getting Error while connecting to PostgreSQL from ODISummary: Error while connecting to PostgreSQL from ODI12c. Error Message :oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeEx…
-
How to load .mdb (Access File) into Oracle Table using ODISummary: .mdb File will be placed on the ODI server and need to be loaded into Oracle Table using ODI 12c. Content (please ensure you mask any confidential information):…Ritesh Kashyap-Oracle 21 views 2 comments 0 points Most recent by Ritesh Kashyap-Oracle Data Integration
-
Get Patches for ODI Marketplace 12.2.1.4Hello world, I've Just deployed ODI classic on Marketplace. However, I'm not able to access to Fusion Middleware EM: I got the following error blank page: Then, I remind…
-
while configuring HCM in PBCS we got an error as followsStarting FusionHcmAdapter main program... prod mode: importDataFromFusionHcm, pid: 201 Initializing adapter in prod mode... fusionHcmWebServiceWsdl: https://fa-emqz-dev7…
-
Archiveing SAP legacy data to OCISummary: We are implementing Oracle Cloud for a client with a SAP legacy system. Our plan is to migrate the latest/top of the stack data to the cloud. However, the clien…Chandramouli Yangareddy 13 views 0 comments 0 points Started by Chandramouli Yangareddy Data Integration
-
FDMEE v 11.1.2.4 - Unable to invoke ODI process errorSummary: Files started loading on 7/29/23. First few files loaded. Then, received error 'EPMFDM-140160:Unable to Invoke ODI process.' Files haven't loaded since. Not sur…
-
How to load the .dmp file into Oracle DatabaseSummary: I have files sftp'd to the ODI Server. Ask is to load the data of the .dmp file into Oracle Database Table via ODI. Can anyone help here how to achieve this. Co…Ritesh Kashyap-Oracle 12 views 2 comments 0 points Most recent by Ritesh Kashyap-Oracle Data Integration