JMJ CLOUD
  • Home
  • Projects
  • Blog
  • About Us
  • Contact Us

Our Blog

Oracle Exadata Express an Integration Story

8/17/2017

 

Introduction

The integration landscape is changing... again!
From Gartner:
​The application integration technology market is adapting to digital business requirements. A mix of mature ESB suites and emerging iPaaS- and iSaaS- based offerings provides broader options for application leaders to modernize integration infrastructure toward a hybrid integration platform.
Picture
Enter Exadata Express APEX and ORDS, a PaaS service with the capabilities to be an integration hub with a scalable web development platform thrown in!

​As the saying goes "there are many ways to skin a cat". There are also many ways to do Cloud Integration. We are told that the 'proper' way of doing integration is to use fully baked SOA software solutions such as Oracle's SOA Suite, Mule, Jitterbit, Dell Boomi etc. Sometimes this kind of software is absolutely the right choice, but all too often it is overkill. Many small to medium sized businesses (and even large corporations) just need a secure, reliable and platform agnostic method of integrating data. Oracle's Exadata Express with ORDS, the Oracle Database and the APEX_WEB_SERVICE API provide all of this at a fraction of the cost. Did I mention you get a scalable web development platform thrown in?


To illustrate this right sized integration approach, I want to take you through a use case that involves our company JMJ Cloud. Having worked for Oracle Consulting for 18 years, I am familiar with the concept of eating one's own dog food. In view of this, using Oracle tools to integrate our internal systems seemed like the right thing to do. The thought of paying thousands of dollars a month to do this, however, did not make much sense. We opted instead for Exadata Express and it turns out that eating your own dog food is tastier than you might think!

Background

As a burgeoning Oracle technology, consulting company we have some core needs for the software that runs our business:
  • Capturing consultants time
  • Handling our financials, invoicing, paying vendors etc.
  • Project and task management
  • Software code packaging and deployment
  • Tracking new opportunities and recruits​
Our current portfolio consists of QuickBooks On-Line for financials, Atlasssian's Service Desk for managing new work with our clients and Atlasssian's Jira Software for managing agile projects. For everything else, we build our own application's using APEX running on Exadata Express. For the remainder of this post, I will focus on two key integrations that bring us a significant benefit for a relatively low investment.

Capturing Time (Service Desk to Exadata Express)

About half of our work comes through our customers entering tickets or work orders via a Portal in Service Desk. Our consultants perform work against these tickets and log their time into an APEX application we built on Exadata Express. As tickets come in, we integrate them in real time to Exadata Express allowing our consultants to enter their time against a specific ticket. This allows us to provide our customers with an APEX portal showing them a detailed breakdown of hours billed by ticket.
Picture

The diagram shows the flow of this real-time integration:
  • A ticket is entered by customer in Service Desk.
  • A WebHook in Jira calls a REST Service in ORDS in real time, passing the Ticket ID.
  • The ORDS REST service uses APEX_WEB_SERVICE in Exadata Express to call back to a REST Service in Jira. Doing this allows use to pull just the information we need from the ticket and save it to a table in Exadata Express.
  • The consultant logs in to the APEX time entry application and selects the ticket to enter their time against.
  • Finally, the customer can login to their APEX portal to see time entered against each ticket.

Capturing Costs (QuickBooks Online to Exadata Express ) 

QuickBooks Online is used to record supplier invoices and our business purchases captured on corporate credit cards.  While Quickbooks has reporting functionality, it isn't as rich or configurable as that available within Exadata Express.  

We schedule a feed of all invoices and expenses to Exadata every 15 minutes.  This allows us to build sophisticated reports on our costs.  In addition, we make contractor invoices visible with their Apex portal so they can confirm that they have been entered and see when a payment has been made.
Picture

​The diagram shows the flow of this scheduled integration:
  • Supplier invoices and expenses are entered directly into QuickBooks or imported from bank or credit card statements.
  • A scheduled job in Exadata Express is created using the CLOUD_SCHEDULER built-in package to run every 15 minutes.
  • The job calls REST web services in QuickBooks Online using APEX_WEB_SERVICE, returning new or updated costs in a JSON document. 
  • The JSON document is processed into Exadata Express and becomes available for reporting.
  • Managers analyze expenses and third-party invoices with the APEX management portal.
  • Consultants can log into their APEX portal to confirm that their invoices have been received, entered and see the invoice payment status.

Exadata Express Highlights

Picture
  • Host REST web services via ORDS (with OAUTH2 security built in)
  • Call out to SOAP and REST services using APEX_WEB_SERVICE
  • Schedule integrations using CLOUD_SCHEDULER
  • Build beautiful and performant web applications using APEX
  • Cloud Integration and PaaS for Everyone
  • Cost effective ($175 / month)

Conclusion

Cloud integration is a brave new world. Using the right tool for the job, however, is a constant that has been around since common sense. Exadata Express and its cousin (Schema as a Service) are the right tools for the majority of Cloud Integration and PaaS extension jobs we are being asked to do.
Peter Care link
8/18/2017 11:34:27 am

Thanks - nice approach and message on integration.
We use DBMS_CRYPTO in Database Schema Service, and would like to use in in Exadata Express too, so I echo your call to Oracle to include it.


Comments are closed.

    RSS Feed

    Popular Posts

    - APEX Dog Food
    - Cloud ERP & APEX Mashup
    - Modernizing EBS with APEX
    - Easy APEX_WEB_SERVICE
    - Running APEX in RDS
    - ORDS What & Why?

    Categories

    All
    APEX
    AWS
    Fusion Cloud ERP
    INTEGRATION
    MS GRAPH
    OCI
    ORDS
    PaaS
    RAD
    REST
    SOAP

    Archives

    October 2021
    February 2021
    January 2021
    October 2020
    September 2020
    June 2020
    May 2020
    April 2020
    February 2020
    January 2020
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    September 2017
    August 2017
    July 2017
    June 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016

Company

About
Contact
Blog
  • Home
  • Projects
  • Blog
  • About Us
  • Contact Us