Create a Data Pipeline with Data Transforms in Autonomous Database Data Studio [PRSH2978].pdf

1、Create a Data Pipeline with Data Transforms in Autonomous Database Data StudioJayant Mahto,Autonomous Database Product ManagementSeptember 10,2024Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates1AgendaOracle CloudWorld Copyright 2024,Oracle and/or its affiliates2Introduce Data Transform

2、sData sourcesHigh performance architectureODI to Data Transforms migration serviceDemoHow to create data pipelineGlimpse of immediate futureModern Data Platform pillars3DataVirtualizationAmazon GlueData CatalogsData Lake File FormatsData integrationsourcesData SharingSecure object store accessModern

3、 Data Platform pillars4Data integrationsourcesDataVirtualizationAmazon GlueData CatalogsData Lake File FormatsData SharingSecure object store accessOracle CloudWorld Copyright 2024,Oracle and/or its affiliates5Load data from any sourceTransform data to support any business needBuilt-in tool in Auton

4、omous DatabaseAlso available in OCI GoldenGateserviceData sources and targetsOracle CloudWorld Copyright 2024,Oracle and/or its affiliates6Classifying data sources for simplificationData source type and formatsDatabasesApplicationsFiles/formatsWeb Services/REST/CustomBulkIncrementalRealtimeStreaming

5、InitialData movement mode Target platformSorry,it was hard to fit all the data sources in one slide.AutonomousData WarehouseAutonomousTransactionProcessing ATPExadataCloudAny on-premises Oracle DB 11.2.0.4+Any GoldenGate on-premisesOCI MySQL DB ServiceOCI StreamingAutonomousJSON DBOCI Object Storage

6、ADW Stage-Mergew/Obj StoreAny on-premises Oracle DB 11.2.0.4+OCI GoldenGate DeploymentsOCI Object StorageReal-time Sources/TargetsReal-time TargetsBulk Data Transforms Sources&TargetsData sources and targetsNote:Data Transforms integrates with GoldenGate service for real-time requirementData process