Taxonomy is a Sleeper. The reasons from A to ZZZs that taxonomy hasn’t been a part of your most important projects—but should be!

I’m a taxonomy practitioner at Fishbowl Solutions who has worked with many companies to implement simple to sophisticated document management systems. I’ve noticed over the years the large number of obstacles that have prevented companies from establishing taxonomy frameworks to support effective document management. I won’t review an exhaustive alphabetic list of obstacles, in fact, there are probably far more than 26, but I’ll highlight the top culprits that have turned even the best, most (more...)

Oracle GoldenGate for Big Data 12.2.0.1.1 update is available now!

Oracle GoldenGate for Big Data 12.2.0.1.1 update is available

I am pleased to announce the general availability of Oracle GoldenGate for Big Data 12.2.0.1.1.



What’s new in Oracle GoldenGate for Big Data 12.2.0.1.1 ?

  • New Formats – Avro OCF and Sequence File
Oracle GoldenGate for Big Data can now write data in Avro Object Container Format (more...)

Mobile Apps with PL/SQL

We are happy to announce that the first mobil applications built with Formspider are now in production. You can download them from the Apple App Store using this link, or from the Google Play Store using this link.

    


Formspider enables PL/SQL developers to build cross platform mobile apps using only PL/SQL as the programming language.

Read the story of our Dutch client to learn more about Formspider Mobile and the possibilities it opens for (more...)

Integrating Hadoop and Elasticsearch – Part 2 – Writing to and Querying Elasticsearch from Apache Spark

Introduction

In the part 2 of 'Integrating Hadoop and Elasticsearch' blogpost series we look at bridging Apache Spark and Elasticsearch. I assume that you have access to Hadoop and Elasticsearch clusters and you are faced with the challenge of bridging these two distributed systems. As spark code can be written in scala, python and java, we look at the setup, configuration and code snippets across all these three languages both in batch and interactively.

Global Temporary Tables and Upgrading to Oracle Database 12c – Don’t Get Caught Out

Prior to Oracle Database 12c, global temporary tables (GTTs) shared statistics between sessions, so each GTT had one set of statistics visible to all sessions using it. Of course, gathering statistics on GTTs can be very useful because it will help the optimizer find better execution plans, but this advantage was... [Read More]

Oracle’s Fashion Technology Makers: Soldering, Sewing, and Storytelling

Photo 18-05-2016, 11 14 39

