Introduction Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the...
Introduction Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the source and target tables structures are the same. The challenge comes when the source and target tables have a dissimilar table structure; as may exist in a Data Warehouse or Reporting Database. In this article we shall demonstrate the use of Oracle GoldenGate coupled with the Oracle Database DBMS_STREAMS.SET_TAG...
Introduction Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the source and target tables structures are...
Introduction Every time a customer is created in System X, it should trigger an integration which creates the customer in System Y as well. This is a very...
Introduction Every time a customer is created in System X, it should trigger an integration which creates the customer in System Y as well. This is a very common requirement, and different applications address it differently. For example, Oracle Sales Cloud (OSC) and E-Business Suite (EBS) provide business events; Commerce Cloud has WebHooks. You subscribe to these events or register a webhook and a message is received, which may be used to trigger an integration. In this...
Introduction Every time a customer is created in System X, it should trigger an integration which creates the customer in System Y as well. This is a very common requirement, and...
Purpose This article is meant to provide steps to test latency and throughput between servers and/or datacenters. The tests described here are not meant to test...
Purpose This article is meant to provide steps to test latency and throughput between servers and/or datacenters. The tests described here are not meant to test application performance from and end user perspective. Overview This post will provide an overview of some basic throughput and latency testing. Before testing, check your route. Is it static? Is it dedicated? If you using the open internet, results are going to be subject to more fluctuation. Something like...
Purpose This article is meant to provide steps to test latency and throughput between servers and/or datacenters. The tests described here are not meant to test application performance from and...
Introduction RSS (Really Simple Syndication I always called it but also Rich Site Summary) is an XML document containing headline or summary items. Consuming...
Introduction RSS (Really Simple Syndication I always called it but also Rich Site Summary) is an XML document containing headline or summary items. Consuming RSS feeds in JavaScript is more convenient with JSON data so we'll take a look at tools to convert a feed to JSON. Then we'll look at examples of using RSS data on a web page and CEC (Content & Experience Cloud) component. RSS Data There are a number of RSS feed guides, for example NYU Libraries. Using New York Times -...
Introduction RSS (Really Simple Syndication I always called it but also Rich Site Summary) is an XML document containing headline or summary items. Consuming RSS feeds in JavaScript is more convenient...
BLOG RETIRED Oracle SaaS has announced that it no more supports BIP connecting to external datasources. Please refer to Oracle Support note - support doc (ID...
BLOG RETIRED Oracle SaaS has announced that it no more supports BIP connecting to external datasources. Please refer to Oracle Support note - support doc (ID 2003782.1). However, for customers who have already implemented this pattern it will still continue to work.
BLOG RETIRED Oracle SaaS has announced that it no more supports BIP connecting to external datasources. Please refer to Oracle Support note - support doc (ID 2003782.1). However, for customers...
Introduction This blog details the solution using Oracle Integration Cloud (OIC) and Integration Cloud Service(ICS) for file based integrations using Universal...
Introduction This blog details the solution using Oracle Integration Cloud (OIC) and Integration Cloud Service(ICS) for file based integrations using Universal Content Management (UCM) Webservices for Oracle HCM Cloud integration. Deprecation of SaaS sFTP servers for Oracle HCM Cloud and other Oracle Cloud applications was announced recently. Refer to the below MOS Support Doc Note for the announcement and related articles. Oracle Applications Cloud Hosted SFTP Server...
Introduction This blog details the solution using Oracle Integration Cloud (OIC) and Integration Cloud Service(ICS) for file based integrations using Universal Content Management (UCM) Webservices for...
Introduction In this article we shall discuss how to configure Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud Service (GGCS) via...
Introduction In this article we shall discuss how to configure Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud Service (GGCS) via HTTP Proxy Server. This discussion will include a sample configuration setup. This approach is very similar to configuring OGG Replication between On-Premises and GGCS via DMZ server, the only main difference is how the GoldenGate uses the mid-tier server. For details on configuring OGG Replication via DMZ server...
Introduction In this article we shall discuss how to configure Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud Service (GGCS) via HTTP Proxy Server. This discussion will...
In the previous two posts, Part 1 and Part 2, we gave an overview which Business Events are available in R13 and how you can subscribe to events with external...
In the previous two posts, Part 1 and Part 2, we gave an overview which Business Events are available in R13 and how you can subscribe to events with external applications using Oracle ICS/OIC. In this part, we will show how to filter events using XPath expressions. Use Cases for Filtering Business Events The approach on sending a message in case of every creation/update/deletion of a Business Object is not what might be required in a specific use case. In our previous...
In the previous two posts, Part 1 and Part 2, we gave an overview which Business Events are available in R13 and how you can subscribe to events with external applications using Oracle ICS/OIC. In...
Following the overview in Part 1, I will now show detailed steps how to create the event subscriptions. In our example, we will use an "Item Creation" event...
Following the overview in Part 1, I will now show detailed steps how to create the event subscriptions. In our example, we will use an "Item Creation" event (from SCM cloud). Prerequisite: Register CSF Key in SaaS In a FA-based SaaS instance, the outbound call of a webservice uses a OWSM security policy which retrieves the credentials for the call from a CSF Key. This means that you need to register a CSF key for every connection to an external system. In our case we need to...
Following the overview in Part 1, I will now show detailed steps how to create the event subscriptions. In our example, we will use an "Item Creation" event (from SCM cloud). Prerequisite:...
