RMOUG Training Days 2018

So Training Days is coming up in two weeks.  You haven’t registered to attend?  How you feeling about that?

Rocky Mountain Oracle User Group, (RMOUG) has the largest Oracle user group grassroots conference each February.  For the 2018 year, we decided to shake it up with:

  • A new venue, The Westminster Westin Conference Center
  • A new management company, EPS Conference Management
  • A new Training Days Director, Komal Goyal
  • A new management software, (more...)

Migrating Function based indexes from Oracle to PostgreSQL

In this post, I will share  challenges with function based index in PostgreSQL . I was performing database migration from Oracle to PostgreSQL and used AWS Schema Conversion Tool(SCT) for converting the database schema.AWS Schema conversion tool takes care of automatically converting schema from one database engine to other. You can get more information about…

Message Push Listener – Article Update

When I first wrote about Oracle Messaging Cloud we used a service called WebScript.io to make it easy to demonstrate the Message Push Listener. WebScript was essentially what we better know as a Serverless or Functions oriented offering (that is we wrote pieces of code and deployed them without any consideration servers etc). Well as I prepared my demos for Messaging Cloud for the UK Oracle User Group Tech 17 Conference I discovered that (more...)

Query Flat Files in S3 with Amazon Athena

Amazon Athena enables you to access data present in flat files stored in S3 (Simple Storage Service) as if it were in a table in the database. That and you don't have to set up any server or any other software to accomplish that.

That's another glowing example of being 'Serverless.'


So if a telecommunication has hundreds of thousands or more call detail record file in CSV or Apache Parquet or any other (more...)

List of Networking Concepts to Pass AWS Cloud Architect Associate Exam

Networking is a pivotal concept in cloud computing. Knowing it is a must to be a successful Cloud Architect. Of course you won't be physically peeling the cables to put RJ45 connectors on but you must know various facets of logical networking.


You never know what exactly gonna be in the exam but that's what exams are all about. In order to prepare for AWS Cloud Architect Associate exam you must thoroughly read and understand (more...)

Connecting to your AWS Instance with SSH

If you're using our AMIs from the Amazon Marketplace you might need some guidance on connecting using ssh. We've put together the steps below as a guide to help.

How to SSH using Mac/Linux

1. In (more...)

clckwrk Design Blueprint: Oracle e-Business Suite on AWS

Moving to the Cloud Made Simple: A Framework for Oracle e-Business Suite in AWS 

We wouldn’t blame you if you’re not 100% ready to jump into the Cloud, just because that’s what everyone else seems to be doing. Making the right decision for your business means taking a careful look at what exactly the benefits are going to be. How will your systems work in the Cloud? Can Cloud providers like AWS actually meet your (more...)

Navigating the Oracle Licensing Policy Update: A Look at the Facts

If you’re like us, then you’re never far from the pulse when it comes to changes in software licensing. Keeping up to date with this is a safe way to be sure that you’re making the best decisions for your business when it comes to saving costs and operating efficiently. 

The change that we all seem to be struggling to digest is Oracle’s January 2017 update to its online policy document, “Licensing Oracle Software (more...)

Sharing your Files Securely – A How-to Guide for AWS S3


Whatever your industry, this is sure to be something you’ve come across before. You need to share a file with an external business – it might be a client, a partner or an agency. In the old days, we’d just fire it across as an email attachment. But more businesses working together closely means large volumes of confidential information being shared more frequently. 

It’s something that comes up for us pretty regularly. The files (more...)

Enterprise Workloads – what can the cloud do for me?

What exactly can the Cloud do for me? 

We wouldn’t blame you if you’re bored of hearing it: if it’s in the cloud, it must be better. But…why is it better? Before you go ahead with a decision like this one, you’ll want to look at specific, concrete examples of the practical benefits of cloud-based hosting. A solution that matches the needs of one business isn’t guaranteed to be the perfect match for another. (more...)

Moving your Oracle Data to the Cloud with Minimal Downtime


