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...)

clckwrk Quick Guide: Backing up Oracle databases on AWS using snapshots

Did you take a backup first? Of course you did.

In this post we look at one way to simply back up your Oracle database in the AWS cloud. We're planning on making this the first in a series of Quick Guides for working with Oracle and public cloud. We hope you like it, please follow, comment or like if we're hitting the spot!


This example uses a self managed database, rather than RDS, so (more...)

Protecting your data in Oracle – now you see it, now you don’t!

In this article Peter Berry from clckwrk shows how smart use of Oracle and AWS functionality can secure sensitive data in production and and automatically obfuscate when that data leaves the server.

Data security is a key concern for all businesses. Ensuring your data is secure in your production system and that data leakage is controlled is typically addressed by encryption and obfuscation respectively. Encryption can be difficult to deploy and costly while obfuscation can (more...)

Getting connected to the AWS Cloud

One thing that comes up in every clckwrk engagement is the issue of getting connected to the cloud. It’s a common issue so worth lining up the options and seeing which is going to work for you. We’ve listed below the 3 most common  paths for connecting your office or data centre to the AWS cloud and the pro’s and con’s of each. 

Internet - the simplest and by far the most common way (more...)