Skip to Main Content
Easy steps to create data pipeline using Data Transforms from Data Studio tools in Oracle Autonomous Database

About This Workshop

Youtube Video

About This Workshop
Autonomous Database is bundled with Data Studio for loading, integrating, preparing, analyzing and sharing data.

This workshop introduces you to the Data Transforms tool in Data Studio. You will learn how to create a data pipeline for data analysis, data science or for any ad-hoc data preparation need. Data can be loaded from a wide selection of heterogenous sources (databases and applications) and can go through complex transformations. You will learn how to define the data load and transforms process and schedule them for periodic execution.

Deployment:
- Data Transforms is part of Data Studio tools and is available in every Autonomous Database Serverless. You can simply create an Autonomous Database and go through this workshop.

- If you are not an Autonomous Database user, then you can use the Data Transforms deployed through OCI Golden Gate service. After deploying the service, you can use the remainder of this workshop to learn how to use Data Transforms.

Workshop Info

3 hours
  • Create Autonomous Database
  • Launch Data Transforms and basic setup
  • Load data from any source to Autonomous Database
  • Prepare data with complex transformations
  • Use variables and custom SQL
  • Create workflow 
  • Schedule data pipeline process
  • Familiarity with Autonomous Database is required
  • Familiarity with Data Integration concepts is useful.

Other Workshops you might like