Lift and Shift to Oracle Data Integrator Cloud Service (ODICS) : Moving your Repository to the Cloud

  Oracle Data Integrator (ODI) is now available as a Cloud Service: Oracle Data Integrator Cloud Service (ODICS). For customers who are interested in a subscription model for their ODI installation and want to integrate and transform data in the Cloud, this is the solution. Customers who already have ODI developments on premises will want […]

Oracle GoldenGate: Network Apply to SQL Server

Introduction Oracle GoldenGate (OGG) best practices dictate that the OGG Apply process run on the target database server. However, there are instances where this configuration is not practical. In this article we shall discuss a solution where OGG Apply may be configured on a mid-tier server and apply data over a network to a remote SQL […]

Integrating Oracle GoldenGate Cloud Service (GGCS) with Oracle Business Intelligence Cloud Service (BICS)

Introduction This article describes an overview of how to integrate Oracle GoldenGate Cloud Service (GGCS) in terms of populating or loading data into Oracle Business Intelligence Cloud Service (BICS) from On-Premises. Both GGCS and BICS are Platform as a Service (PaaS) services that runs in the Oracle Public Cloud (OPC). For GGCS to be integrated with […]

Oracle GoldenGate: Replicating “Soft” Deletes To Data Warehouses

Introduction We receive a lot of questions on how to setup Oracle GoldenGate to perform “soft” deletes in Data Warehouses. By default, Oracle GoldenGate replicates data operations exactly as they occur in the source database; however, in Data Warehouses their is typically a requirement to retain the original data record and set a flag that […]

Integrating Oracle Data Integrator (ODI) On-Premises with Cloud Services

 Introduction   This article presents an overview of how to integrate Oracle Data Integrator (ODI) on-premises with cloud services.  Cloud computing is now a service or a utility in high demand.  Enterprises have a mix of on-premises data sources and cloud services.  Oracle Data Integrator (ODI) on-premises can enable the integration of both on-promises data […]

Using Oracle Data Integrator (ODI) to Load BI Cloud Service (BICS)

For other A-Team articles about BICS, click here Introduction Oracle Data Integrator (ODI) is a comprehensive data integration platform that covers most data integration scenarios.  It has long been possible to use ODI to load data into BI Cloud Service (BICS) environments, that use Database as a Service (DBaaS) as the underlying database. The recent 12.2.1.2.6 release […]

Oracle Data Integrator Best Practices: Using Loading Knowledge Modules on both On-Premises and Cloud Computing

Introduction   This article discusses the best practices for selecting and using the Oracle Data Integrator (ODI) Loading Knowledge Modules (LKMs) on both on-premises and on cloud computing.  LKMs are code templates in ODI that can perform data upload operations from on-premises data servers to cloud services, between cloud services, or between on-premises data servers.  […]

Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using REST

Introduction This post details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into the Oracle Business Intelligence Cloud Service (BICS) using RESTful services. It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using SOAP . Both this post and […]

Oracle Data Integrator Best Practices: Using Reverse-Engineering on the Cloud and on Premises

Introduction   This article discusses best practices on using the Reverse Engineering features of Oracle Data Integrator (ODI) on the cloud and on premises.  The first part of this article presents the various options available in ODI to reverse-engineer metadata from a data server.  Then, the article discusses performance considerations when running and executing reverse-engineering […]

Loading Data from Oracle Identity Cloud Service into Oracle BI Cloud Service using REST

Introduction This post details a method of extracting and loading data from Oracle Identity Cloud Service (IDCS) into the Oracle Business Intelligence Cloud Service (BICS). It builds upon the A-team post IDCS Audit Event REST API which details the REST API calls used. One use case for this method is for analyzing trends regarding audit events. […]