Last validation: September 30, 2020 with 12.2.1.4.0 Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI)...
Last validation: September 30, 2020 with 12.2.1.4.0 Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) Marketplace to Autonomous Databases on shared infrastructure e.g. Autonomous Data Warehouse (ADW). This post uses ADW, but the method is also applicable to Autonomous Transaction Processing (ATP) databases. For additional details about ADW, refer to Autonomous Data Warehouse. For additional details about ODI, refer to...
Last validation: September 30, 2020 with 12.2.1.4.0 Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) Marketplace to Autonomous Databases on...
Introduction Storing terabytes of database backups in Object Storage? Is the data accessed rarely or mostly saved for archive purposes? Now we have the...
Introduction Storing terabytes of database backups in Object Storage? Is the data accessed rarely or mostly saved for archive purposes? Now we have the opportunity to use Archive Storage! This is cost-effective, long term, secure, policy managed storage. The general difference between data backup and data archiving is how long we need to retain the data and how we need to access them. Archiving provides long term storage and limited access. Oracle offers the Archive Storage...
Introduction Storing terabytes of database backups in Object Storage? Is the data accessed rarely or mostly saved for archive purposes? Now we have the opportunity to use Archive Storage! This is...
Last validated on September 30, 2020 Introduction The latest releases of Oracle Data Integrator (ODI) are now available on Oracle Cloud Marketplace. From the...
Last validated on September 30, 2020 Introduction The latest releases of Oracle Data Integrator (ODI) are now available on Oracle Cloud Marketplace. From the Using Oracle Cloud Marketplace website: "Oracle Cloud Marketplace is an online store—a one-stop shop—selling hundreds of business apps and professional services that complement your existing Oracle Cloud implementation." This offering includes a full instance of ODI with a pre-configured repository. This repository...
Last validated on September 30, 2020 Introduction The latest releases of Oracle Data Integrator (ODI) are now available on Oracle Cloud Marketplace. From the Using Oracle Cloud Marketplace website:...
Introduction Thanks to the ODI JKMs for GoldenGate, we do not need to have much experience with GoldenGate to configure a replication environment: ODI generates...
Introduction Thanks to the ODI JKMs for GoldenGate, we do not need to have much experience with GoldenGate to configure a replication environment: ODI generates all the necessary parameters for GoldenGate; it can communicate in real-time with your GoldenGate instance and make sure that changes propagated by GoldenGate will be processed by ODI with no additional setup or configuration. But when we already have a fine tuned GoldenGate installation, the last thing we want is for...
Introduction Thanks to the ODI JKMs for GoldenGate, we do not need to have much experience with GoldenGate to configure a replication environment: ODI generates all the necessary parameters...
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC)....
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC). Every single run to extract data or keys will produce a JSON file with log information that can be used for monitoring purposes. The naming style per file looks like shown below: EXTRACT_STATUS_DATA_SCHEDULE_<Schedule ID>_REQUEST_<Request ID>.JSON BICC Extract log file for VO data if been chosen in run definition...
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC). Every single run to extract data or keys...
Introduction Oracle Recovery Manager (RMAN) is a sophisticated tool that database administrators have been using to take the backup of their on-premises...
Introduction Oracle Recovery Manager (RMAN) is a sophisticated tool that database administrators have been using to take the backup of their on-premises databases. As the organizations move their databases to cloud, the database administrators may want to continue to use RMAN to perform backup and recovery operations. Oracle Cloud Infrastructure (OCI) offers several services and options, including RMAN, to take the backup of your databases. In this blog I will not be...
Introduction Oracle Recovery Manager (RMAN) is a sophisticated tool that database administrators have been using to take the backup of their on-premises databases. As the organizations move...
p { margin:0; padding:0; line-height:20px; } div { margin:0; padding:0; } Validation Validated on 11/20/2020 with : ODI Version 12.2.1.4.201011 ADW Version...
p { margin:0; padding:0; line-height:20px; } div { margin:0; padding:0; } Validation Validated on 11/20/2020 with : ODI Version 12.2.1.4.201011 ADW Version Oracle Database 19c Enterprise Edition Release - Production Version 19.5.0.0.0 EDMCS Version 20.10.70 Introduction In order to have a single source of truth for an organization’s data, a reference data solution is often required. This reference data once define can be used by operational systems as well as reporting...
p { margin:0; padding:0; line-height:20px; } div { margin:0; padding:0; } Validation Validated on 11/20/2020 with : ODI Version 12.2.1.4.201011 ADW Version Oracle Database 19c Enterprise Edition...
Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud...
Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud Infrastructure (OCI). Versions OCI Compute Oracle-Linux-7.6-2018.11.19-0 Instant Client 18.3.0.0.0 for Linux x86-64 (64-bit) ADW DB 18.0.3.3 SQL Developer 18.3.0.277 Assumptions An Oracle Cloud Account and an OCI Tenancy Access to an ADW instance Administrator Credentials to both of the above An export...
Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud Infrastructure (OCI). Versions...
This blog has been retired as ODICS is no longer offered. Please see...
This blog has been retired as ODICS is no longer offered. Please see https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.3/odimp/getting-started-oracle-cloud-marketplace.html#GUID-1793F6A6-8581-465D-BBE3-8F0C8ADD6536 for the new ODI Marketplace usage.