For other A-Team articles about BICS and Data Sync, click here Introduction Note The current version of the remote data connector available on OTN requires Java...
For other A-Team articles about BICS and Data Sync, click here Introduction Note The current version of the remote data connector available on OTN requires Java 1.8. This may impact the version of the web-server you are able to run. For instance, weblogic 10.3.6 is not certified for java 1.8, but weblogic 12c is. This is a temporary issue, an updated version should be available shortly, and then this section will be removed. This original article was written in March 2016,...
For other A-Team articles about BICS and Data Sync, click here Introduction Note The current version of the remote data connector available on OTN requires Java 1.8. This may impact the version of...
* This blog was last tested on Fusion 20d (11.13.20.10.0) + ADW 18c * Background This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle...
* This blog was last tested on Fusion 20d (11.13.20.10.0) + ADW 18c * Background This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Autonomous Data Warehouse (ADW) using PL/SQL. Oracle Documentation: 20d REST API for CX Sales and B2B Service REST API for Oracle Sales Cloud The blog contains a PL/SQL snippet, that utilizes UTL_HTTP commands to call the "Contacts REST Endpoint" to create a contact from ADW. Alternative Oracle Sales Cloud integration...
* This blog was last tested on Fusion 20d (11.13.20.10.0) + ADW 18c * Background This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Autonomous Data Warehouse (ADW) using...
Introduction Oracle BI Answers, also known as 'Analyses' or 'Analysis Editor', is a reporting tool that is part of the Oracle Transactional Business...
Introduction Oracle BI Answers, also known as 'Analyses' or 'Analysis Editor', is a reporting tool that is part of the Oracle Transactional Business Intelligence (OTBI), and available within the Oracle Human Capital Management (HCM) product suite. This article will outline an approach in which a BI Answers report will be used to extract data from HCM via web services. This provides an alternative method to the file based loader process (details of which can be found here)...
Introduction Oracle BI Answers, also known as 'Analyses' or 'Analysis Editor', is a reporting tool that is part of the Oracle Transactional Business Intelligence (OTBI), and available within the...
As describe in the article Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services, if you are considering connecting to the Cloud and using...
As describe in the article Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services, if you are considering connecting to the Cloud and using Oracle DBCS – Oracle Database Cloud Service - one of the good news is that you can use ODI on-premise to do the work. There are 2 ways to connect: either using the native JDBC Driver, either using a specific Driver. In my investigations on how to use ODI in the Cloud I have tested both drivers. Connect to DBCS using...
As describe in the article Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services, if you are considering connecting to the Cloud and using Oracle DBCS – Oracle Database Cloud...
Introduction Many customers request to get a quick demo how they would deploy their custom Java application in the Oracle Cloud. A great way to do this is...
Introduction Many customers request to get a quick demo how they would deploy their custom Java application in the Oracle Cloud. A great way to do this is Oracle Compute Service which can easily be combined with the Oracle Database as a Service offering. In this example two VMs will be deployed. One for the application server - GlassFish. The second on is a DBaaS VM to hold the database. A simple JSP will be created to display data from the database on the client browser as...
Introduction Many customers request to get a quick demo how they would deploy their custom Java application in the Oracle Cloud. A great way to do this is Oracle Compute Service which can easily...
Introduction While designing SOA services; especially those ones that represent operations around a business object, a common implementation pattern used is...
Introduction While designing SOA services; especially those ones that represent operations around a business object, a common implementation pattern used is upsert. Upsert is an acronym that means the union of "update plus insert". The idea behind is having a unique operation that decides which action to take - either update the existing record or insert a new one - based on information available in the message. Having one operation instead of two, makes the SOA service...
Introduction While designing SOA services; especially those ones that represent operations around a business object, a common implementation pattern used is upsert. Upsert is an acronym that means the...
Introduction Integration Cloud Service (ICS) is an Oracle offering for a Platform-as-a-Service (PaaS) to implement message-driven integration scenarios. This...
Introduction Integration Cloud Service (ICS) is an Oracle offering for a Platform-as-a-Service (PaaS) to implement message-driven integration scenarios. This article will introduce into the use of ICS for integrating an on-premise E-Business Suite (EBS) instance via Database Adapter. While EBS in recent releases offers a broad set of integration features like SOAP and REST support (i.e. via Integrated SOA Gateway), these interfaces are not available in older versions like...
Introduction Integration Cloud Service (ICS) is an Oracle offering for a Platform-as-a-Service (PaaS) to implement message-driven integration scenarios. This article will introduce into the use of ICS...
The Oracle On-Premises Agent (aka, Connectivity Agent) is necessary for Oracle ICS to communicate to on-premise resources without the need for firewall...
The Oracle On-Premises Agent (aka, Connectivity Agent) is necessary for Oracle ICS to communicate to on-premise resources without the need for firewall configurations or VPN. Additional details about the Agent can be found under New Agent Simplifies Cloud to On-premises Integration. The purpose of this A-Team blog is to give a consolidated and simplified flow of what is needed to install the agent and provide a foundation for other blogs (e.g., E-Business Suite Integration...
The Oracle On-Premises Agent (aka, Connectivity Agent) is necessary for Oracle ICS to communicate to on-premise resources without the need for firewall configurations or VPN. Additional details...
For other A-Team articles about BICS and Data Sync, click here Introduction This article will outline a method for extracting data from Taleo Cloud Service, and...
For other A-Team articles about BICS and Data Sync, click here Introduction This article will outline a method for extracting data from Taleo Cloud Service, and automatically loading that data into BI Cloud Service (BICS). Two tools will be used, the Taleo Connect Client, and the BICS Data Sync Utility. The Taleo Connect Client will be configured to extract data in CSV format from Taleo, and save that in a local directory. The Data Sync tool will monitor that local...
For other A-Team articles about BICS and Data Sync, click here Introduction This article will outline a method for extracting data from Taleo Cloud Service, and automatically loading that data into BI...
