Wednesday, April 26, 2017

ICS on-prem adapters

Just to clear up any possible confusion here -

Here is a list of the on-prem adapters -

AQ - Oracle Advanced Queuing (persistent messaging)
DB2
File
JD Edwards Enterprise 1
JMS
Microsoft SQL Server
MySQL
Oracle Database
Oracle E-Business Suite
Oracle Siebel
Oracle Utilities
SAP

The SOAP and REST adapters also work in respect of on-premise.

#563 - Great post on ICS and Fusion ERP integration from the A-Team

Check it out here






















Tuesday, April 25, 2017

#562 ICS Tech adapters (SOAP/REST) also work in concert with the ICS Connectivity Agent

Looking at the SOAP adapter/connection configuration in ICS 17.1.3 I see the following -

1. a plethora of connection properties -





















2. the ability to leverage the Connectivity agent -










I came across this when investigating whether the ICS Siebel on-premise adapter also covers
Siebel UCM(Universal Customer Master). I wasn't too sure about this, so the alternative was to posit use of the SOAP adapter, which can now work via the connectivity agent.

Later my colleague, Srikanth, pointed me to the following doc
















All the Siebel supported published web services are documented here.

These published web services are available via service catalog interface to the ICS Siebel adapter,
and, quelle surprise, UCM is included.

The doc is available here

Siebel UCM web services are documented here





















Thursday, April 20, 2017

#561 Using A-Team's REPL based ICS management utility

This post leads on from the previous one, which pointed you to the A-Team blog.
Here you can download all of the files described below.

If you haven't already done so, read the previous post, before continuing.

The A-Team utility is python based, so step 1 is to install python -

Install Python


Download python -

















Install/update pip
from Wikipedia - pip is a package management system used to install and 
manage software packages written in Python
python -m pip install -U pip setuptools
pip install directory







Install requests, tabulate, pyreadline and pytz
requests -














tabulate -









pyreadline -








pytz -


Check out the REPL resources

A -Team REPL install directory










servers.txt --> configure for your ICS instance

Here is an extract from the A-Team configuration instructions -

Execution requires a special file – the “server password” file. This file has a specific format: semi-colon separated fields, containing four values:
;;;
URL is the URL of the ICS server. https://mypodname-myiddomain.integration.us2.oraclecloud.com for example. This is the “root” of your usual ICS URL: https://mypodname-myiddomain.integration.us2.oraclecloud.com/ics/faces/global (look when you are logged in to an ICS console).
Alias is a short, unique, nickname for the server, that will be used by the REPL to refer to it. See the “connect” command below.
Username and Password are valid administrative credentials for authentication to the ICS instance.
https://myICSPod;NiallICS;niall.commiskey@oracle.com;myPwd

Now I unzip the repl.zip file







I put python in my PATH










Ok, so let's try it out - python repl.py --servers Path2YourServers.txt 




connect - using the alias from my servers.txt, in my case, NialICS.




list all of my integrations -







Now I just want to retrieve my integrations, they contain the prefix NC.
All I need to do is append the command as follows -

list_integrations - NC
















Now back to the A-Team blog post - here the example script that one can
use for moving ICS artifacts from test to production, simply via the cmdline.












Again, kudos to Christian from the A-Team for creating this!






















Wednesday, April 19, 2017

#560 - ICS REPL tool from Oracle's A-Team

Those boys have done it again!

A great tool to manage your ICS instances and integration lifecycles from the cmdLine.
REPL - Read Evaluate Print Loop.









Download and use it to speed up your work with ICS.

Read all about it here

Enjoy!

Friday, April 7, 2017

#558 ICS Eloqua adapter revisited

I sometime get questions on which use cases can be supported via the ICS Eloqua adapter.
So here are some details from the docs -

The Oracle Eloqua Cloud Adapter enables you to create an integration with an Oracle Eloqua Cloud application. You configure the Oracle Eloqua Cloud Adapter as a trigger (inbound) connection (Oracle Eloqua Cloud to Oracle Integration Cloud Service) or as an invoke (outbound) connection (Oracle Integration Cloud Service to Oracle Eloqua Cloud).
Oracle Eloqua Cloud provides cloud-based marketing software that delivers marketing automation for industries such as finance, health, media, real estate, sports, entertainment, and so on. Oracle Eloqua Cloud simplifies marketing procedures by delivering leads targeted to new customers. Oracle Eloqua Cloud helps manage and organize marketing segmentation and marketing workflow.
The Oracle Eloqua Cloud Adapter accelerates integrations between Oracle Integration Cloud Service and Oracle Eloqua Cloud systems. The Oracle Eloqua Cloud Adapter synchronizes accounts, contacts, and custom objects from Oracle Integration Cloud Service to Oracle Eloqua Cloud systems. Accounts can only be synchronized from Oracle Integration Cloud Service to Oracle Eloqua Cloud systems, and not in the other direction.

The salient sentences are -

The Oracle Eloqua Cloud Adapter synchronizes accounts, contacts, and custom objects from Oracle Integration Cloud Service to Oracle Eloqua Cloud systems. Accounts can only be synchronized from Oracle Integration Cloud Service to Oracle Eloqua Cloud systems, and not in the other direction.

Here is how it is implemented in the ICS adapter -



















So this is a one way adapter for keeping the Eloqua Business Objects - Accounts, Contacts, Fusion Leads, Opportunity, purchase History in sync with other apps. I assume that "Vehicel" is a custom business object defined by one of the Eloqua instance users,

The Eloqua adapter can be used as Trigger as well as Invoke, since version 16.4.5.
Use of the Eloqua adapter requires an Eloqua app to be installed.
Details can be found here


So what about other use cases?
Eloqua provides a rich REST api.























REST API details can be found here

Now let's look at the Eloqua adapter as a trigger in ICS -











































btw. the Eloqua adapter uses the Eloqua Bulk API under the hood.


Happy Marketing!