Extract Transform Load - ETL
Discussion List
-
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 … -
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…Sahithi Kolasani-Oracle 14 views 0 comments 1 point Started by Sahithi Kolasani-Oracle Data Integration -
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 53 views 1 comment 0 points Most recent by Sahithi Kolasani-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 …User_2025-01-25-04-02-13-126 37 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
-
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 17 views 0 comments 2 points Most recent by Aditya Duvuri-Oracle 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… -
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…User_2025-01-25-04-02-13-126 23 views 1 comment 0 points Most recent by AnkitR Gupta Data Integration
-
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, …
-
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 …
-
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 -
API Endpoint to provide a List of UsersSummary Looking for an API Endpoint to provide a List of UsersContent I am assisting the development of a Rest API between Oracle Cloud and a third-party mobile app. As …
-
Error while trying to create a connection to an oracle data integrator cloud service agentSummary When trying to save a database connection associated with a data preparation agent, the following error occurs: Unable to update Oracle DB Client in GG instance …User_2025-02-04-09-13-39-612 31 views 1 comment 0 points Most recent by Julien Testut-Oracle Data Integration
-
question on ODI from marketplaceSummary multiple agents possible ?Content as I understand ODI from marketplace comes with its own embedded repository (which is not Oracle database, but mysql). in such …
-
Can ODICS Connect to Fusion CloudSummary Connecting ODICS to Fusion CloudContent Hello Experts!! I am trying to move data from fusion cloud to PaaS DBCS. We are currently using BICC and Datasync. Can OD… -
Can OIC poll for file creating in FTP directory?Summary Trying to poll a directory in an FTP for new filesContent Hello All! I need to trigger an integration for when a new file is uploaded into an FTP directory. Is t…User_2025-02-04-13-35-35-440 42 views 5 comments 0 points Most recent by Malkit Bhasin-53728 Data Integration
-
Pull data from on-premise Oracle DB into PaaS database using DB linkSummary Pull data from on-premise Oracle DB into PaaS database using DB linkContent Hi All, Please advise how to Pull data from an on-premise Oracle DB having DB link in…User_2025-02-04-13-12-58-802 45 views 3 comments 0 points Most recent by Werner He-Oracle Data Integration