For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync Tool provides the ability to synchronize data from on-premise sources...
For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync Tool provides the ability to synchronize data from on-premise sources to the BI Cloud Service (BICS). The tool can source from both relational data, and flat files, and it can be used for one-off loads, or in an incremental fashion to keep BICS 'in-sync' with on-premise data. This article will cover the installation and configuration steps, and then walk through the creation of data...
For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync Tool provides the ability to synchronize data from on-premise sources to the BI Cloud Service (BICS). The...
Introduction The Oracle Mobile A-Team has released a new version of its free Mobile Persistence Accelerator (AMPA) for Oracle's Mobile Application Framework...
Introduction The Oracle Mobile A-Team has released a new version of its free Mobile Persistence Accelerator (AMPA) for Oracle's Mobile Application Framework (MAF) version 2.1. In this article we will discuss the main new features. If you are new to the AMPA, you first might want to read the introductionary "Getting Started" article. Main Article Design-Time Improvements The three wizards to create a mobile persistence layer from REST-JSON or REST-XML services, SOAP web...
Introduction The Oracle Mobile A-Team has released a new version of its free Mobile Persistence Accelerator (AMPA) for Oracle's Mobile Application Framework (MAF) version 2.1. In this article we...
Introduction This article describes the steps required to enable Oracle Partition Exchange in Oracle Data Integrator (ODI). The article features a new ODI...
Introduction This article describes the steps required to enable Oracle Partition Exchange in Oracle Data Integrator (ODI). The article features a new ODI knowledge module (KM), the IKM Oracle Partition Exchange Load, which uses the Oracle Partition Exchange technology to upload data, by partition or subpartition, into a partitioned table of an Oracle database. This KM supports three partitioning strategies: range, hash, and list. Single-level partitioning and composite...
Introduction This article describes the steps required to enable Oracle Partition Exchange in Oracle Data Integrator (ODI). The article features a new ODI knowledge module (KM), the IKM Oracle...
Introduction This article presents a data integration recipe on how to use Oracle Partition Exchange with Oracle Data Integrator (ODI) to upload data very...
Introduction This article presents a data integration recipe on how to use Oracle Partition Exchange with Oracle Data Integrator (ODI) to upload data very fast into partitioned tables of a large Oracle data warehouse. This article features a new ODI knowledge module (KM), the IKM Oracle Partition Exchange Load, which uses the Oracle Partition Exchange technology to upload data, by partition or subpartition, into a partitioned table of an Oracle database. This KM supports...
Introduction This article presents a data integration recipe on how to use Oracle Partition Exchange with Oracle Data Integrator (ODI) to upload data very fast into partitioned tables of a large...
Introduction This article illustrates how to import data from relational databases into Hadoop Distributed File Systems (HDFS) with Sqoop and Oracle Data...
Introduction This article illustrates how to import data from relational databases into Hadoop Distributed File Systems (HDFS) with Sqoop and Oracle Data Integrator (ODI). This article features two ODI knowledge modules designed to work with Sqoop: IKM SQL to HDFS File (Sqoop) and IKM SQL to HDFS Hive (Sqoop). If your source data store is a relational database such as Oracle, Teradata, and MySQL, the Sqoop tool provides a fast and efficient way to extract and load data...
Introduction This article illustrates how to import data from relational databases into Hadoop Distributed File Systems (HDFS) with Sqoop and Oracle Data Integrator (ODI). This article features...
Introduction The "OGG-01161 Bad Column Index" error is possibly one of the most reviled and misunderstood Oracle GoldenGate (OGG) error messages ever created....
Introduction The "OGG-01161 Bad Column Index" error is possibly one of the most reviled and misunderstood Oracle GoldenGate (OGG) error messages ever created. In this article, we shall attempt to demystify this error message. Main Article Bad column index errors tend to occur in OGG heterogeneous; i.e., unlike database, environments and most frequently where change control procedures do not require an OGG sign-off for database maintenance tasks. To demonstrate, I have an...
Introduction The "OGG-01161 Bad Column Index" error is possibly one of the most reviled and misunderstood Oracle GoldenGate (OGG) error messages ever created. In this article, we shall attempt...
Introduction Logdump is a standard utility that comes with the Oracle GoldenGate (OGG) application. Logdump enables the user to view and scan for transactions...
Introduction Logdump is a standard utility that comes with the Oracle GoldenGate (OGG) application. Logdump enables the user to view and scan for transactions and records, obtain transaction statistics, and save data contained within OGG Trails. In this article we shall present examples of the Oracle GoldenGate Log File Dump Utility version 12.1.2 functionality that aid in troubleshooting data issues, determining database recovery points, and OGG group load balancing. Main...
Introduction Logdump is a standard utility that comes with the Oracle GoldenGate (OGG) application. Logdump enables the user to view and scan for transactions and records, obtain...
Introduction Oracle GoldenGate (OGG) provides a mechanism for assigning values to parameters at run time. In this article we shall discuss this feature and show...
Introduction Oracle GoldenGate (OGG) provides a mechanism for assigning values to parameters at run time. In this article we shall discuss this feature and show you how to reference operating system variables from within an OGG parameter file. Main Article Typically when we create OGG Groups we edit a parameter file and define configuration options. This requires that we edit the parameter file whenever a change occurs that affects the operating environment. Instead of...
Introduction Oracle GoldenGate (OGG) provides a mechanism for assigning values to parameters at run time. In this article we shall discuss this feature and show you how to reference operating system...
Introduction This article explains how to encrypt sensitive data (such as ssn, credit card number, etc ) in the incoming payload and decrypt the data back to...
Introduction This article explains how to encrypt sensitive data (such as ssn, credit card number, etc ) in the incoming payload and decrypt the data back to clear text (or original form) in the outgoing message. The purpose is to hide the sensitive data in the payload, in the audit trail, console and logs. Main Article Oracle provides Oracle Web Services Manager (OWSM) message protection, but it encrypts the entire payload. However, Oracle OWSM gives us the capability to...
Introduction This article explains how to encrypt sensitive data (such as ssn, credit card number, etc ) in the incoming payload and decrypt the data back to clear text (or original form) in...
