* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction This functionality has been available since Version 2.2 of the Data Sync tool, released September 2016, when the ability to connect to a number of different data sources via JDBC was added to the product. Setting up these Data Sources in Data Sync varies by the source. Rather than...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction This...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + SalesForce 2021 + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + SalesForce 2021 + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction This functionality has been available since Version 2.2 of the Data Sync tool, released September 2016, when the ability to connect to a number of different data sources via JDBC was added to the product. Setting up these Data Sources in Data Sync varies by the source. ...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + SalesForce 2021 + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here...
* This blog was last tested on: Oracle Analytics Cloud Data Sync (2.6.1) + Oracle Service Cloud 20B (Build 266) + ADW 18c by Jay Pearson (Oracle A-Team) * For...
* This blog was last tested on: Oracle Analytics Cloud Data Sync (2.6.1) + Oracle Service Cloud 20B (Build 266) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction This functionally has been available since Data Sync v2.2 released in September 2016 - when the ability to connect to a number of different data sources via JDBC was added. Setting up these Data Sources in Data Sync varies by the source. Rather than...
* This blog was last tested on: Oracle Analytics Cloud Data Sync (2.6.1) + Oracle Service Cloud 20B (Build 266) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data...
* This blog has not been recently tested on the latest version of Data Sync because it is superseded by inbuilt SSH functionality described in this blog - Jay...
* This blog has not been recently tested on the latest version of Data Sync because it is superseded by inbuilt SSH functionality described in this blog - Jay Pearson (A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction Since this article was written, the ability to create an SSH tunnel has been added as inbuilt functionality to the Data Sync tool. For more details of how to use that, please see this article. The method detailed in this...
* This blog has not been recently tested on the latest version of Data Sync because it is superseded by inbuilt SSH functionality described in this blog - Jay Pearson (A-Team) * For other A-Team...
Introduction For data replication products like Oracle GoldenGate (OGG), it is typically a best practice to have a primary key or unique index defined for...
Introduction For data replication products like Oracle GoldenGate (OGG), it is typically a best practice to have a primary key or unique index defined for tables being replicated. However, in practice this may not be possible when working with poorly designed databases or legacy applications. In this article we shall detail OGG's rules for determining uniqueness in replicated data and present examples and best practices for working with tables without primary keys or unique...
Introduction For data replication products like Oracle GoldenGate (OGG), it is typically a best practice to have a primary key or unique index defined for tables being replicated. However, in practice...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. At any given time, organizations are gathering,...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. At any given time, organizations are gathering, storing, and transferring millions of records about their customers across multiple enterprise environments. There are various operational settings within Oracle GoldenGate (OGG) that should be set to ensure Personally Identifiable Information (PII), or Sensitive Personal Information (SPI) is not compromised. This article...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. At any given time, organizations are gathering, storing, and transferring millions of records...
hljs.initHighlightingOnLoad(); Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher...
hljs.initHighlightingOnLoad(); Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher report from a SOAP Service and retrieve the report, as XML, as part of the response of the SOAP call. This blog article serves as a follow on blog article providing a tutorial style walk through on how to implement the above procedure in Java. This article assumes you have already followed the steps in Richard's blog...
hljs.initHighlightingOnLoad(); Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher report from a SOAP Service and...
Deprecation of Remote Data Connector (RDC) Private Access Channel is now available in Oracle Analytics and is recommended by Oracle for new connections to...
Deprecation of Remote Data Connector (RDC) Private Access Channel is now available in Oracle Analytics and is recommended by Oracle for new connections to private data sources. For connections where Private Access Channels is not yet supported, Data Gateway should be used instead of RDC. For more information on Private Access Channel and Supported Data Sources: Connect to Private Data Sources Through a Private Access Channel Supported Data Sources A-Team Chronicles Private...
Deprecation of Remote Data Connector (RDC) Private Access Channel is now available in Oracle Analytics and is recommended by Oracle for new connections to private data sources. For connections...
This blog is part of the series of blogs the A-Team has been running on Oracle Service Cloud (OSvC). In the previous blog I went through an introduction to the...
This blog is part of the series of blogs the A-Team has been running on Oracle Service Cloud (OSvC). In the previous blog I went through an introduction to the Bulk APIs in OSvC and briefly touched upon throughput considerations(If you haven't, please read that first). In this blog I build on the previous post and delve deeper into various operational factors to consider when implementing bulk data load into OSvC. For the purpose of this blog, I define bulk import(or bulk...
This blog is part of the series of blogs the A-Team has been running on Oracle Service Cloud (OSvC). In the previous blog I went through an introduction to the Bulk APIs in OSvC and briefly touched...
