Saturday, November 7, 2015

MuleSoft Summit in Amsterdam

Last Wednesday I went to the MuleSoft Summit in Amsterdam to learn more about Mulesoft and their vision for the future of integration. The following topics / presentations were given during the day:



  • API-led Connectivity: Driving Digital Transformation - Guy Murphy, MuleSoft Solution Principal - Strategic Accounts EMEA
  • Lean Systems: Our experience in integration industry - Stijn Decneut
  • Hybrid Integration Platform:  Foundational Infrastructure for a Digital Business - Guy Murphy, MuleSoft Solution Principal - Strategic Accounts EMEA
  • API-led Connectivity - Paul Crerand, MuleSoft Director Solution Consulting EMEA
  • "How" to enable Digital Transformation - Nick Cochran, MuleSoft Senior Director EMEA Customer Success
  • Anypoint Platform: High-Level Roadmap - Paul Crerand, MuleSoft Director Solution Consulting EMEA


Of course these cover lot of content, so I will write about a few 3 industry trends that I found interesting. But first, a bit more on Mulesoft!

About Mulesoft



MuleSoft is a software company headquartered in San Francisco, but have offices around the world (including Amsterdam). Started in 2006, the company's Anypoint Platform of integration products are designed to tie together software as a service (SaaS) and on-premises software.


Mulesoft is also the only leader in all three Gartner Magic Quadrants:




Three new industry Trends

1. SOAP (WSDL) vs. REST (RAML)

Source: google.com/trends


Some organizations think that REST is still just for mobile and performance gains, however that is simply not true. It can be said that one reason SOA failed is that services were build for the consumer, and not for the customer.


SOAP’s pitfall is that it has become way too complex and is not human readable. Consider the example below:


  • Customers don’t care about servers.
  • Customers don’t care about policies.
  • Customers work with whoever is the most (capable &) convenient, at that moment.


Just because you create it does not mean someone will use it.


When designing your API’s focus on your core business capabilities, and expose them as conveniently as possible. REST APIs can make connecting to a business as convenient as browsing their website. Just compare above example to below:




2. The new role of IT

"By the end of 2017 Demand for Enterprise Mobile Apps Will Outstrip Available Development Capacity Five to One" - Gartner


Thus, IT can no longer build the apps, IT must govern and supply the data (via API’s).




So, how do you get started on this? This leads to industry trend number 3...


3. Hybrid Integration Platform



Challenges:


  • Enterprises have access to unprecedented amounts of data. Where are the API’s?




  • “Everything will be digital and everything will connect.”




Solution:
Hybrid integration platform (HIP).


Definition:
“A hybrid integration platform is on-premises and cloud-based, integration technologies securely connected so that it supports the integration of on-premises endpoints, cloud endpoints and the combination of the two, for all integration patterns.” - Gartner


Thus, modern enterprises need to have a HIP strategy. There are different ways to tackle this, but of course the Mulesoft recommendation is to use their Anypoint Platform: “One Platform to connect any application, data source, or API, to support HIP needs”


iPaaS Platform Features
  • Integration Services Development Platform Governance Platform
  • Life Cycle Management Platform
  • Content Marketplace Collaboration
  • Monitoring, Management, and Administration
  • Secure Connectivity to On- premises Platform


Application Integration Suite Features
  • Communications Transformation
  • Orchestration Intelligent Routing Adapters
  • Legacy B2B Gateway
  • Monitoring, Management and Administration
API Management Platform Features
  • Policy Management
  • Security, SLAs, ...
  • Policy Enforcement
  • Central PAP, Distributed PEPs
  • Security
  • Security Extensions
  • Token Mapping, Redaction
  • Management of Traffic
  • Messages Interfaces
  • Developer Support API Customization


All in all I enjoyed the day, and I am looking forward to start playing and learning more about the Mulesoft Anypoint Platform!

Friday, March 6, 2015

Code Snippet Icons in JDeveloper

When using the 'Code Snippets' feature in JDeveloper you have the option to browse for a .png file to use as a icon. However, I've found that this does not work (in both Jdev 11g and 12c) even though in the main window it will load the correct .png, it does not use it on the Components Pallet.


However, as a workaround I've found that you can use the build-in icons that are located in the jar files, but you need to know their names and paths. Thus, here is a list of the jar files that can be used for icons.

  • [MIDDLEWARE_HOME]\oracle_common\modules\oracle.javatools_[JDEV_VERSION]\oicons.jar
  • [MIDDLEWARE_HOME]\oracle_common\modules\oracle.javatools_[JDEV_VERSION]\javatools-nodeps.jar
You can open each of these files, and view the icons inside that can be used. (You will need a tool such as 7-Zip to open / extract the jar)


You can then use the following path to reference the files with the correct filename:
  • /oracle/javatools/icons/[filename].png


Now even though you don't have your own icons, you still at least can have different and more appropriate icons for your snippets. 

Wednesday, January 21, 2015

Oracle BPM Worklist details display error

I’ve had the issue several times on Oracle BPEL Worklist app where the details of the task is not displayed with the error ‘Server not found’.image
The the reason for this seems to be that the page is trying to resolve a internal load balancer address, and not the external facing client side load balancer that the browser can access. To fix this, do the following steps:
Go to the BPEL process of the specific composite in Enterprise Manager. Then click on the Human task under the Component Metrics tab.image
You’ll then see the internal address and port that cannot be resolved from your web browser.image
Replace these with the external address as well as port. (Most probably the one used when accessing the Worklist app url) Click “Apply”image
 image
