Unlock your PostgreSQL data with Red Hat JBoss Data Virtualization

And here we go for another episode of the series: “Unlock your [….] data with Red Hat JBoss Data Virtualization.” Through this blog series, we will look at how to connect Red Hat JBoss Data Virtualization (JDV) to different and heterogeneous data sources.

JDV is a lean, virtual data integration solution that unlocks trapped data and delivers it as easily consumable, unified, and actionable information. It makes data spread across physically diverse systems — such as multiple databases, XML files, and Hadoop systems — appear as a set of tables in a local database. By providing the following functionality, JDV enables agile data use:

  1. Connect: Access data from multiple, heterogeneous data sources.
  2. Compose: Easily combine and transform data into reusable, business-friendly virtual data models and views.
  3. Consume: Makes unified data easily consumable through open standards interfaces.

It hides complexities, like the true locations of data or the mechanisms required to access or merge it. Data becomes easier for developers and users to work with. This post will guide you step-by-step on how to connect JDV to a PostgreSQL database using Teiid Designer. We will connect to a PostgreSQL database using the PostgreSQL JDBC driver.

Continue reading “Unlock your PostgreSQL data with Red Hat JBoss Data Virtualization”


Join Red Hat Developers, a developer program for you to learn, share, and code faster – and get access to Red Hat software for your development.  The developer program and software are both free!

 

Red Hat JBoss Data Virtualization on OpenShift: Part 3 – Data federation

Welcome to part 3 of Red Hat JBoss Data Virtualization (JDV) running on OpenShift.

JDV is a lean, virtual data integration solution that unlocks trapped data and delivers it as easily consumable, unified, and actionable information. JDV makes data spread across physically diverse systems such as multiple databases, XML files, and Hadoop systems appear as a set of tables in a local database.

When deployed on OpenShift, JDV enables:

  1. Service enabling your data
  2. Bringing data from outside to inside the PaaS
  3. Breaking up monolithic data sources virtually for a microservices architecture

Together with the JDV for OpenShift image, we have made available several OpenShift templates that allow you to test and bootstrap JDV.

Continue reading “Red Hat JBoss Data Virtualization on OpenShift: Part 3 – Data federation”


Join Red Hat Developers, a developer program for you to learn, share, and code faster – and get access to Red Hat software for your development.  The developer program and software are both free!

 


For more information about Red Hat OpenShift and other related topics, visit: OpenShift, OpenShift Online.

Connecting to a Remote database from a JWS/Tomcat application on OpenShift

One of the common requirements for Java based applications on OpenShift is to have these workloads connect back out to an enterprise database that resides outside of the OpenShift infrastructure. While OpenShift natively supports a variety of relational databases (including Postgres and MySQL) as Docker based deployments within the platform, connecting to an existing enterprise database infrastructure is preferred in many large organizations for a variety of reasons including:

  • Inherent confidence in traditional databases due to in house experience around developing and managing these databases
  • Ability to leverage existing backup/recovery procedures around these databases
  • Technical limitations with these databases in being able to be deployed in a containerized model

One of the strengths of the OpenShift platform is its ability to accommodate these “traditional” workloads so that middleware operations can take advantage of the benefits/efficiencies gained from Dockeri’zed applications while giving development teams a platform to start designing/architecting applications that would fit into more of a Microservice based pattern that would leverage a datastore such as MongoDB or MySQL that OpenShift supports.

In addition to that, another common workflow in many organizations from a deployment point of view is to externalize the database connection information so that the application can be migrated from environment to environment (example Dev to QA to Prod) with the appropriate database connection information for the various environments. In addition, these teams typically work with the application binary (.war, .ear, .jar) deployment as the artifact thats promoted between environments as opposed to Docker based images.

In this article, I will walk through an example implementation for achieving this. A sensitive aspect of this migration process are the credentials to the database, where storing credentials in clear text is frowned upon. I will cover a variety of strategies in dealing with this in a follow on article. For this example, I will be using the following project which contains the source code that I will be covering in this article.

Lets get started!

Continue reading “Connecting to a Remote database from a JWS/Tomcat application on OpenShift”


Join Red Hat Developers, a developer program for you to learn, share, and code faster – and get access to Red Hat software for your development.  The developer program and software are both free!

 


For more information about Red Hat OpenShift and other related topics, visit: OpenShift, OpenShift Online.

Containerize your Ruby on Rails/PostgreSQL application with RHSCL Docker images

New RHSCL-based Docker images that are now in beta let you easily build your own application containers even without writing any Dockerfiles. Here is an example of a Ruby on Rails application built with the Ruby 2.2 image using the PostgreSQL 9.4 image as a database backend.

Continue reading “Containerize your Ruby on Rails/PostgreSQL application with RHSCL Docker images”


Join Red Hat Developers, a developer program for you to learn, share, and code faster – and get access to Red Hat software for your development.  The developer program and software are both free!

 

Database Docker images – now beta via Software Collections

