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
-
Errors while using parallel processing in ODI Load plan.Summary: I have created a load plan in ODI that has 10 scenarios and configured it as parallel processing. These scenarios reads a file and stores them in target tables … -
Cloud ODI - Processing multiple files from Object StorageSummary: Looking into how to process multiple files from Oracle Object Store into Autonomous Database in same tenancy. Content (required): New to ODI. Trying to work out… -
ODI Data Flow, Object Storage Schema ErrorsSummary: Creating a new Data Flow, to Object Storage based Source Operator using tested Data Assets (objects in object storage) giving validation errors: Cannot resolve …
-
Improve productivity with Oracle Cloud Infrastructure Data Integration’s latest release - Nov 5 2021New blog about OCI Data Integration’s newly released: https://blogs.oracle.com/cloud-infrastructure/post/new-oci-data-integration-release-adds-support-for-hierarchical-d… -
Oracle Data Integrator Agent JMXSummary: When you provision the Market Place ODI image the agent it comes with a standalone agent. When the agent starts up it logs the following message to the log file… -
Can Oracle Data Integration Connect directly to File system?Summary: We're replacing our current ETL tool (alteryx) and looking into various options. Our current solution picks up files from both zfs and an nfs file system, perfo…
-
How do you add a supervisor to a worker using HSDL?Summary: Currently unable to assign supervisor to newly created workers with HSDL. Can anyone provide an example template? Content (required): Can anyone provide an HSDL…
-
Import Questions via HDLSummary Import Questions via HDLContent Hi, Can someone please help on how to upload Questions (For Questionnaire) through HDL in Fusion? Regards, Vivek R S -
How to ignore trailer row in ODI?Summary How to ignore trailer row in ODI?Content We receive a file which has trailer row at the bottom with total number of rows. Is there a delivered feature in ODI to …User_2025-01-25-04-02-13-126 37 views 2 comments 0 points Most recent by User_2025-01-25-04-02-13-126
-
Oracle Fusion to Google Cloud BigQueryContent Our DW is Google Cloud BigQuery, and we are exploring ways in which we could push Oracle Fusion data to Google Cloud BigQuery in most cost effective and efficien… -
Integration to DBCS directly from on premise Data baseSummary How could we directly move Table to Table on premise to DBCS Custom tablesContent I am looking some easy approach to move data from EBS on premise Data bases cus… -
OIC Date Comparison LogicSummary Trying to use a date comparison in a switch -errors with no messageContent Hi, I am trying to apply a date comparison in a switch. Date format I am passing in is… -
connecting the OCI DB from the Autonomous WarehouseContent Client is implementing a ADW on cloud. Scenario is as follows: 1. Source: DB available on cloud (node#2) 2. Target: ADW is available on cloud (node#3) 3. ODI ins…
-
Improve productivity with Oracle Cloud Infrastructure Data Integration’s latest releaseContent New blog about OCI Data Integration’s newly released: https://blogs.oracle.com/cloud-infrastructure/post/improve-productivity-with-oci-data-integrations-latest-r…
-
Fast-track data discovery with new release of Oracle Cloud Infrastructure Data CatalogContent We’re excited to announce a new release of Oracle Cloud Infrastructure (OCI) Data Catalog. In this release, we accelerate the cataloging of your data by automati…
-
Migrate On-prem Essbase Data to Oracle EPM CloudContent we have a use case to migrate 1.8 Million or more records from on-premise Hyperion Essbase to Oracle EPM - PBCS cloud SaaS Application. We see limitation on FDME… -
New Oracle Cloud Infrastructure Data Integration release adds pipelines and orchestrationContent We're excited to announce a new release of Oracle Cloud Infrastructure Data Integration. This release adds new transformations, connectors, and two of the most h…
-
Can we connect to LDAP using ODI or OIC?Summary Can we connect to LDAP using ODI/OIC?Content Is it possible to connect to LDAP using ODI? We did like to get the group membership of a certain AD stored in our c…
-
OIC- Passing XML file as a argument to a Stored procedure.Summary Has any one read a file from a sftp server(ftp connection) and passed the file as a argument to a Stored Procedure on Oracle DB via DB adapter.Content Trying to …
-
New release of Oracle Cloud Infrastructure Data Integration adds connectivity to Oracle Fusion AppliContent New blog about OCI Data Integration’s newly released connectivity to Oracle Fusion Applications: https://blogs.oracle.com/cloud-infrastructure/load-and-transform…
-
How to upload files to UCM with encryption in OIC and also submit Load interface file for Import forSummary Any idea for encryption / decryption steps, that needs to be followed in the OIC?
-
DATA FLOW OBJECT STORAGE SOURCE DOES NOT VALIDATEContent I have created a DATA ASSET : Identifier: DA_BUCKETDescription: Type: Oracle Object StorageNamespace: frnqzmds5miaURL: https://objectstorage.eu-frankfurt-1.oracl…
-
Problem adding Autonomous Database as Data AssetSummary Getting an error attempting to connect to an Autonomous Database Data AssetContent Hi Everyone, I'm trying to add an Autonomous Database as a Data Asset in my Da… -
Define a specific procedure in Oracle Cloud Infrastructure Data Integration data flowSummary How to define a specific SQL procedure in Oracle Cloud Infrastructure Data IntegrationContent Hi, we are evaluating latest OCI DI version. While trying to replic… -
New Oracle Cloud Infrastructure Data Integration release focuses on connectivity and transformationsContent We're excited to announce a new release of Oracle Cloud Infrastructure Data Integration. This release expands connectivity options, transformation capabilities, …
-
New OCI Data Catalog release introduces AI and ML-based features for better productivityContent We’re excited to announce a new release of Oracle Cloud Infrastructure (OCI) Data Catalog. In this release, we have added many productivity improvements to help …
-
Using Oracle Cloud Infrastructure Data Integration with MySQL Database Service and HeatwaveContent Virtually all data types from any data source can be integrated into the MySQL Database Service and HeatWave. When you need to collect data from diverse sources …
-
How to download Import Projects Report from Fusion using OICSummary How to download Import Projects Report from Fusion using OICContent Hi Folks, I have created FBDI Integration and its callback for Projects (PPM Interface) using…
-
Security Exception in SOACSSummary Security Exception in SOACSContent You receive an exception message: "java.security.cert.CertPathValidatorException: Path does not chain with any of the trust an…User_2025-02-07-14-17-08-512 63 views 0 comments 0 points Most recent by User_2025-02-07-14-17-08-512
-
DBCS - Cloud Data from Saas REST APISummary Can we invoke SAAS REST API from DBCS db objectContent Is there an option that we can invoke REST API call in DBCS? Is it possible to get data from SAAS cloud ap…