دوراتنا

Serverless ETL استخدام OCI Data التكامل

حول هذه الدورة

تعلم simplify integration within the OCI eco-system with a graphical, no-code user interface that guides you through building the integration code.

يومان

9 Lectures

تم النسخ

دورة المحتوى

  • 1 Oracle Data Integration: Overview
  • Learning Objectives
  • Introduction to Data Integration Service
  • Data Integration Concepts
  • Data Integration Service: User Activities
  • Summary
  • Practice 1: Overview
  • 2 Preparing for Data Integration Connectivity
  • Learning Objectives
  • Introduction to Networking
  • Network Component Configurations
  • Component Configurations
  • Creating Resources
  • Creating Resources for Data Integration Activities
  • Creating Resources: Example
  • Policies for Data Integration Users
  • Policies for Data Integration Users: Example
  • Policies for Data Integration Access to Resources
  • Policies for Data Integration Access to Resources: Example
  • Summary
  • 3 Organizing Resources Using Workspace
  • Learning Objectives
  • Introduction to Workspace
  • Creating a Workspace
  • Creating a Workspace: Example
  • Accessing a Workspace
  • Accessing a Workspace: Example
  • Navigating a Workspace
  • Navigating a Workspace: Example
  • Editing a Workspace
  • Editing a Workspace: Example
  • Adding Tags to a Workspace
  • Viewing a Workspace's Tags
  • iii
  • Viewing a Workspace's Tags: Example
  • Moving Workspaces to a Different Compartment
  • Moving Workspaces to a Different Compartment: Example
  • Viewing a Workspace's Status
  • Viewing a Workspace's Status: Example
  • Stopping a Workspace
  • Stopping a Workspace: Example
  • Starting a Workspace
  • Terminating a Workspace
  • Terminating a Workspace: Example
  • Summary
  • Practice 3: Organizing Resources Using a Workspace
  • 4 Working with Data Assets and Projects
  • Learning Objectives
  • Introduction to Data Assets
  • Supported Data Sources for Data Assets
  • Creating a Data Asset
  • Creating an Oracle Database Data Asset
  • Creating an Oracle Object Storage Data Asset
  • Creating an Oracle Object Storage Data Asset: Example
  • Creating an Autonomous Data Warehouse Data Asset
  • Creating an ADW Data Asset
  • Creating an Autonomous Data Warehouse Data Asset: Example
  • Creating a Connection
  • Editing a Connection
  • Editing a Connection: Example
  • Data Asset Details
  • Data Asset Details: Example
  • Editing a Data Asset
  • Deleting a Data Asset
  • Project: Creating a Project
  • Project: Viewing Project Details
  • Project: Editing a Project
  • Project: Deleting a Project
  • Folders: Creating a Folder
  • Creating a Folder: Example
  • Folders: Viewing a Folder
  • Viewing a Folder: Example
  • Folders: Editing a Folder
  • Editing a Folder: Example
  • iv
  • Folders: Deleting a Folder
  • Summary
  • Practice 4: Working with Data Assets and Projects
  • 5 Working with Data Flow Designer
  • Learning Objectives
  • Data Flow: Introduction
  • Data Flow Designer: Introduction
  • Data Flow Designer: Toolbar
  • Data Flow Designer: Canvas
  • Data Flow Designer: Operators Panel
  • Data Flow Designer: Properties
  • Data Flow Designer: Properties – Example
  • Data Flow Designer: Validation Panel
  • Operators: Overview
  • Operators: Source Operator
  • Operators: Source Operator – Example
  • Operators: Target Operator
  • Target Operator: Selecting an Oracle Database target data entity
  • Target Operator: Selecting an Oracle Object Storage target data entity
  • Target Operator: Selecting an Autonomous Data Warehouse
  • Target Operator: Viewing Attributes
  • Target Operator: Mapping Attributes
  • Target Operator: Example
  • Operators: Filter Operator
  • Filter Operator: Arithmetic Functions
  • Filter Operator: Date/Time Functions
  • Filter Operator: Binary String
  • Filter Operator: String Functions
  • Filter Operator: Comparison Operators
  • Operators: Join Operator
  • Join Operator: Example
  • Operators: Expression Operator
  • Expression Operator: Example
  • Operators: Aggregate Operator
  • Aggregate Operator: Example
  • Creating a Data Flow: Introduction
  • Creating a Data Flow: Adding a Source Operator
  • Creating a Data Flow: Adding a Target Operator
  • Creating a Data Flow: Adding a Target Operator
  • Creating a Data Flow: Adding a Filter Operator
  • v
  • Creating a Data Flow: Adding a Join, Expression, Aggregator Operator
  • Connecting Operators, and Validating and Saving the Data Flow
  • Data Flow: Example
  • Editing a Data Flow
  • Moving a Data Flow
  • Deleting a Data Flow
  • Deleting a Data Flow: Example
  • Summary
  • Practice 5: Working with Data Flow Designer
  • 6 Using Interactive Data Xplorer
  • Learning Objectives
  • Introduction to Data Xplorer
  • Data Xplorer in Data Flow
  • Data Xplorer in Data Flow: Example
  • Data Xplorer in Data Loader
  • Data Xplorer in Data Loader: Example
  • Introduction to Transformations
  • Types of Transformations
  • Transformations: Exclude
  • Transformations: Rename
  • Transformations: Change Case
  • Transformations: Merge Attributes
  • Transformations: Replace
  • Transformations: Extract
  • Transformations: Null Fill Up
  • Transformations: Example
  • Summary
  • Practice 6: Using Interactive Data Xplorer
  • 7 Working with Parameters
  • Learning Objectives
  • Introduction to Parameters
  • Using Parameters
  • Parameters Panel
  • Adding a Parameter
  • Adding a Parameter: Example
  • Assigning a Parameter
  • Assigning a Parameter: Example
  • Editing a Parameter
  • Editing a Parameter: Example
  • vi
  • Removing a Parameter
  • Removing a Parameter: Example
  • Deleting a Parameter
  • Summary
  • Practice 7: Working with Parameters
  • 8 Performing Data Actions Using Tasks
  • Learning Objectives
  • Introduction to Integration Task
  • Creating an Integration Task
  • Creating an Integration Task: Example
  • Editing an Integration Task
  • Editing an Integration Task: Example
  • Deleting an Integration Task
  • Deleting an Integration Task: Example
  • Data Loader Tasks
  • Creating a Data Loader Task
  • Creating a Data Loader Task: Example
  • Editing a Data Loader Task
  • Editing a Data Loader Task: Example
  • Deleting a Data Loader Task
  • Deleting a Data Loader Task: Example
  • Publishing a Task
  • Publishing a Task: Example
  • Summary
  • Practice 8: Performing Data Actions Using Tasks
  • 9 Publishing an Application
  • Learning Objectives
  • Introduction to Applications
  • Accessing Applications
  • Creating Applications
  • Creating Application: Example
  • Viewing Application Details
  • Introduction to Tasks
  • Tasks – Example
  • Running a Task
  • Running Task: Example
  • Task Runs
  • Terminating Applications
  • Terminating a Task: Example
  • vii
  • Patches
  • Patches: Example
  • Editing Applications
  • Editing Applications: Example
  • Deleting Applications
  • Deleting Applications: Example
  • Monitoring Task Runs
  • Monitoring Task Runs: Example
  • Summary
  • Practice 9: Publishing an Application

ذات صلة الدورات