“As a part of the Red Hat Software Collections offering, Red Hat provides a number of container images, which are based on the corresponding Software Collections. These include application, daemon, and database images. The provided images, currently available in the Beta version” (for more information see https://access.redhat.com/articles/1752723)

Red Hat Software Collections allows you to run newer versions of software on a stable Red Hat Enterprise Linux. These new images combine this feature with the benefits of containers.

In this post I would like to show you how to run database server from RHSCL in one command.

Continue reading “Database Docker images – now beta via Software Collections”


Join Red Hat Developers, a developer program for you to learn, share, and code faster – and get access to Red Hat software for your development.  The developer program and software are both free!

 

Red Hat Software Collections 2.0 Docker images, Beta release

I’m very happy to announce that Docker images based on collections from Red Hat Software Collections (RHSCL) 2.0 are in beta testing.  The images are available from the Red Hat Container Registry, and we’ve got the set of collections for language, databases and web servers covered – a complete list is below.

If you’ve not tried out the Docker package from RHEL7 Extras, you need to enable the Extras channel, install the docker page, and start the docker service; an extended guide for RHEL Docker is available here.  Once you are set up, pulling the RHSCL Docker images is very simple… for example, you can fetch the Python 3.4 image as follows:

Continue reading “Red Hat Software Collections 2.0 Docker images, Beta release”


Join Red Hat Developers, a developer program for you to learn, share, and code faster – and get access to Red Hat software for your development.  The developer program and software are both free!

 

Take advantage of your Red Hat Developers membership and download RHEL today at no cost.

Red Hat Software Collections 2 – now generally available

Excellent news – Red Hat has announced the general availability of Red Hat Software Collections 2.softwarecollections-logo-colorful

You’ll see considerable additions to support multiple language versions. For example, it includes updates to “Python 2.7, continues to support Python 3.3 and also adds Python 3.4 – providing a fully-supported language library and blending developer agility with production stability.”

Continue reading “Red Hat Software Collections 2 – now generally available”

Software Collections 2.0 now in BETA – new and shiny

softwarecollections-logo-colorfulIt seems like just a few months ago when we introduced Red Hat Software Collections 1.0 (RHSCL), followed by 1.1 and 1.2 will lots of additions and updates.

Today, Red Hat has announced Red Hat Software Collections 2.0 with a truck load of important languages, tools, databases and web servers – including the addition of a new component:  Passenger.  Here’s the list:

  • Python 3.4the latest stable, major release of Python 3 and includes a number of additional utilities and database connectors for MySQL
  • PHP 5.6 – featuring numerous improvements, additions and a streamlined upgrade path for migrating from past versions
  • Perl 5.20 – a recent stable release of Perl shipped with a set of additional utilities, scripts, and database connectors for MySQL and PostgreSQL
  • Ruby 2.2 – and, in its own collection, Rails 4.1 give users the ability to access and install an updated version of Ruby without necessarily having to install an updated version of Rails.
  • MySQL5.6 – inclusive of enhancements to InnoDB for higher transactional throughput, partitioning improvements for querying and managing huge tables, and better performance monitoring
  • MariaDB 10 – a recent stable release of this easy-to-adopt database alternative to MySQL
  • PostgreSQL 9.4 – featuring the new JSONB datatype, increased scalability with Logical Decoding, the foundation for new replication tools such as Bi-Directional Replication, and several additional enhancements that contribute to improved performance
  • MongoDB 2.6 – a high-performance, cross-platform document database features comprehensive core server enhancements, enhanced scalability and index intersection
  • NEW TO RHSCL: Passenger 4.0 – a modern web and application server for Ruby, Passenger 4.0 has been optimized for performance, memory usage and ease-of-use

Red Hat Software Collections 2.0 Beta also includes many updates and enhancements to existing collections, including:

  • Maven 3.0.5 – a recent stable release of the popular build automation tool for Java projects that describes how software is built and all associated dependencies
  • Python 2.7 – now includes python-wheel, python-pip, and all associated dependencies
  • Thermostat 1.2 – adds event-based profiling, an improved sampler profiler, Maven archetypes and visual improvements to the Swing client and charts
  • nginx 1.6 – a recent stable release of nginx, a high performance, open source HTTP sever and reverse proxy option
  • DevAssistant 0.9.3 – a useful tools for setting up development environments, publishing code and other related tasks, this latest, stable version includes several bug fixes and full backwards compatibility
  • Node.js 0.10.33 – previously only available through an unsupported tech preview, the latest stable release of this modern programming platform is now fully supported

All of the above are part of the majority of Red Hat Enterprise Linux subscriptions.

New to Software Collections?  Read about them on the product pages.

See the entire release here.

 

Repost: Deploying a PostgreSQL Pod in OpenShift V3 – w/ Docker

An interesting article as OpenShift v3 introduces Docker containers.

crunchydatasystemsAt Crunchy Data Solutions (Crunchy)we were excited to hear the recent announcement from the OpenShift team regarding the new public Origin repo integrating the work Red Hat has been doing for over twelve months in OpenShift Origin and related projects like Docker, Kubernetes, GearD and Project Atomic.

Continue reading “Repost: Deploying a PostgreSQL Pod in OpenShift V3 – w/ Docker”


Join Red Hat Developers, a developer program for you to learn, share, and code faster – and get access to Red Hat software for your development.  The developer program and software are both free!

 


For more information about Red Hat OpenShift and other related topics, visit: OpenShift, OpenShift Online.