Oracle Developer Tools and PlatformsBig data Tools and platforms, Oracle Developer tools (Forms, Reports, APEX)

Cliquer ici pour la version francaise

Recently, we had Mr Jean-Marc Spaggiari, principal Solutions Architect at Cloudera. Inc, present the cloudera Apache solution to our students at College de Bois de Boulogne. Here is a resumé of the session.

Title: The cloudera solution: A trip across the big data world

The main points presented by Jean-marc were related to the tools and ecosystem used within the cloudera solution.

Specifically, he presented the following points:

• Cloudera manager:administration, configuration, monitoring, sécurity, service deploiement
• Tools and software: mapreduce, Spark, Hbase, Impala, Hive, Pig
• Cloudera as a solution: how it is being used in North America and Québec
• Open discussion and Q/A

Seminaire bigdata BDEB

French version

Titre : Présentation de la solution Cloudera : un Voyage dans le monde du Big data.

Nom du conférencier: Mr Jean-Marc Spaggiari, principal Solutions Architect chez Cloudera. Inc

Introduction de la conférence et de son cadre : Dans le cadre de son cycle de séminaire en relation avec les mégadonnées, l’équipe de la FCSE du collège de Bois de Boulogne a invité Mr Spaggiari pour venir partager son expérience d’architecte principal de solutions Big Data avec Cloudera.

Thèmes abordés : les thèmes principaux qui ont été présentés sont en rapport avec les outils et écosystème du big data mais principalement les produits supportés par Cloudera. Read the rest of this entry »

From January 4th to Mid march 2016, I taught an introductory course in big data technology, platforms and tools, at Collège de Bois de Boulogne in Montréal, Canada.

For the most part, it was a hands-on course.

Students needed to know at least one programming language from the following: C, C++, Java, or Python, and some familiarity with basic statistics and SQL.

Because of the introductory nature of the course, I introduced the fundamental platforms, such as Hadoop, MapReduce v1 and v2, yarn, HDFS and some other tools, such as Pig and Hive. Afterwards, the course introduced cloudera manager as an administration tool. The students were required to install small-sized clusters using either cloudera manager, Ambari or vanilla install.

For the most part, the students definitely were able to carry out this task. Some sample installation reports are listed below:

TP – Mise en Place d’un cluster_hortonworks_CBH
TP1Cluster_reza_naidji_conteneur_LXC
Tp1_cloudera_mario_nadon

Students were also required to choose a topic of their own for a final project. The application domain was to be based on the students’ own interest. Overall, most students saw the final project as an opportunity  to apply what they learned in the class for their own needs, either for their future work requirements or for the upcoming courses in the big data specialization at College de Bois de Boulogne. Some of the projects are listed below:

Hadoop ProjetSession Charles Brisson, Mario Nadon et Yadong Wang
BD3ProjetSession_Yvon Cadieux_Angelo Fernandes
Présentation Éric TREMBLAY et Raoul_kouanda
PrésentationYacine BELHOUL, Abdellilah NAFIA et Cadrick NOUTCHA
Projet de Session Khedidja Seridi et salim Rahali
TP2_session Reda Louahala et Albert Zhu
presentation_Hadoop_nasser_amami_deneus

Overall, it was a challenging, yet a very satisfying course for most students.

In case a page is deleted in APEX, we can recover it using the export feature of APEX. The steps are as follows:

Open the application in application builder

Export application and then select the option -export page-. from there, the dropdown list shows only the pages that are in the application. You have to select the timeframe you need.

In order to select the deleted page, you have to tweak the HTML and this is where we use firebug to modify the list in order to add the option for the deleted page

Once it is done, the export will allow the export of the page

Returning to the import/export option of the application and from there select the file that was exported and import it. The page will be placed in the app.

For a full step by step explanation , see the original post by Peter raganitsch

With enterprise manager for Oracle 11g R2, it seems there are endless ways to have it stop working. One excellent article that I used to get enterprise manager work again is found on oracle-base website. Here is the link 

The downloads are no longer available through Sourceforge. I will be adding a download page on degenio.com for all of the available documents including Frite and other tools.

In the meantime, you can send me an email and I will forward the tools you need. Please be advised that gmail accounts do not accept zip attachments.

Update september 2013: I have uploaded the different tools in the downloads page.  Please leave a comment if you find the tools useful.

Thanks

This month of May 2013, we had the pleasure of receiving the well known Oracle Expert Mr Tom Kyte here in Montreal. The presentation lasted almost two hours with the main emphasis on the upcoming Oracle 12c database. Most notably, Mr Kyte described the various new features including those for PL-SQL.

However, the most striking new feature is the change in the Oracle architecture. From now on, there is one instance that controls a number of databases. Better get used to the Catalog and container concepts.

On a personal level, I was lucky to receive two tickets to the upcoming soccer game between the Montreal Impact and the Houston team (MLS). As a bonus, here is my picture with Mr Kyte and the Oragec president. What a day …

Oragec Montreal Prestige 2013. Hafed Benteftifa with Tom kyte

Yesterday, I  gave an impromptu talk about migrating from Oracle Forms to APEX. The aim was to highlight the different options or paths to follow when deciding about a migration strategy. I also touched upon migrating from Excel/Access to Forms. Here are the screenshots from that presentation. A translation of  each one is given below the screen capture.

Screen 1

Introduction migration to APEX

Read the rest of this entry »

The team in charge of APEX at Oracle has just released the early adopter version 4.2. Of the main striking features is the package applications option. Préviously, those applications were available on Oracle OTN and then were later removed.

Now, you can access them from the application dashboard as shown in the screenshot below.

Oracle Apex 4.2 packaged applications

The list of all the enhancements to the new version can be found here: http://apex.oracle.com/pls/apex/f?p=38997:1:9960399329701::::P1_FEATURE:Application%20Builder%20Enhancements

Yesterday, there were a number of presentations on the new Oracle APEX 4.1 version.

The presentation by David Peake, APEX product manager from Oracle, highlighted the new features available in 4.1. Read the rest of this entry »

Today, I  finished the spring session teaching Oracle APEX to 2 groups of students. The majority had prior experience with Oracle Forms with some having more than 7 years experience developing Forms application.

Most had a desire to explore APEX as a tool since they read a lot about it but were unsure whether they could transition smoothly to developing APEX web applications.

Read the rest of this entry »