Data Integration
Discussion List
-
Migrate ODI from one OCI tenancy to another OCI tenancy?Summary: We are planning to migrate the existing ODI services from one OCI tenancy to another ODI tenancy. Content (please ensure you mask any confidential information):… -
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…
-
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…
-
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…
-
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
-
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 …