OCI Data Integration
Discussion List
-
Extract a System generated report for ODI, OCISummary: Hello team, can you please help me with the following info : is there a way to extract a System generated report, for all the changes/configurations for a speci… -
Supports incremental not working when Disabled Effective Date field is checked in BICC.Summary: For some data store, Supports incremental is not working when Disabled Effective Date field is checked in BICC. Content (required): Why for some data store Supp…
-
ODI Web Edition is giving Driver class name must not be empty while setting up data loadSummary: ODI Web Edition is giving Driver class name must not be empty while setting up data load Content (required): I have setup connect to ERP Cloud as type Oracle BI…
-
Assignment details not integrating in their Payroll softwareThe assignment details of one employee does not seem to be extracted from PROD to the XML, which is shared with their Payroll software. There's also one employee where a…Maria Cristina L. San Jose 11 views 0 comments 0 points Started by Maria Cristina L. San Jose Data Integration
-
Use OCI Base Database as a Target in Data FlowSummary: I'm using Oracle Data Integration and creating a simple data flow for converting a JSON file (stored in storage bucket) to a specific DB table. When using the D…
-
OCI Data Integrator - Unable to output to Object StorageSummary: My Data Flow has a target with Data Asset being Object Storage. I'm unable to validate this as it keeps throwing the following error. "The name of Data Entity t…
-
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): …Daniel McMillian 181 views 2 comments 0 points Most recent by Narasimharao Popuri-Oracle Data Integration
-
Can OCI Data Integration connect with "Azure Data Lake GEN2"Summary: Hi All, Can anyone help to let me know if OCI Data Integration can connect with "Azure Data Lake Gen2" or in general terms "Azure Cloud DB GEN2"? Content (requi…
-
Is ODI Marketplace built on OCI Gen 2?Summary: Customer wants to keep track of the platform on which Oracle's services are built. As part of that initiative, Customer wants to know if the ODI Marketplace the…
-
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…Indra Sardana-Oracle 41 views 5 comments 0 points Most recent by Indra Sardana-Oracle Data Integration -
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… -
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… -
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 …
-
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…
-
Fusion Data Extraction to on premise DBHi Experts We are working with a large telecom customer in India who is in process of Fusion implementation across modules. They want to leverage on premise setup for th…Amit Pimparkar-Oracle 31 views 0 comments 0 points Started by Amit Pimparkar-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 31 views 0 comments 0 points Started by SaurabhJaiswal-Oracle Data Integration -
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… -
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…
-
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…
-
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…Brian Watkins-Oracle 31 views 3 comments 0 points Most recent by Jerome Francoisse-Oracle 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 16 views 2 comments 0 points Most recent by Anubhav Bhardwaj Data Integration
-
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…Aditya Duvuri-Oracle 16 views 0 comments 2 points Most recent by Aditya Duvuri-Oracle Data Integration
-
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…
-
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…