Archive for Oracle

DEVEPM will be at Kscope18!

Posted in ACE, DEVEPM, Essbase, Kscope 18, ODI, ODTUG with tags , on March 14, 2018 by radk00

Hi all, how are you doing? With some delay (same as last year, I was on vacation 🙂 ) we are very happy to announce that DEVEPM will be once again at KScope! We are very honored to be selected to present on the best EPM conference in the word! We got two presentations in, so here is what we are going present at Kscope18:

Dynamic Metadata Integrations for Multiple ASO Applications

Metadata management is a challenge on complex environments, since it is always changing over time. If the metadata process is not build in a robust and dynamic way, we will end up having a lot of rework every time that the business changes.

One of the best ways to maintain metadata on ASO cubes is using ODI, which gives us great flexibility to create real complex enterprise ETL processes. But if we use ODI in its standard way, we will end up having multiple similar ODI objects, since each ASO application/dimension is tied to a particular ODI data store. In other words, the higher the number of ASO applications we have, the higher is the number of ODI objects, increasing the possible failure points and code rework if something changes, which will make us lose a lot of time, money and trust on those systems.

This study case describes how to implement a smart EPM environment that uses Oracle Data Integrator with Oracle Essbase and take full advantage of its potential. This session will show how to create dynamic processes that changes automatically for any number of Essbase applications, allowing metadata maintenance that meets the business needs with low development costs.

Incredible ODI tips to work with Hyperion tools that you ever wanted to know

ODI is an incredible and flexible development tool that goes beyond simple data integration. But most of its development power comes from outside the box ideas.

  • Did you ever wanted to dynamically run any number of “OS” commands using a single ODI component?
  • Did you ever wanted to have only one datastore and loop different sources without the need of different ODI contexts?
  • Did you ever wanted to have only one interface and loop any number of ODI Objects with a lot of control?
  • Did you ever need to have a “Third Command Tab” in your procedures or KMs to improve ODI powers?
  • Did you still use an old version of ODI and miss a way to know the values of the Variables in a scenario execution?
  • Did you know that ODI has 4 “Substitution Tags”? And do you know how useful they are?
  • Do you use “Dynamic Variables” and know how powerful they can be?
  • Do you know how to have control over you ODI priority jobs automatically? (Stop, Start and Restart scenarios)

If you want to know the answer of all this questions please join us in this session to learn the special secrets of ODI that will take your development skills to the next level.

ys2header

Kscope is the largest EPM conference in the world and it will be held in Orlando on June 2018. It will feature more than 300 technical sessions, five symposiums, deep dive sessions, and hands on labs over the course of five days.

Got interested? If you register by March 29th you’ll take advantage of the Kscope early bird rates. Don’t waste more time and let’s be part of the greatest EPM event in the world. If you are still unsure about it, read our post about how Kscope/ODTUG changed our lives! Kscope is indeed a life changer event!

 

Advertisements

All about Meetups!

Posted in ACE, MeetUp, ODTUG, Oracle, Uncategorized with tags , , on January 23, 2018 by RZGiampaoli

Hey guys how are you doing? It has been a long long LONG time since our last post…. and we are sorry for that. We having been very busy with a lot of projects (both work and personal) and we had to get some time for us!

But we are finally getting back to action! And I’ll do that posting something about one thing that everybody loves…. Meetups..

First of all I would like to talk about the next ODTUG meetup that will happens in 2 days in Orlando, inside the Walt Disney World Dolphin Resort…. I think I don’t need to say anything else about it other that it’ll be awesome…. but anyway, here’s the link for you guys to attend:

All Community Social Meetup with the ODTUG Board of Directors

Thursday, Jan 25, 2018, 5:30 PM

Walt Disney World Dolphin Resort- Phins Lounge (Lobby Bar)
1500 Epcot Resorts Blvd Orlando, fl

8 ODTUGers Attending

Join us on Thursday, January 25, 2018, at 5:30 p.m. for an ODTUG social Meetup in the Phins Lounge at the Walt Disney World Dolphin Resort. Come enjoy a drink with the ODTUG Board of Directors and mingle with fellow ODTUGers! Date: Thursday, January 25, 2018, at 5:30 – 7:00 p.m. Location: Walt Disney World Dolphin Resort – Phins Lounge (lobby bar) …

Check out this Meetup →

Now that this is sort out, do you know that if you want to do your own Meetup you can do it together with ODTUG? And you can even get financial support to do it????

Well it’s true. You just need to plan your meet up and then fill out the Meetup Planning form. This will provide ODTUG with all the information they need in order to move forward.

