Transactional data captured by NonStop applications can be a key source for business analytics; however, the NonStop platform may not be ideal for storing and analyzing the information over a long period of time. Developing and hosting an in-house data analytics solution can be a challenging – and expensive – option. An attractive alternative is AWS which provides all the cloud-based services needed to easily extend a NonStop application with a scalable, flexible and cost-effective infrastructure. But how do you get the information from the NonStop to AWS and which AWS services do you use and how do you use them?
The diagram below shows just one possible approach for integrating data from the NonStop platform with AWS.
The AWS services in the above diagram can be split into 3 categories – Collection, Storage and Analyze.
Collection Services
AWS’ Direct Connect service can be used to connect NonStop application data to AWS.
Storage Services
AWS provides several storage services. The example above uses AWS’ Simple Storage Service (S3) to hold data in its raw form – thus providing an excellent data lake implementation. A concern with data lake implementations is that they can often turn into “data swamps.” This is a term used to describe a situation where the data stored cannot be easily queried or used and can happen when data is simply stored into a data lake without any information about it’s context (date, source, identifiers, etc.). AWS’ data lake solution addresses this by storing data in packages and tagging each package with metadata. You can define the metadata you need for your packages to keep them organized. AWS’ Elasticsearch and DynamoDB are used for storing and retrieving these packages. Redshift is a data warehouse service where data can be stored for sophisticated querying and analysis. Data can be loaded from the data lake into one or more data warehouses. Lambda is AWS’ serverless function environment. It can be used to develop event-driven code for receiving data from the NonStop and loading it to S3 and storing metadata in DynamoDB.
Analyze Services
AWS provides many analysis services. In the above example, AWS Quicksite is used. Integrating AWS with NonStop can provide a scalable, flexible and cost-effective platform for big data analytics