Moving from an on-premise Oracle database to the Cloud can mean a whole host of different challenges, and these are different for every business. One of the things we’ve tackled for larger companies is the problem of migrating a lot of data, with not much time to play with. Big businesses come with big sets of data, and often don’t have time to spare for a lengthy window of downtime. Systems down means money spent, (more...)

AWS Solutions Architect – Associate Certification

Hi All,

I am glad to announce that I have completed AWS Solutions Architect – Associate Level certification

screen-shot-2017-01-16-at-3-36-11-pm

This is a completely new world with lots of opportunities to learn new things.

Below is the list of things that I used for doing the certification. This will be helpful for anyone who is aspiring for AWS solutions architect associate certification.

  • Thanks to acloud.guru for providing complete course material for this certification. It was really helpful. Using this course (more...)

Building Classrooms in the Cloud

Jumpbox Lab Server

Let’s face it: education without interaction is about as effective as shouting origami instructions at a lumberjack who is cutting down trees. Sure, your informative lessons will come in handy when the product of their work finally becomes paper, but it will be long forgotten and ultimately worthless by then. The only way a student is going to learn is if they can put (more...)

NFRs are easy – what about your NFO’s?

You're used to working on your Non-Functional Requirements (NFR's) - we're used to worrying about how secure our systems are, how many users they will support, how resilient they are to the failure of a component. What we're not used to thinking about are Non-Functional Opportunities - (NFO's) what are the unforeseen benefits that the business will find when they use IT?

The cloud blows the non-functional requirement (NFR) out of the water. You want (more...)

G-Cloud – Moving Your Oracle System to Amazon Web Services

G-Cloud was awarded a few weeks ago and we're glad to say that clckwrk were selected as a supplier in the areas of Infrastructure as a Service and Specialist Services.

The services we have on G-Cloud are specifically curated for implementing, moving and managing Oracle systems to the cloud. This is a quick guide for how to combine those services to migrate to the cloud. For public sector users of Oracle technology and applications this is the set (more...)

clckwrk Design Blueprint: Peoplesoft Campus Solutions on AWS

Higher eduction establishments around the world use Peoplesoft Campus Solutions from Oracle to manage their key business processes. 

In this reference architecture we look at the key requirements for Campus Solutions and the technical solutions that can be deployed on the Amazon Web Services Cloud. 




Availability: Campus solutions needs a high availability infrastructure to ensure that both the administrative and student users can access data at all times. This solution uses multiple web and (more...)

Its what we do at clckwrk…

At clckwrk we have a pretty simple way of looking at what we do:
  • Discovery: Finding out about your IT and your plans for the cloud; what you have, what works, what doesn't, where you want to get too
  • Design: Working on the way things should be; what things will look like in the end, what steps will get us there, making sure everything continues to work along the way
  • Build: Getting it (more...)

clckwrk Quick Guide: Oracle DBA – Managing the Alert Log on AWS

At clckwrk we managed Oracle on the AWS Cloud. First rule of being a DBA - check the alert log.

The database alert log is the file where the database logs core activity and any messages that the DBA needs to understand what the database is doing, any tuning that needs to happen at the database level and any errors that the database is producing. It's the errors that are critical for us as they (more...)

Slashing the costs of your databases … choosing your PaaS or Next Gen Database Platform

Do you want to lower the costs of your database estate? Are you trying to stay inside the license purchases you’ve made? Maybe looking to simplify the admin across servers, storage, networks and DBA?

It’s a question we get asked over and over in a world where there are great advantages in adopting the next generation of Platform as a Service (PaaS) and Next Generation database platforms. Seeing AWS park its tanks on Oracles lawn (more...)

Database Migration and Integration using AWS DMS



Amazon Web Services (AWS) recently released a product called AWS Data Migration Services (DMS) to migrate data between databases.

The experiment

I have used AWS DMS to try a migration from a source MySQL database to a target MySQL database, a homogeneous database migration.

The DMS service lets you use a resource in the middle Replication Instance - an automatically created EC2 instance - plus source and target Endpoints. Then you move data from the source (more...)