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… -
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…
-
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…
-
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 …
-
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… -
Oracle Data Transforms: Load Data from object storage to Autonomous DBSummary: Hi All, I have CSV file stored into object storage and my requirement is to load csv file content into table in autonomous database using Oracle Data Transforms…
-
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…
-
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…
-
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…
-
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):…
-
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…
-
Could we provision ODI console in marketplace with MySQL repo?Hello All, We have ODI Marketplace instance on OCI Compute The Repository is in underlying MySQL Database Questions - Is it possible to configure and provision ODI Conso…
-
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…
-
oracle data transform in OCIIn Oracle Data transform in OCI, can we able to define the user privileges for different user. Supervisor has all access whereas can we able to provide only read access …
-
Can you use query parameters with invoke SOAP adapter in OIC?Summary: Hello, We have an OIC integration that invokes the on-premise app (PeopleSoft) with SOAP adapter. With this we were able to create new data (location data) in P…
-
ODI Invoke RESTful service hangs when loading large (2GB) fileSummary: Trying to load a 2GB file generated by ODI to EPM using REST API. The REST API call step shows running for more than two hours with no error and the file is not…
-
Is there a historical PVO for person that contains all the DFF fields?Summary: No available historical PVO that pulls all person details that includes dff. Content (please ensure you mask any confidential information): I'm trying to find a…
-
Is there a historical PVO that pulls Person Details?Summary: No available historical PVO that pulls all person details. Content (please ensure you mask any confidential information): I'm trying to find a data store/PVO th…
-
How to SFTP file load to UCM content server via ODISummary: Hi Team, Content (please ensure you mask any confidential information): How to FTP file load to UCM content server (SOAP service) via ODI Version (include the v…
-
How to convert zip file to base64 in Oracle Data Integrator toolHi Team, I tried to convert the file to base64 data in the ODI tool. Can anyone help with this concept? Thanks Prakash Jayavel
-
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…
-
Fusion UCM data files load into Snowflake using OCI Data IntegrationSummary: Hi Team, We are able to extract Oracle HCM cloud data using BICCC extracts and now files are available in UCM. Now we want to leverage OCI Data Integration serv… -
RCU creation in ODI-MPWe are getting below error while trying to create RCU in ODI-MP. Both Ingress and Egress rules were set between ODI-MP and ADW and vice versa. Please suggest if any one … -
Connect OCI DI to Azure Blob (as target) to move Oracle UCM data files (from oracle fusion cloud)Summary: We are looking for approach to connect OCI DI to Azure blob as target storage for data files. These data files are available in Oracle UCM, as part of BICCC - P…
-
Setting policies for OCI-DIHi, Even with right policies we cannot define object storage as a data asset (Timeout: Its taking longer than expected. Ref Id - 2aa97cd6-c4af-4d31-b23d-8071da4c48c7) Ha… -
Is there a PVO that pulls Pay Calendar information?Summary: No available historical PVO that pulls pay calendar information. Content (required): I'm trying to find a data store/PVO that pulls pay calendar information but…
-
Is there a historical PVO that pulls the Asssignment EIT?Summary: Historical PVO for Assignment EIT doesn't exist. Content (required): I am not able to find a historical PVO for Assignment EIT. Available PVO is filtered using …
-
Is there available BICC PVO for Seniority Date?Summary: No available PVO for employee's seniority dates. Content (required): I'm trying to find a data store or PVO that is pulling the employee's seniority date but un…
-
Invoke ODI load plan from APEXSummary: Invoke ODI load plan start and stop from APEX Content (required): Kindly suggest the options to invoke ODI load plan start and stop from APEX. Also please provi…