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
-
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…
-
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…
-
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… -
AR invoice negative amount issue via REST APIContent Hello Everyone, While creating an AR invoice with negative amount in any of the lines, the AR invoice is not getting created via REST API but when we do it manua…
-
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):…
-
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…
-
Pass Url-encoded parameters when creating OIC REST ConnectionContent Hello, I am trying to access my client environment from OIC which requires an access token first. I am able to retrieve the access token from Postman successfull…