It’s also helpful to provide them if you are seeking financial support and if so, how much, and also your estimated attendee count as well. Another advantage is that there’s an list of services that ODTUG will provide as a sponsor along with the qualifications for sponsorship.

  • Promotion for your local Meetup:
    • ODTUG will post your event on the ODTUG Meetup page.
    • Email Campaigns: ODTUG will invite members to your event
    • Social Media: ODTUG will promote your event on Twitter, Facebook, and LinkedIn
    • ODTUG will publish the success of your meeting in your community’s quarterly newsletter
  • Source an Oracle speaker if needed
  • Ship ODTUG swag for you to distribute at your event.

Off coarse there’re a few Sponsorship Requirements: Communicate ODTUG Resources and Events:

  • Educational resources

o   Provide an overview ODTUG’s memberships and benefits

o   Provide ODTUG Kscope18 deadlines

  • Early bird rate deadline – March 29, 2018

If you get exited with this piece of information and want to do you own Meetup, here are some useful tips and strategies for planning a Community Meetup.

 1- Choose a Date and Location

Be mindful of holidays and tech conference dates when planning a meetup. A free venue is best—workplaces and universities tend to be free, while private rooms at restaurants and hotels usually have a rental fee.  When securing a space, be sure to ask what the room capacity is and monitor your RSVP’s accordingly. If you need assistance with securing a venue please be sure to fill out the Meetup Planning form.

 2- Schedule Speaker(s)

Education and content should be a part of a Meetup. Even if presentations are brief, education helps to engage members. If you need assistance with securing presenters, please be sure to fill out the Meetup Planning form.

 3- Include Time for Networking with Food and/or Drinks

This could be as simple as having pizza delivered to an office after a speaker presentation. If there is a nearby bar/ restaurant the group may want to go for a Happy Hour.

 4- Promote ODTUG Membership and ODTUG Kscope18 Conference

Share the benefits of ODTUG membership, encourage others to volunteer with the community, and promote ODTUG Kscope18.

 Tips for a successful Meetup:

 Scheduling

o   Schedule quarterly Meetups if possible. Five-week months result in higher attendance and commitment. (Customers have an extra week to plan for maintenance, testing, and some downtime.)

o   Wednesdays and Thursdays are the best days for scheduling meetings; whereas Fridays you will be competing with families and/or social lives.

 Location is important

o   Provide an environment that is fun and inviting. Seek popular local bars or restaurants that provide private rooms for formal meetings.

 Budget

o   Everything is negotiable! Find creative ways for customizing menus for your meetings. Order appetizers for a small group or buffets for larger group.

o   The best option for savings is scheduling meetings in the workplace if possible.

 Greeting your guests

o   Have someone available to greet your guests. Provide a sign-up sheet, name tags, and pass out ODTUG/Kscope18 swag.

 Engaging your guests is KEY!

o   Creative ice breaker activity is a great way for people to engage and find common ground.

 Follow-up is vital for success

o   Feedback is important – this gives you an opportunity to thank your guests and provide a questionnaire (limited to 10 questions or less) to help improve and plan future Meetups.

 Non-solicitation

o   The user community is interested in learning how other organizations are leveraging the tools today within their environment, not a sales pitch. Solicitation is not allowed.

 

I hope you guys enjoy all this info and let’s start to plan our meetups 🙂

“Where to Start? ETL Developer Career” ODTUG Webinar

Posted in Career, ETL, ODI, ODTUG, Oracle, Webinar with tags , , , , , on March 30, 2016 by radk00

Hi everyone!

Today’s post is an invitation for the ODUTG Webinar “Where to start? ETL Developer Career” that will be presented by me on Tuesday, April 19, 2016 12:00 PM – 1:00 PM EDT. This webinar is the first one of a series of career webinars that ODTUG will be providing in its new Career Track Community that will be released very soon. I cannot give you too much details about this new community yet, but I may say that it will be aimed to provide career content for those young professionals that were just graduated or those that wants to give a shift in their career but they are not sure on how to star on them.

Here is the webinar description:

Are you a young professional who just got out of college and unsure which career path to follow? Are you are thinking about changing your career to something completely new and looking for options? Either way, this webinar is the right one for you. It’s the first in a series that the new ODTUG Career Track Community will bring you to show what Oracle careers look like and where/how to start with them.

During this webinar, we will talk about what an ETL developer career looks like, what the expectations are, challenges, rewards, and which steps are needed to be successful. We will discuss a wide range of topics, such as tools used on the job, certification paths, the importance of social media, user groups, and more. This webinar will be presented by Rodrigo Radtke de Souza, who has been working in the Oracle ETL world for quite some time now and has achieved great accomplishments as an ETL developer, such as Oracle ACE nomination, frequent Kscope speaker, ODTUG Leadership Program participant, and a successful career at Dell.

Here is the link to register to the webinar:

“Where to Start? ETL Developer Career” ODTUG Webinar

