Oracle Data Warrior

Taking on Data Architecture, Data Warehousing, Data Vault, Fitness, Exercise, and who knows…

A New Limerick to start your week…

This was an assignment my son did for his 3rd grade class. They were studying styles of poetry. This one he was proud of and asked me to publish for him. Enjoy.

A New Limerick

by Biaggio Graziano (copyright 2013 all rights reserved)

Once there was a dog and a frog

They live in a log in a bog

With a bird named Bob

Who has no job

They all have a big blog

 

Paralyze resistance…

Paralyze resistance with persistence.

– Woody Hayes (College football coach)

Resistance is futile

– The Borg (Intergalactic marauders)

By failing to prepare

By failing to prepare, you are preparing to fail.

- Benjamin Franklin

Another First at ODTUG’s #Kscope13

Those crazy kids at ODTUG have done it again!

At this year’s KScope in New Orleans this user group is introducing an evening of crossover sessions. Over the years the event has grown and actually blended the traditional Oracle database development world with the world of EPM, Hyperion, and Essbase.

In fact many folks who have come down the typical Oracle development path, myself included, know very little about the other side. So for these past few years at the conference we found there were not a lot of people crossing the various tracks (after all there are so many options to choose from).

In order to promote better cross pollination and as a way to encourage folks to expand their horizons and start to understand the “other” side, ODTUG has added two evening sessions on Tuesday so that we can gain that knowledge and not have to skip any of our regualr sessions.

The sessions will be presented by seasoned ODTUGers and Oracle ACEs. Check out these sessions:

Oracle Database Tools 101: How Does All This Stuff Get Built Anyway?

John King, King Training Resources

If you’ve been an Essbase/Hyperion, Applications, or BI user you may wonder what all the “hubbub” on the other side of Kscope is all about. Or maybe you’re curious — “I know there’s a database under the covers and lots of developers; what do they do?” If you want to know about the underpinnings of your favorite Oracle software, this session is for you. We’ll talk about how it all fits together: database, SQL, PL/SQL, ADF, Forms, APEX, and more (without too many boring details)! Attending this session will improve your understanding of and ability to communicate with the “bit-twiddlers” in your organization.

Hyperion 101: An Introduction to the Oracle Enterprise Performance Management Suite

Andrew Jorgensen, MindStream Analytics

Have you been hearing all this talk about Oracle Hyperion? Are you wondering what exactly an Essbase is?

This is the session for those who are looking for an introduction into Business Intelligence and Enterprise Performance Management. We’ll start with the core business problems that are addressed with these products. The session will then include an overview of all the products that cover the Oracle Hyperion Suite and what each is best used for. We’ll finish this session covering a variety of reporting options including OBIEE.

Get more details here: ODTUG Kscope13: Expertise + Crossover.

If you have not yet signed up to attend KScope13, it’s not too late. Just get on over to the registration page and get in on the learning!

See you in New Orleans!

Kent

P.S. I will of course be there so be sure to look me up and attend one of my sessions.

 

Oracle Designer Lives!

Amazing as it seems, I picked this article up on Twitter today.

An up to date, current, and NEW article about automating builds of applications from the Oracle Designer repository.

How very agile…

Thanks to all the gang over at AMIS (http://technology.amis.nl/) for keeping the technology alive and for being innovative enough to adapt it for the modern agile development world.

Running Oracle Designer Generation from Ant and Hudson

Introduction

Oracle Designer is a windows client-server development tool that is meant to be manually operated by a developer. Anyone trying to integrate Designer with an automatic build environment will find that it does not provide an API or a commandline version to kick-off any generation automatically.

There is however a hook that can be exploited by generating so-called GBU files directly from the Designer Repository. These GBU files are then fed to an executable called dwzrun61.exe that executes the actual generation of DDL scripts and forms.

This article describes how this can be done using examples from a real world situation. It shows how to generate the GBU files, the different strategies that can be followed and some of the pitfalls you might run into trying to pull this off yourself.

The code of the program we wrote can be found on here and is free to be adjusted to fit any other situation than ours.

via Running Oracle Designer Generation from Ant and Hudson.

If you want to meet some of the guys from AMIS and pick their brains, be sure to sign up for KScope13 and come meet them live in person.

See you there.

Kent

Post Navigation

Follow

Get every new post delivered to your Inbox.

Join 384 other followers

%d bloggers like this: