Using Ansible to configure an Oracle Linux 7.1 server with Oracle 12c R1 Enterprise Edition Database

Chris VezalisAnsible, DEVOPS, Linux, Oracle Database, Oracle Linux, Vagrant

Ansible is the leading tool for configuring software and various parameters on servers. It does not require agents and other software installed on nodes like other popular tools (puppet or chef). Also, it is modular and already has hundreds of modules that help us configure our servers in several ways. In this article I will demonstrate how we can install …

Installing RStudio & additional R packages in Oracle Big Data Lite VM 4.2.1

Christos - Iraklis TsatsoulisR Leave a Comment

I was very happy to find out that, in the latest version (4.2.1) of Oracle Big Data Lite VM, all the R-related issues I had located and reported in the past (see here and here) have been resolved. Nevertheless, some new issues have emerged. Below are my findings and workarounds (if you are in a hurry, feel free to jump …

Athens Datathon 2015: exploratory data analysis for anomaly detection & data quality

Christos - Iraklis TsatsoulisData Science, Exploratory Data Analysis, R 8 Comments

Together with my friend and former colleague Georgios Kaiafas, we formed a team to participate to the Athens Datathon 2015, organized by ThinkBiz on October 3; the datathon took place at the premises of Skroutz.gr, which was also the major sponsor and the data provider. It was the second such event organized in Athens, and you can see the Datathon …

Big Data Discovery configuration in Oracle Big Data Lite VM 4.2.1

Christos - Iraklis TsatsoulisBig Data, Oracle Big Data Discovery 1 Comment

The latest version (4.2.1) of Oracle Big Data Lite VM, among many additions, now includes also the much-expected Oracle Big Data Discovery (v. 1.1), which I had not played with so far (it is a new product); so I thought to take it for a ride. Since my test data included geolocation attributes (latitude/longitude), one of the first things I …

Ansible playbook to provision a WebLogic Fusion Middleware Domain on RHEL 7

Chris VezalisAnsible, DEVOPS, Fusion Middleware, WebLogic

An Ansible Playbook for installing and configuring a WebLogic 12c server with Oracle Fusion Middleware 12.1.3 software in Redhat Linux 7 (RHEL/CentOS/Oracle Linux) system. This playbook is for version 12.1.3 of WebLogic and Fusion Middleware Infrastructure software. You can download the code here: https://github.com/cvezalis/weblogic-ansible Prerequisites for running the playbook – Configure your environment variables in infra-vars.yml. This file contains variables …

Dataframes from CSV files in Spark 1.5: automatic schema extraction, neat summary statistics, & elementary data exploration

Christos - Iraklis TsatsoulisBig Data, Spark 25 Comments

In a previous post, we glimpsed briefly at creating and manipulating Spark dataframes from CSV files. In the couple of months since, Spark has already gone from version 1.3.0 to 1.5, with more than 100 built-in functions introduced in Spark 1.5 alone; so, we thought it is a good time for revisiting the subject, this time also utilizing the external …

Reusing ADF Business Components to develop web services

Michael KoniotakisDEVOPS, Oracle ADF Leave a Comment

There are already numerous ADF applications that have been developed these latest years, mostly using Business Components in the model layer. With the increased need of SOA processes and mobile applications based on web services, there is a big and growing need of exposing the same functionality via web services. According to the documentation  “the same application module can support …

Dynamic Dashboard

Konstantinos ChatzisOracle ADF Leave a Comment

While I was checking the new Oracle Alta UI Demo (http://jdevadf.oracle.com/workbetter/faces/index.jsf) I noticed a dashboard view with all employees. The panelDashboard component of the Oracle Application Development Framework (Oracle ADF) Faces feature is a JavaServer Faces (JSF) layout container that Oracle ADF developers can use to implement such information dashboards. I decided to use it in a project that we …

Maven replace tokens inside files before application build using profiles

Chris VezalisDEVOPS, Maven, Oracle ADF

When building projects on multiple environments (for example a developer test server, a system test server, a user acceptance test server, a training server and finally a production server), application need to be passed environment variables. One way to solve this is to use tokens on files that Maven will replace will real values found on separate property files for …

Creating Data Models in ODI 12c with Common Format Designer (CFD)

Gabriel SiderasData Integration Leave a Comment

In this post I will try to outline the capabilities of the Common Format Designer (CFD) which can be used in Creating Data Models in ODI 12c. CFD can be used to quickly design a data model, forward engineer a database schema and generate a default data flow between data models. Oracle Data Integrator (ODI) is Oracle’s flagship product on data integration. In 12c a …