Offloading Financial Mainframe Data into BigQuery and Elastic Search

In this hands-on lab, you will import synthetic data* representing financial records offloaded from a bank’s mainframe.

• GSP1153
• Overview
• Setup and requirements
• Task 1. Elastic - Set up trial account
• Task 2. Create a Cloud Storage Bucket
• Task 3. Create a BigQuery dataset and import data from Cloud Storage
• Task 4. Explore the mainframe data in BigQuery
• Task 5. Create a Dataflow job reading from BQ and pushing to Elastic
• Task 6. Explore the data in Elastic
• Task 7. Create a simple dashboard
• Congratulations!