Data Warehousing
Discussion List
-
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…Sunil Gunturu-Oracle 101 views 6 comments 2 points Most recent by Himanshu Nayak-Oracle Data Integration -
Oracle Data transforms: Use DB Sequence in Data flowSummary: Hi, I want to load a target table using Oracle Data transforms and populate ID column using a sequence. How could I achieve it? Thank you for your help. Content…
-
Maturity of OCI Data Integration versus ADW Data StudioHi, What is the maturity and feature parity of OCI Data Integration versus ADW Data Studio ? Is there a comparison sheet available ? Which one should we use for integrat… -
Which oracle technologies allow me to move data from postgres to snowflake?Summary: Oracle GoldenGate is a Oracle and non-Oracle database and data store replication tool. Content (please ensure you mask any confidential information): Attend an …
-
How to load .mdb (Access File) into Oracle Table using ODISummary: .mdb File will be placed on the ODI server and need to be loaded into Oracle Table using ODI 12c. Content (please ensure you mask any confidential information):…Ritesh Kashyap-Oracle 21 views 2 comments 0 points Most recent by Ritesh Kashyap-Oracle Data Integration
-
Archiveing SAP legacy data to OCISummary: We are implementing Oracle Cloud for a client with a SAP legacy system. Our plan is to migrate the latest/top of the stack data to the cloud. However, the clien…Chandramouli Yangareddy 11 views 0 comments 0 points Started by Chandramouli Yangareddy Data Integration
-
How to SFTP file load to UCM content server via ODISummary: Hi Team, Content (please ensure you mask any confidential information): How to FTP file load to UCM content server (SOAP service) via ODI Version (include the v…
-
Is there a PVO that pulls Pay Calendar information?Summary: No available historical PVO that pulls pay calendar information. Content (required): I'm trying to find a data store/PVO that pulls pay calendar information but…
-
Is there a historical PVO that pulls the Asssignment EIT?Summary: Historical PVO for Assignment EIT doesn't exist. Content (required): I am not able to find a historical PVO for Assignment EIT. Available PVO is filtered using …
-
Is there available BICC PVO for Seniority Date?Summary: No available PVO for employee's seniority dates. Content (required): I'm trying to find a data store or PVO that is pulling the employee's seniority date but un…
-
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…Partha Kar-Oracle 82 views 3 comments 0 points Most recent by Debadrita Ghosh-Oracle Data Integration
-
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…Bharath Raghupathi-Oracle 47 views 3 comments 0 points Most recent by SukantaBarari-Oracle Data Integration -
How to Configure microsoft 365 Email for sending emails via ODI - Missing OptionsSummary: We have ODI 12.2.1.4.0 on prem ODI And how are we supposed to use Microsoft 365 EMail exchange for sending emails. Content (required): Microsoft 365 email authe…Sunil Gunturu-Oracle 143 views 2 comments 0 points Most recent by Sunil Gunturu-Oracle Data Integration
-
How to send Email using "Azure Communication Services"Summary: Customer is asking to utilize Azure Communication services to send Emails from OAS (via agents). Azure communication services uses only a connection string and …
-
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…Bapiraju Swamy Vuda-Oracle 151 views 2 comments 2 points Most recent by Bapiraju Swamy Vuda-Oracle Data Integration -
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…Shaik Gousimiya-Oracle 32 views 2 comments 4 points Most recent by Shaik Gousimiya-Oracle Data Integration -
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…Sunil Gunturu-Oracle 21 views 1 comment 0 points Most recent by Sunil Gunturu-Oracle Data Integration
-
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…
-
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 …
-
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
-
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…
-
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…
-
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…
-
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 …