Oracle Data Integrator
Discussion List
-
Agent test failed while creating it inside Master repository in ODI StudioSummary: Content (required): Hi team, While I have installed the ODI Studio and started installing schemas through RCU facility, I was getting errors initially while cre… -
ODI Salesforce integrations are very slow, looking for performance enhancement possibilitesSummary: We have an integration setup using ODI, which extracts data from Salesforce. While it works fine, the processes take a long time to run. We created equivalent p… -
EDQ Topology Connection failing when Testing with Java Agent (On Prem ODI)Summary: EDQ Topology Connection failing when Testing with Java Agent (On Prem ODI), but works fine with Local Agent Content (required): We are having Oracle PCA where O…
-
Unable to import code from higher ODI version to lowerSummary: While we are trying to import ODI code from higher ODI version to lower, we are facing the error ODI-14255: Import file has repository version 05.02.02.11 newer…Sahithi Kolasani-Oracle 332 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Data Integration -
Connecting On Premise ODI with Oracle UCM ServerWe need to extract data (BICC Extracts) from Oracle UCM Server, can we connect from on-premise ODI 12.2.1.3 or 12.2.1.4 version to Oracle UCM? Any suggestions?SaurabhJaiswal-Oracle 32 views 0 comments 0 points Started by SaurabhJaiswal-Oracle Data Integration -
Moving ODI objectsSummary Moving ODI objectsContent Hi All, I am trying to moving interface from one project to another project in ODI 11g. Below are the my test cases I) i) I exported in…
-
ODI Text to columnsSummary: Looking for a text to columns function within ODI Content (required): Hello, We're migrating from Alteryx to ODI. The Alteryx tool has a very straight forward "…Brian Watkins-Oracle 12 views 2 comments 0 points Most recent by Brian Watkins-Oracle Data Integration
-
Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only … -
ODI PackageSummary ODI PackageContent Hi I imported a package in to ODI 11g,while I am checking I face some issue.Please help me by checking the below Screen shot "Linked objects a…
-
How to retrieve deleted records from Salesforce through ODISummary: We have integrations in ODI which connects to Salesforce(using JDBC), and, extracts data to load into ADW. However, the deleted records on Salesforce are not be…
-
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 …User_2025-01-25-04-02-13-126 51 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Data Integration -
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… -
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 38 views 2 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Data Integration
-
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… -
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…Rehan Ahmed Khan-Oracle 17 views 2 comments 0 points Most recent by Anubhav Bhardwaj Data Integration
-
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… -
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…User_2025-01-25-04-02-13-126 23 views 1 comment 0 points Most recent by AnkitR Gupta Data Integration
-
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 …
-
Connecting to On-Premise DB Server from ODI in MarketplaceContent Hi Experts, Is there anyway to create connection from ODI in marketplace to on-premise database? ODI repository in ADW. Thanks. Regards, Henry -
ODI Marketplace PricingSummary ODI Marketplace PricingContent Could you please advise how pricing for ODI Marketplace works. Is it based on number of Topology connections or message based or C…
-
Purge Logs in ODI from marketplaceSummary Purge Logs in ODI from marketplaceContent Hi, Do we have odiPurgeLog Utility in ODI marketplace. Can you please confirm whether ODI marketplace has all the featu…
-
ATP repository connection in ODI CSSummary How to connect ATP repository in ODI CSContent Hi Team, I have provisioned ODI MP Image with ATP to store the repository, but when I launch the odi studio and co… -
Road-map for ODI Cloud servicesSummary Need understanding on future road-map for ODI Cloud services in terms of re-platforming to OCI & autonomous servicesContent Our current client has Universal Cred…
-
API end-points for AccountsSummary Are there REST APIs available to get Account Groups, Account Segment values and Account Combinations?Content I am investigating REST APIs for Oracle Financials C…
-
ODI RCU repository creation in ATPSummary How to create odi repositories in ATPContent Hi Team, I want to create ODI repository schemas in ATP DB , But it is not allowing with Admin user as it needs SYS …Subrahmanyam Vempati 15 views 1 comment 1 point Most recent by User_2025-01-31-16-13-16-334 Data Integration
-
Audit logs for ODI instance in OCISummary Audit logs for ODI instance in OCIContent Hi Team, I have created a ODI VM in compute node by using marketplace odi image, I am able to login from my machine usi…Subrahmanyam Vempati 29 views 1 comment 1 point Most recent by User_2025-01-31-16-13-16-334 Data Integration
-
Best approach to read Excel Spreadsheet using odi 12cSummary Best approach to read Excel Spreadsheet using odi 12cContent Hi Team, Can you please suggest an approach to read the Excel files using odi , do we need ODBC/JDBC…Subrahmanyam Vempati 21 views 1 comment 0 points Most recent by User_2025-01-31-16-13-16-334 Data Integration
-
ODI Production Environment RecommendationsSummary ODI Production Environment Recommendations for Marketplace ImageContent Hi Team, We are using ODI on Marketplace Image, would like to know the Recommendations fo…Subrahmanyam Vempati 25 views 1 comment 0 points Most recent by User_2025-01-31-16-13-16-334 Data Integration
-
ODI deployment stepsSummary deploying standalone listenerContent Dears, I am getting into ODI (OCI Marketplace) lately. VM is up and running and ODI was deployed correctly using native repo…Sébastien Roux 32 views 1 comment 0 points Most recent by User_2025-01-31-16-13-16-334 Data Integration -
How to access RCU in ODI Marketplace?Summary ODI in the marketplace comes with pre-built MySql and WLS. How do we create work repositories in a oracle DBCS.