Introduction This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box...
Introduction This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, and Apache Pig, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and Cloudera Enterprise Data Hub (CDH). Additionally, ODI can also be used on other distributions of Hadoop such as Amazon Elastic...
Introduction This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box integration with Big Data technologies such as...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Securing platforms, applications, and data from...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Securing platforms, applications, and data from unauthorized access is of great importance to IT organizations. In this article we shall detail the product features and best practices for securing your Oracle GoldenGate environment. The concepts presented in this article are for educational purposes only. Before applying any changes presented in this article to your...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Securing platforms, applications, and data from unauthorized access is of great importance to...
Introduction Oracle GoldenGate for HP Nonstop provides capabilities for the manipulation of transactional data and the replication of selected TMF Audited...
Introduction Oracle GoldenGate for HP Nonstop provides capabilities for the manipulation of transactional data and the replication of selected TMF Audited Enscribe, SQL/MP, SQL/MX, and Non-Audited Enscribe data to a variety of applications and platforms. In this article we shall present a series of "best practices" for the configuration and operation of Oracle GoldenGate when replicating HP Nonstop TMF Audited data. Main Article Properly configuring your Oracle GoldenGate...
Introduction Oracle GoldenGate for HP Nonstop provides capabilities for the manipulation of transactional data and the replication of selected TMF Audited Enscribe, SQL/MP, SQL/MX, and...
This blog has been retired. The DBaaS and BICS are both on Classic and current versions are unavailable to test with. Use this for a command line method:...
This blog has been retired. The DBaaS and BICS are both on Classic and current versions are unavailable to test with. Use this for a command line method: https://docs.oracle.com/database/121/DBSEG/asoappf.htm#DBSEG610 And this for a GUI method: https://docs.oracle.com/database/121/DBIMI/walet.htm#DBIMI160
Introduction This article discusses the best practices for selecting and using Oracle Data Integrator (ODI) Check Knowledge Modules (CKMs) on both on-premises...
Introduction This article discusses the best practices for selecting and using Oracle Data Integrator (ODI) Check Knowledge Modules (CKMs) on both on-premises data servers and cloud data services. In traditional ETL tools, when an ETL data flow is designed, ETL developers must design steps to perform data validation and remove the records that do not pass validation. The task of designing and implementing steps to validate data can increase the overall time it takes to...
Introduction This article discusses the best practices for selecting and using Oracle Data Integrator (ODI) Check Knowledge Modules (CKMs) on both on-premises data servers and cloud data services. ...
Introduction By default Oracle GoldenGate handles data for date data types without any user intervention. However, there are times when you may need to...
Introduction By default Oracle GoldenGate handles data for date data types without any user intervention. However, there are times when you may need to manipulate this data based upon end use requirements. Oracle GoldenGate has numerous built-in functions that allows users to test and manipulate data. In this article we shall present the column-conversion functions used to work with dates and timestamps: @DATE, @DATEDIFF, and @DATENOW. Main Article Oracle GoldenGate provides...
Introduction By default Oracle GoldenGate handles data for date data types without any user intervention. However, there are times when you may need to manipulate this data based upon end...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. When working with Teradata customers, we are always...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. When working with Teradata customers, we are always asked for recommendations of how to instantiate the target Teradata database. There are numerous ways to accomplish this; including various third-party applications that most customers have in-house. In this article, we will demonstrate a zero down-time data replication implementation from an Oracle 12c Pluggable...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. When working with Teradata customers, we are always asked for recommendations of how to...
Introduction This article discusses how to use Oracle Data Integrator Cloud Service (ODICS) to integrate Oracle Field Service Cloud (FSC) with Business...
Introduction This article discusses how to use Oracle Data Integrator Cloud Service (ODICS) to integrate Oracle Field Service Cloud (FSC) with Business Intelligence Cloud Service (BICS). ODICS provides pushdown data processing with high performance ETL for the Cloud. ODICS executes data transformations where the data lies without having to unnecessarily copy data to remote locations. A video demonstration of how to use ODICS to integrate OFSC with BICS can be found on the...
Introduction This article discusses how to use Oracle Data Integrator Cloud Service (ODICS) to integrate Oracle Field Service Cloud (FSC) with Business Intelligence Cloud Service (BICS). ODICS...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. In Part 1 of this article, we performed a...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export Wizard and Oracle GoldenGate. In this part, we will do the same zero-downtime migration using Oracle SQL Developer to create the target schema and instantiate the tables, and use Oracle...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL...