To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Data Integration
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… -
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,…
-
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…
-
Load rules are taking longer than usual after migrating from non-enterprise to enterpriseSummary: We are doing Planning application migration from Legacy to Enterprise, after doing migration DataManagement load rules are taking longer than usual in the "Tran…
-
EPM Pipeline job sequence executing before prior job completesSummary We are seeing in some instances that the within a Pipeline "integration" that jobs which run long will have the next job in the stage execute (and parallel is no…
-
How to replicate Oracle HCM Cloud base tables into AWS Redshift?How to replicate Oracle HCM Cloud base tables into AWS Redshift? We tried Fivetran . But it uses BICC connector and replicates PVOs not base tables. We looked at Golden …
-
Pipeline with Conditional LogicSummary: Wondering if anyone has been able to achieve conditional logic inside of a Pipeline? Our goal is to create an ad-hoc execution of various different data loads t…
-
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…
-
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… -
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…
-
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…
-
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…
-
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…
-
The Page you requested cannot be accessedSummary Only the OIC instance creator is able to access the instance.Content I just created a new OIC instance and all users, except the that created the OIC instance, a… -
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…
-
Unable to load Calculation card Component detail DFF infoHi Team, I'm trying to load Calculation card Component detail DFF info for State umemployment Self Adjustment method via below HDL but it is not happening and giving thi…