schema_version: 2
default_locale: en
title: "[gHacks] Real-time Analytics with Change Data Capture (CDC)"
description: "This hack will take you through replicating and processing operational data from 
  an Oracle database into Google Cloud in real time using Change Data Capture (CDC)"
instruction:
  type: md
  uri: instructions/en.md
duration: 420
max_duration: 420
credits: 0
level: fundamental
tags:
- caugusto
- meken
- ghacks
- ghacks003
product_tags: 
role_tags:
- data engineer
- data analyst
domain_tags:
- data
environment:
  resources:
  - type: gcp_project
    id: project
    startup_script:
      type: qwiklabs
      path: artifacts
  - type: gcp_user
    id: user_1
    permissions:
    - project: project
      roles:
      - roles/owner
  - type: gcp_user
    id: user_2
    permissions:
    - project: project
      roles:
      - roles/owner
  - type: gcp_user
    id: user_3
    permissions:
    - project: project
      roles:
      - roles/owner
  - type: gcp_user
    id: user_4
    permissions:
    - project: project
      roles:
      - roles/owner
  - type: gcp_user
    id: user_5
    permissions:
    - project: project
      roles:
      - roles/owner
  student_visible_outputs:
  - label: Open Console
    reference: project.console_url
  - label: Project ID
    reference: project.project_id
  - label: Oracle Host IP Address
    reference: project.startup_script.orcl_db_ip
  - label: Oracle SID
    reference: project.startup_script.orcl_db_sid
  - label: Oracle Datastream User
    reference: project.startup_script.orcl_datastream_usr
  - label: Oracle Datastream Password
    reference: project.startup_script.orcl_datastream_pwd    
  - label: Username 1
    reference: user_1.username
  - label: Password 1
    reference: user_1.password
  - label: Username 2
    reference: user_2.username
  - label: Password 2
    reference: user_2.password
  - label: Username 3
    reference: user_3.username
  - label: Password 3
    reference: user_3.password
  - label: Username 4
    reference: user_4.username
  - label: Password 4
    reference: user_4.password
  - label: Username 5
    reference: user_5.username
  - label: Password 5
    reference: user_5.password