Also, ODTUG has several great webinars that are completely free for you. Take a look on the link below! If for some reason you are unable to attend the webinars at the specified date/time, you may become and ODTUG member which will grant you access to all previous recorded webinars, plus all Kscope presentation, technical journals, discount on Kscope and SP conferences and much more. If you are unsure if it is worthy or not to become an ODTUG member, read our post on how ODTUG changed our lives.

ODTUG webinars page

That’s it folks! See you next time!

Oracle ACE Program Level up!

Posted in ACE, EPM, Oracle, Uncategorized with tags , , , on December 4, 2015 by RZGiampaoli

Hi guys how are you doing?

I know we are not writing anything for a long now and I’m here just to give you two good news (and one is the reason I’m not writing anything until now :))

First of all I just received the information that Oracle level up me to ACE :).

O_ACELogo_clr

That’s means, I’m the first and the only oracle ACE in the BI track in the entire Brazil 🙂

I’m so happy and glad to receive this title that is difficult to express in words, but I need to thanks you guys for support and incentive.

The other good news (and this one explain my absence). I just got married :), and I need to say, it was a great party 🙂

I’ll publish some pictures just to show how much fun we have 🙂

EeR_0921

The wedding was in Nova Petrópolis, a German city in the mountains. Beautiful place with awesome food 🙂

EeR_1048

And because I’m not a conventional guy 🙂 (No body in IT is right?) I had to do my wedding a little bit different 🙂 and I must say, it was worthy :). I think it was the best wedding I ever went 🙂 (by the way, in Brazil the wedding start 4 pm and goes until 5 am).

EeR_0974

This is my pet 🙂 a maine coon kitty, my wife Erika and my axe 🙂

EeR_1631and here is how the party ends 🙂

Don’t you guys think Rodrigo looks like someone else?

Caverna-do-Dragão-Vingador

A lot of fun.

Now talking about work, we are working in some new stuff, and very soon we’ll have some cool thing posted here then…

See you soon and thanks.

ODI needs your help: Petition for EPM KMs support

Posted in EPM, ODI, ODI 12c, Oracle, Petition with tags , , , , on October 27, 2014 by radk00

Hi all,

Today’s post is a request for all of our readers. As you know, ODI 12c does not support EPM KMs. Although it seems that Oracle has announced that they will support the Hyperion Essbase KMs sometime in the future, no such acknowledgement has been made for the Hyperion Planning and Hyperion Financial Management Knowledge modules and it all indicates that this functionality will migrate to FDMEE application. This has created a lot of noise in the EPM community, especially in big clients that have invested a large amount of time and money to build ODI ETL processes around their EPM applications.

Having this in mind, Chris Rothermel (thank you so much Chris for all your effort on this, the ODI/EPM community really appreciate this!) has created an online petition requesting Oracle to rethink its strategy and add the EPM KMs support in ODI 12c.

DEVEPM supports this petition and asks you all to sign it!

Link for the petition site here: Change.org

Some of you may think that signing this petition is going to make you go “against Oracle” in some way but that’s totally the opposite. The ODI/EPM community is raising this petition just because we love ODI and all Oracles’ EPM tools and we really want to see them shine! We live and breathe ODI/EPM every single day and we may tell you for sure that ODI is the best ETL tool in the market today and should bring all technologies under its wings. See what the ODI team is doing for Golden Gate/Big Data integrations…. It’s just amazing! We just want the same for all EPM tools!

Is this petition going to have any effect on Oracles’ thought? I don’t know, but they need to know at least that there is an ODI/EPM community out there that cares about it and that will be left alone if they decide to abandon the EPM KMs support. Another suggestion for Oracle is to make the EPM KMs open source at least, so the EPM community would modify/upgrade them as needed when a new version of EPM tools hits the market. DEVEPM even offers to be a major contributor to these changes if they go open source 🙂

Thanks guys, we are counting on you to make this petition work!

See ya!

Edited on 01/15/2015 ——————————————————————————————

Victory!!!!! It seems that Oracle has heard the community!!! Take a look on what Chris has added to the petition site:

“12 de jan de 2015 — Hooray! The Hyperion Planning Knowledge Modules will likely be supported in ODI 12c. That means both Essbase and Planning will be supported in the next release of ODI. That’s a change for the better. No official word on this yet. The HFM Knowledge Modules have a different story for ODI version 12C. Since the HFM API in version 11.1.2.4 will be Java there is a big architecture change and the ODI KMs for HFM will not be available or supported by Oracle for the next release.

Also note that Planning has a new set of API’s with 11.1.2.4 so look for improvements in both Planning and ODI.”

Thanks for all those that contributed somehow to this cause! Lets wait for the official Oracle announcement!