Are you planning to launch a cloud analytic database for a data warehouse or other analytic need? While the cloud offers simplicity and quick provisioning, it also offers a path to sure failure if the model is misused.
The cloud analytic database needs to be built to give users and applications access to high-performing, high-quality, supported and understandable data, and it needs to built as agile.
This agile need means producing an MVP (minimally viable product) in the Proof of Concept (POC), with the ability to expand from there.
Consider the steps to truly provision AWS Redshift for even a POC:
- Create and Launch EC2 Instance
– Choose your Amazon Machine Instance
– Choose your Instance Type
– Add Storage
– Configure Security Group
– PEM Key Pair
– Connect/SSH to Instance
– Access keys
- Set up S3 Storage
– Create bucket
- Set up Redshift
– Identity & Access Management
– Create Role and Attach Policies
– Configure Cluster
– Launch Cluster
- Load Data
- Query Data
- Create Statistics
- Manual & Automatic Snapshots
- Distribution Keys
- Elastic Resize
- Vacuum Tables
- Cluster Parameter Group (for Workload Management)
- Short Query Acceleration
We have built proofs-of-concept as part of many of the Information Management Action Plan (IMAP) and Data Warehouse implementation clients we have delivered for over the years.
Get help from the experts who have worked on the data challenges of 15 of the Fortune 1000 and numerous others; the highly published in-demand keynote speakers and analysts in the space who run the benchmarks and author the industry analysis. Your experts will be career-long data professionals who have done this 50-100 times or more.
Get help from the firm who gives the hands-on training, including to the vendors in the industry on their competition.
DATABASES WE HAVE WORKED ON INCLUDE:
- Actian Avalanche
- AWS Redshift
- Azure Synapse
- DB2 Warehouse on Cloud/DB2
- Google BigQuery
- Microfocus Vertica
- Oracle Autonomous Database/Oracle
- SAP HANA Cloud Platform
We have a methodological approach to build the POC which tremendously speeds up the value provided.
In our POC, we will work with you to define the MVP, build the MVP and empower you with next steps – technical and organizational – for continued quick and frequent iteration to increasing cloud analytic database, and business, success.