Your Worklist app should now load.
image
Credit: Thanks to my colleague Ben Taljaard for helping to solve this issue.

Tuesday, December 23, 2014

Direct Binding Adapter between Oracle Fusion Middleware 11g and 12c

From Oracle documentation we know the following:
“A SOA composite can invoke any Service Bus SB WSDL-based proxy service. To invoke an SB proxy service, the SOA service component must use a direct binding reference of Target Type "Oracle Service Bus."

However can this we done between FMW11g and FMW12c? The answer is in fact YES, and this can help in a strategy to run 11g and 12c in parallel without compromising performance.
clip_image002[4]
Steps on how to achieve this:
Open your 11g Service Bus Console.
clip_image004[4]
Go to your http OSB proxy service, and edit the Transport Configuration.
clip_image006[4]
Switch the protocol from http to sb.
 clip_image008[4]
Click Last. Click Save. Click Activate. Click Submit.
 clip_image010[4]
Export the WSDL of the proxy to be used later in JDeveloper. (It will export as a .jar file that you can extract)
clip_image012[4]
You have now changed the protocol of the proxy from HTTP to SB. Thus this proxy cannot be invoked over the HTTP protocol anymore. Alternatively you can create a clone of the proxy service and have a HTTP and SB version available.
Now launch JDeveloper for 12.
clip_image014[4]
Create a new BPEL process in the same way as normally done.
clip_image016[4]
Now drag in the Direct Binding from the BPEL Services tab under the Components tab.
clip_image018[4]
Supply a name and change the Reference Target to Oracle Service Bus. Then browse for the WSDL file you downloaded earlier. Note that the Provider URL is t3 protocol.
Click OK.
clip_image020[4]
Create an Invoke step, and assign the input and output of the call like you would normally do.
 clip_image022[4]
Deploy the SCA to your 12c environment and log into Enterprise Manager 12c.
 clip_image024[4]
You can now test the Service.
 clip_image026[4]
You can also launch the flow trace to inspect the flow. Note the Direct Binding icon on the flow.
 clip_image028[4]
You have now successfully connected OSB11g and BPEL12c without the overhead of HTTP calls!

Friday, June 25, 2010

OTM EBS Customer Integration

I have got a couple of queries on the otmfaq.com site at: http://www.otmfaq.com/forums/f24/customer-information-616-new/
Thus I’ve provided the queries here:
select 'CUS-'||rac.customer_id customer_XID, rac.customer_name, 'ZAF' customer_country, 'CUS-'||rac.customer_id||'-'||arv.party_location_id customer_location_XID, rac.customer_name||','||substr(arv.city,1,10)||','||substr(arv.province,1,4)||','||nvl((SELECT b.iso_territory_code FROM FND_TERRITORIES_VL b WHERE UPPER(b.territory_code) = UPPER(arv.country)),'TBA') location_name, arv.address1, arv.address2,arv.address3, arv.address4, arv.city, arv.province, arv.postal_code, nvl((SELECT b.iso_territory_code FROM FND_TERRITORIES_VL b WHERE UPPER(b.territory_code) = UPPER(arv.country)),'TBA') country from ra_customers rac left join ar_addresses_v arv on rac.customer_id = arv.customer_id;
select 'CUS-'||rac.customer_id customer_XID, rac.customer_name, 'ZAF' customer_country, 'CUS-'||rac.customer_id||'-'||arv.party_location_id customer_location_XID, rac.customer_name||','||substr(arv.city,1,10)||','||substr(arv.province,1,4)||','||nvl((SELECT b.iso_territory_code FROM FND_TERRITORIES_VL b WHERE UPPER(b.territory_code) = UPPER(arv.country)),'TBA') location_name, nvl(arv.address1,' ') address1, nvl(arv.address2,' ') address2,nvl(arv.address3,' ') address3, nvl(arv.address4,' ') address4, nvl(arv.city,' ') city, nvl(arv.province,' ') province, nvl(arv.postal_code,' ') postal_code, nvl((SELECT b.iso_territory_code FROM FND_TERRITORIES_VL b WHERE UPPER(b.territory_code) = UPPER(arv.country)),'TBA') country from ra_customers rac left join ar_addresses_v arv on rac.customer_id = arv.customer_id;
--Customers
select 'CUS-'||rac.customer_id customer_XID, rac.customer_name, 'ZAF' customer_country from ra_customers rac;
--Customer locations
select 'CUS-'||rac.customer_id||'-'||arv.party_location_id customer_location_XID, rac.customer_name||','||substr(arv.city,1,10)||','||substr(arv.province,1,4)||','||nvl((SELECT b.iso_territory_code FROM FND_TERRITORIES_VL b WHERE UPPER(b.territory_code) = UPPER(arv.country)),'TBA') location_name, arv.address1, arv.address2,arv.address3, arv.address4, arv.city, arv.province, arv.postal_code, nvl((SELECT b.iso_territory_code FROM FND_TERRITORIES_VL b WHERE UPPER(b.territory_code) = UPPER(arv.country)),'TBA') country, 'CUS-'||rac.customer_id customer_parent from ra_customers rac left join ar_addresses_v arv on rac.customer_id = arv.customer_id;
For some of this you will need to set the environment first:
begin dbms_application_info.set_client_info(<your_org_id>); end;