Data Integration
Discussion List
-
Using ODI and ADW as source can we generate Parquet file as outputSummary: Using ODI and ADW as source can we generate Parquet file as output ,if yes any support document on same. -
Oracle Integration Cloud and ADPSummary: Hello everyone, Is it possible to build an OIC integration to ADP? Are there connectors in OIC for ADP? Thank you in advance for your help. Content (required): …
-
ODI Load Plan as REST API ServiceSummary: We have requirement for calling ODI load plan in VBCS UI so as to refresh data or run the data load. Currently we are using ODIInvoke webservice which is config…
-
recommendation for the VM of the ODI on Market PlaceSummary: Dear All Do you have any recommendation for the VM of the ODI on Market Place, please ? OCPUs, RAM, Disk etc. Content (required): Recommendation for the VM of t…
-
ODI using SQL Unloader generate CSV FileSummary: ADW as a source system We are using ODISQLUNLOAD to generate comma separated CSV files . We are using union to cominbe the table columns and header Now as a res…
-
DB link feature works between On-Prem Oracle DB to Oracle ADW?Summary: We need to create a DB link between On-Prem database and Cloud (ADW) database, is there any specific steps we need to taken care before doing this? Or Could you… -
Is on-prem ODI 12.2.1.3 needs to be upgraded to latest version 12.2.1.4 before migrating to Cloud?Summary: Hi Team, Customer is planning to migrate entire DWH to Oracle cloud. Currently we are using ODI 12.2.1.3 & Oracle 19c DB in an on-prem environment. I need to un… -
Getting error while connecting to Rest Service in ODI using OdiInvokeRESTfulServiceSummary: When testing Rest Service connection, getting following error- PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException .Facing thi…
-
ODI is picking old version of python instead of latest version of PythonMultiple version of Python is installed and ODI market place is picking old version of python instead or latest version while calling in ODI command tool. How to resolve…
-
Individual mapping is running fine but while running same in load plan getting failedSummary: Individual mapping is running fine but while running same in load plan getting failed with error message : Table or View doesn't exist Solution to resolve to sa…
-
Populate "Last Extract Date" parameter in OCI Data Integration pipelineSummary: Unable to pass a value to the parameter type "Last Extract Date" in an OCI Data Integration pipeline. Content: Hi Experts, I'm new with OCI Data Integration and… -
ODI source connection supportSummary: We are trying to check if ODI supports connectivity to the oracle sources listed below - 1.CPQ 2.Oracle Field Service(OFS) 3.Global Trade Management. Looking fo… -
Issue with "BICC to ADW Copy" LKMSummary: Hello, While running mappings with "BICC to ADW Copy" LKM, data loads are failing with ORA-20006: Unsupported object store URI error message. We are using We ar… -
Does ODI-Marketplace (free version) allow for SFTP of file from on-premise to Object/Block storageSummary: We plan to have IPSec VPN connectivity between OCI and Customer Data Center Customer plans to have some files placed on-premise in a windows directory We would …
-
How to read an Excel file via ODI 12c?Summary: Hi Team, Could anyone please guide me on the below requirements related to excel file parsing using ODI - Read the excel file placed in a local folder via ODI 1…
-
question: are there tools in oci data integration for create zip file from files eg: in bucket?Summary: Content (required): are there tools in oci data integration for create zip file from files eg: in bucket? have a capability to create zip files present on Oracl…
-
Is there a way to use Object Storage logical folders while using the "LKM BICC to ADW Copy" ?Summary: Currently we are building data warehouse using Fusion saas data. We are using BICC for data extraction and ODI to consume the BICC extracts. We are using "LKM B…
-
ODI mapping failing with the error message - “Read timed out”ODI mapping is failing with the error message - "Read time out" Error Message : java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0…
-
Options to extract data from BIP Report and load it to ADW via ODIContent (required): I wanted to know what is the best way or options to extract data from the BIP Report (in Fusion) and load this data to ADW with the use of ODI. We ar… -
Error Connecting to BICC url using ODISummary: Error Connecting to BICC url using ODI Content (required): Hi All , While connecting to BICC through ODI topology, we are facing error as below. Agent is j2ee a…
-
Unable to test connection to Azure SQL Server data asset in OCI Data IntegrationSummary: Created a data asset to connect to a sql server database in MS Azure. While testing the connection getting an error related to client IP not allowed to connect …
-
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…
-
Error while installing ODI in window m/c Error message : The permanent log directory is unknownWhile installing ODI on local machine in Window m/c getting error message : :::::::::::::::::::::::::::: at oracle.as.install.engine.InstallEngine.startOperation(Install…
-
Can we use ODI to retrieve and parse an Excel spreadsheet hosted on SharePoint?Summary: Hi Team, The requirement is to retrieve and parse an Excel spreadsheet hosted on SharePoint via ODI 12c. Content (required): Is there any OOTB KM we can use to …
-
How to change server time in ODI Market place.Summary: Hi we have ODI Market Place and the time zone is UTC, How to make it to UTC + 3. Content (required): Hi we have ODI Market Place and the time zone is UTC, How t…
-
OCI Data Integration - Filter using row_number() over in Data FlowI'm hoping this is something obvious that I'm overlooking. What I'm trying to achieve is filtering a data source (ADW table) by partition and only keeping the top row fo…
-
PLS-00172: string literal too long while loading BICC PVO data using ODI MarketplaceSummary: We are trying to load data from Fusion BIACM JournalEntryLinePVO into ADW using ODI-Marketplace. This Job fails with below error. ERROR ----------- ODI-1590: Th… -
Unable to load BICC PVO using ODI-MSummary: Recently we are coming across the following error randomly for some of the PVOs. ODI-1590: The execution of the script failed. Caused By: javax.script.ScriptExc…
-
How to integrate Kafka with ODI 12c Market Place and bring data to ADW DBSummary: We have a new requirement where we need to integrate Kafka to ODI 12c Market Place. Content (required): I went through this document where it is mentioned how t…
-
Hi team, we are planning to integrate Oracle golden gate using peoplesoft source systemSummary: we are planning to integrate Oracle golden gate using people-soft as source system for a customer to fetch the delta data. Content (required): We are planning t…