6-（线上）崔星灿 FFA-Xingcan-ZH.pdf

1、Oracle CDC Practice with Flink and LogMiner 崔星灿 Software EngineerWealthsimple Outline 1. Introduction 2. Solution Overview 3. The Oracle CDC Connector 4. Other Jobs 5. Future Work Introduction#1 About Wealthsimple A Fintech Startup Based in Toronto #1 Wealthsimple Invest Robo-Advisor #2 Wealthsimple

2、 Trade DIY Stock/Crypto Trading Weathsimple Cash Saving Account Ready for Investment and Daily Use #3 About the BOR Team Book of Record Team Track the Financial Assets (Cash, Security etc.) Writing Transactions to Oracle General Ledger Reading Transactions from Oracle General Ledger Accounting with

3、the Extracted Transactions The Ledger Reading Problem Service A Service B Service C Service D? SQL Queries on DB Views The Source of Truth Service A Service B Service C Service D Change Data Capture Data Pipeline Unification Solution Overview#2 Our Goals To Replicate Oracle Database To Generate an Ordered Transaction Stream (Database View) Try to Preserve Oracle Transactions Systems Involved The F