Published December 24, 2019 Introduction The latest releases of Oracle Data Integrator (ODI) are now available on Oracle Cloud Marketplace. From the Using...
Published December 24, 2019 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...
Published December 24, 2019 Introduction The latest releases of Oracle Data Integrator (ODI) are now available on Oracle Cloud Marketplace. From the Using Oracle Cloud Marketplace website: "Oracle...
Matthieu Lombard CLOUD SOLUTIONS ARCHITECT, DATA MANAGEMENT, A-TEAM Background *** 12/16/19 - This feature is in early release. The A-Team continues to...
Matthieu Lombard CLOUD SOLUTIONS ARCHITECT, DATA MANAGEMENT, A-TEAM Background *** 12/16/19 - This feature is in early release. The A-Team continues to collaborate with Oracle Development on these configuration steps and will update the blog accordingly as new information is made available *** ~ This article walks though the steps to configure Oracle Data Integrator on Oracle Cloud Marketplace (ODI) with Business Intelligence Cloud Connector (BICC) to replicate data from...
Matthieu Lombard CLOUD SOLUTIONS ARCHITECT, DATA MANAGEMENT, A-TEAM Background *** 12/16/19 - This feature is in early release. The A-Team continues to collaborate with Oracle Development on these...
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...
p { margin:0; padding:0; line-height:20px; } div { margin:0; padding:0; } We are reworking the content of this blog. Please stay tuned. Thanks.
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...
Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to...
Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to the Autonomous Data Warehouse (ADW). It demonstrates both the Thin and Oracle Call Interface (oci) versions of the Oracle JDBC driver. It is a companion post to Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse which uses ODI Studio on Windows and Connecting DIPC ODI Studio to the Autonomous...
Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to the Autonomous Data Warehouse (ADW). It...
Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had...
Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had been properly monitoring their environments. In this article we're going to discuss various areas that should be monitored regularly to avoid degradations in performance and unscheduled outages. The concepts, scripts, and information presented in this article are for educational purposes only. They are not supported by...
Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had been properly monitoring...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics Cloud (OAC and OAAC), to replicate data, on a schedule, from a number of Oracle's SaaS offerings. For many use cases, this will mean that a separate extract and load processes, is no longer required. In this initial release, the sources that can be replicated are: - Oracle Fusion...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to extract data for most use cases, is through the BI Cloud Connector tool. This pulls data from 'View Objects' in the Business Intelligence layer of Fusion SaaS. Other tools can also extract from these view objects. BI Apps customers have pre-created ODI mappings, that take the...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to...