Many hands make light (emitting diodes) work. Oracle Applications User Experience (OAUX) gets down to designing fashion technology (#fashtech) solutions in a fun maker event with a serious research and learning intent. OAUX Senior Director and resident part-time fashion blogger, Ultan “Gucci Translated” O’Broin (@ultan), reports from the Redwood City runway.

Fashion and Technology: What’s New?

Wearable technology is not new. Elizabeth I of England was a regal early (more...)

Compartmentalised Oracle Security

I have been teaching security classes about Oracle Security for many years and they are very popular and I teach many classes per year around the world; mostly in the UK and EEC but I also venture to the Middle....[Read More]

Posted by Pete On 24/05/16 At 12:43 PM

Automated Unittesting of XQueries in Oracle OSB by Pascal Brokmeier

clip_image002In order to support a more agile project environment, OPITZ CONSULTING developed a Java/JUnit based SOA Unit Testing Framework. Among others, the framework was capable of using the Oracle libraries to run XQuery tests locally and verify their correctness. Over the course of time, Oracle released 12c and with it, changed its xquery files. A new extension (.xqy instead of .xq) was introduced and with it additional syntax. Oracle added a(:: OracleAnnotationVersion "1. (more...)

Chargeback in Oracle Enterprise manager 13C

Since Oracle Enterprise Manager 12C it is possible to allocate the costs of IT resources to the people of organizations who consume them. This is done through the use of the plugin ‘Consolidation Planning and Chargeback’ .

Pete Sharman wrote an excellent blog about configuring  this plugin in Enterprise Manager 12c, and it’s not my intention to copy his work, so I’d like to focus on complementary stuff regarding Oracle Enterprise Manager 13c.

In this article (more...)

Technology Evolution As Seen Through Conference Session Titles

I recently (last week) participated in JavaCro, a great Java conference in Croatia. I have participated in that event since its inception in 2012. Here are the titles of the keynotes I presented at JavaCro over the years:

  • "Unlocking the Java EE 6 Platfom" (29 - 30 May, 2012, in Tuhalj)
  • "Unlocking the Java EE platform with HTML5" (3 - 5 June, 2013, in Tuhalj)
  • "Consuming Java EE Backends in Desktop, Web, and Mobile (more...)

Using DBMS_STREAMS_ADM To Cleanup GoldenGate

This is really messed up. I chose GoldenGate because I did not want to mess around with streams.

When using Integrated Capture or Delivery, then knowing streams is a prerequisites.

Apologies as the format is not pretty.

The QUEUE table was indeed missing and this is what I get for monkeying around.

To resolve the issue –  exec DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();

GGSCI (arrow.localdomain as ggs_admin@hawk) 3> unREGISTER EXTRACT e_hawk DATABASE

2016-05-23 19:16:32  ERROR   OGG-08221  Cannot  (more...)

Enterprise Manager 13c and AWS

This posting is to try to clarify what is supported when using Enterprise Manager Cloud Control 13c (EM13c) and Amazon Web Services (AWS). The question came from some of our sales consultants who were finding confusing information about what is actually supported when using EM13c and AWS, so I have asked our Support folks to write a support note to provide the definitive answer on this. While that is being written, I thought I would (more...)

BDB User Authentication

BDB User Authentication (courtesy of  Brayden Zhang) Introduction In Berkeley DB 6.2, user authentication extension is added into the SQL interface. The new user authentication layer is both secure and easy to use. In this article, we will introduce how to use the user authentication, and also... [Read More]

Locked/Unlocked Icons on Packages Matching “module-info.java” File

Here's what I'm working on in the context of Jigsaw, which kind of proves the awesomeness of the NetBeans APIs, since this is provided by an external NetBeans module. Take a look at the icons on the packages in the Projects window. Two of them have an unlocked lock icon ("com.wordlibrary" and "com.wordlibrary.spi") while the other two have a locked lock icon. The unlocked lock icons indicate that those packages have been (more...)

HIUG Interact 2016 Agenda

In a couple of weeks, I will be presenting the following sessions at the HIUG Interact 2016 conference in San Antonio

  • 16165 : PeopleSoft Fluid User Interface – Deep Dive: Grand Oaks D, Mon, Jun 13, 2016 (03:15 PM - 04:15 PM)
  • 16164 : PeopleTools Tips & Techniques: Grand Oaks D, Tue, Jun 14, 2016 (02:30 PM - 03:30 PM)
  • 16163 : Tech Clinic: Application Designer Grand Oaks D, Wed, Jun 15, 2016 (12:30 PM (more...)

Oracle PL/SQL Developer Certified Professional

Today I passed my exam for Oracle PL/SQL Developer Certified Professional(OCP)... Hurray!

Short-term Answers Vs. The Correct Answer

Enterprise Manager does a LOT.  Sometimes it may do too much.  Customers on forums, on support or via email and social media may come to us asking how to address something they view as not working right and the truth is, we could simply answer their question, but they aren’t using the right tool to accomplish what they’re attempting.

wrongtool

The Export Feature in Enterprise Manager

A customer was (more...)

Charting Values over Time in a SQL Developer Report

Today’s post is courtesy of this question from a reader: Can the SQLDeveloper Report/Chart feature create a line chart where x contains date/time and y the values to be plotted? The answer is ‘Yes!’ I’m going to use HR.EMPLOYEES to give me my data. I start with… SELECT Hire_date,... [Read More]

Virtual Partitions

Here’s a story of (my) failure prompted by a recent OTN posting.

The OP wants to use composite partitioning based on two different date columns – the table should be partitioned by range on the first date and subpartitioned by month on the second date. Here’s the (slightly modified) table creation script he supplied:


CREATE TABLE M_DTX
(
        R_ID    NUMBER(3),
        R_AMT   NUMBER(5),
        DATE1   DATE,
        DATE2   DATE,
        VC GENERATED ALWAYS AS (EXTRACT(MONTH FROM DATE2))
)
PARTITION  (more...)

Moving from PeopleSoft to the Oracle Cloud

Those of you who know me will know that I’m working at Cedar and we’re moving from PeopleSoft to the Oracle Cloud. I won’t talk about the company’s journey, but more how I’ve found the transition personally.

In brief, there’s a lot to learn.

Data Model knowledge

In the PeopleSoft world, once you know the table structures you could work significantly faster. Whether you were writing an SQR, an App Engine, an XMLP report, a (more...)