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
-
Loading Data in FBDI Template file using ODISummary: Loading Data in FBDI Template file using ODI Content (required): Hi, Customer wants to load data into FBDI template file using ODI. Source is staging table (Ora… -
IBM DB2/400 Connectivity Issue in ODISummary: We are trying to connect to IBM DB2 / 400 database in ODI but getting driver issue after configuring and testing connection in topology Content (required): As s…
-
ODI Agent unable to run Python Program but local agent is able to runSummary: We have ODI agent and ODI installed in the same machine, we are using ODI Marketplace. With local agent we are able to call python program using odioscommand bu…
-
Connecting to Amazon S3 using ODISummary: Connecting to Amazon S3 using ODI Content (required): Hi, We need information about how to connect/Configure Amazon S3 using ODI 12c.Kindly guide if anyone has …
-
Triggering FCCS Data Management Job from ODISummary: Trigger Data Management job and extract data files from FCCS to ODI/ADW. Content (required): We are able invoke REST API GET and POST Methods from Soap and trig… -
Need SNP Query for data lineage from source 2 target table in mapping involving re-usable mappings.Summary: Need SNP Query for data lineage from source to target table in mapping involving re-usable mappings. Content (required): We have several mappings in our project…
-
ODI CS to ODI MP migration pathSummary: We have a customer on ODI CS, who are looking to migrate to ODI Market Place (since ODI CS is being sunsetted). Seeking advice on the best approach to migrate f… -
How can we import Master and Work repository with code components when present in multiple folders?Summary: Master and Work repository with code components present in multiple folders, how can we import to new instance in single go? Content (required): We have receive… -
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… -
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? -
Can not find any images related with Siebel in MarketPlaceI ca not find any images related with Siebel in Marketplace If someone knows what is the reason?
-
Fusion Middleware (FMW) 12c updateSummary: Customer will receive their 22A update with 22B in May 2022, including the Fusion Middleware (FMW) 12c update. Content (required): Will there be any potential i… -
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…
-
Function strange behavior when invoked via API gatewaySummary: The function behavior is not consistent when I invoke it via API gateway. i have function that merges pdf and writes the merged file to a ftp location. When i t…
-
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 "…
-
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…
-
Data Entity doesn't load data through Fusion Data AssetSummary: It was creating a Fusion Data Asset and configured the Oracle Business Intelligence Cloud Connector Console. The connections are work fine, but when create a da…
-
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…
-
Setting prune time for a PVO extraction using Fusion BICCCSummary: We need to extract Fusion PVO data using BICCC job. We will be creating a job in Fusion BIACM and trigger that job from ODI and load data into ADW. We have a re…
-
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…