Recent Posts by Juergen Kress

JavaScript has been around since 1995. But a lot has changed in nearly a quarter-century. No longer limited to the browser, JavaScript has become a full fledged programming language, finding increasing use in enterprise application development. In this program a panel of experts explores the evolution of JavaScript, discusses how it is used in modern development projects, and then takes a close look at Oracle JavaScript Extension Toolkit, otherwise known as JET. Listen to the...

Queue Setup in Oracle Advanced Queuing First step was to set up the Q in AQ. CREATE type Message_typ as object ( subject     VARCHAR2(30), text        VARCHAR2(80));  EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'objmsgs80_qtab',queue_payload_type => 'Message_typ'); EXECUTE DBMS_AQADM.CREATE_QUEUE (queue_name => 'msg_queue',queue_table => 'objmsgs80_qtab'); EXECUTE DBMS_AQADM.START_QUEUE (queue_name => 'msg_queue'); I then created a procedure to create a message – Read ...

Learn how to use Oracle's JavaScript Extension Toolkit (JET) as a solution to the all too common problem of internal back office and intranet applications that are typically ugly, clunky, and cumbersome to use. JET simultaneously provides you with a JavaScript toolkit that is cutting-edge while being stable enough for enterprise development in an ecosystem that is notorious for its fast-paced rate of change. Practical Oracle JET walks through the process of developing a...

This is a frequent requirement to call Business Intelligence (BI) service in Oracle Integration Cloud (OIC). This article focuses on how to call BI SOAP API in OIC scheduler process and extract data. See useful links How to create a SOAP connection How to create a Scheduled Integration First, have a look at the sample request and response of BI SOAP API BI SOPA Endpoint: https://ef-dev1.af.em1.oraclecloud.com/parser/services/v2/ReportService?wsdl Method: runReport Read the...

This article speaks on simplifying the process of creating and registering a custom converter in your Oracle JET application. The entire job can be essentially broken down into 3 parts: 1. Creating the custom converter (including the logic for formatting the input data). 2. Registering the new converter with JET runtime, and finally, 3. Using the converter. The converter which I am going to talk about is a Phone-Number-Converter. It takes in a string or a number input value,...

The March video includes three topics: • Oracle sales kits for Partners • Hands-on Bootcamps for Integration & Digital Assistant • Integrate ERP community webcast For regular updates please subscribe to our YouTube channel here. Thanks for your likes and sharing the video on YouTube and LinkedIn.   For the latest PaaS Community information please visit our Community update wiki here (Community membership required).   Blog Twitter LinkedIn Facebook Meetups Technorati Tags: YouTube,PaaS,Clou...

Attend our March edition of the PaaS Partner Community Webcast live on March 25th 2020 at 16:30 CET. Integration to applications is dramatically simplified by the use of application adapters that eliminate the complexity associated with web services and other connectivity methods. Simplify your integration to connect with virtually any application, service, or data store. Oracle offers a library of these adapters to provide you with a standardized way to rapidly connect the...

Background Parking lot pattern is a mature design to store the data in an intermediate stage before processing the data from the intermediate stage to the end system based on the required rate. The detailed implementation of the parking lot pattern can be done in a variety of  storage technologies but strongly recommended a database table to be used for simplicity. In this blog, we will use the parking lot pattern in the Oracle Integration Cloud (OIC) to explore a solution in...

In a previous blog I showed you how to create an object function for a business object to allow you to expose specific functionality on a specific row. This blog is a little variation on this capability showing you how to create service methods in your data layer that are not related to a specific row. This is based on a use case a customer had where they would get data for a record in a table, if the row already exists in the table they need to update it. If it doesn't exist...