Akan Veri Analitii Kutay ilingirolu Ph D Sr

Akan Veri Analitiği Kutay Çilingiroğlu, Ph. D. Sr. Solution Architect kutay. cilingiroglu@onedatalake. com

Data Modernization RDBMS Big Data No. SQL SAP Cloud Mainframe Enterprise Data Integration & Delivery

Data Modernization Steps

Advantages of Change Data Capture Enables smarter and faster decisions Minimizes production impact Reduces bandwidth and processing requirements CDC Is the Foundation of Modern Data Architectures

Modern Integration 1. REAL-TIME 2. HETEROGENEOUS 3. COMPLETE & AUTOMATED 4. SCALE & STABILITY

Qlik Replicate

Replicate for Streaming

1. SOURCES Database TARGETS SAP Mainframe DL/DW Automation Azure AWS Google § Oracle § DB 2 z/OS § ECC § Cloud SQL (My. SQL, Postgres) § IMS/DB § ERP § RDS (My. SQL, Postgres, Maria. DB, Oracle, SQL Server) § DBaa. S (SQL DB) § SQL Server § Cloud Storage § DB 2 i. Series § VSAM § CRM § Aurora (My. SQL, Postgres) § DBaa. S (My. SQL, Postgres) § Dataproc § DB 2 z/OS § COBOL Copybooks § SRM § S 3 § ADLS Gen 1 & 2 § Pub/Sub § DB 2 LUW § GTS § EMR § BLOB § Big. Query § My. SQL § MDG § Kinesis § HDInsight § Snowflake § Maria. DB § SAP ECC - HANA § Redshift § Event Hub § Percona § SAP HANA (database) § Postrge. SQL Cloud § Sybase ASE § Informix § Snowflake § (on Oracle, SQL, DB 2 LUW, HANA) § ODBC § Azure SQL Server MI EDW § SQL Server Saa. S § Salesforce § Google Cloud SQL (My. SQL, Postgre. SQL) Flat Files § Exadata § Pivotal Database § Oracle § Amazon Aurora Postgre. SQL § Amazon Redshift § Vertica § Databricks § Amazon Aurora My. SQL § Mongo. DB § Netezza § Snowflake § Databricks § Amazon RDS (SQL Server, Oracle, My. SQL, Postgres) § SAP HANA § Teradata § Synapse (SQL DW) EDW Data Lake § Hortonworks § Oracle Autononous DW § Cloudera § Exadata § Map. R § Teradata § Amazon EMR § Netezza § Azure HDInsight § Vertica § Google Dataproc § Sybase IQ § SAP HANA § Microsoft PDW § Delimited (e. g. , CSV, TSV) § Map. R Streams § Sybase ASE Flat Files § Delimited (e. g. , CSV, TSV) Streaming § Azure Event Hubs § Postgre. SQL § Mem. SQL § JSON § Amazon Kinesis § My. SQL § Informix § XML § Kafka § DB 2 LUW SAP § SAP HANA (database) 8

Demo Targets Demo Sources RDBMS DATA LAKE Oracle EDW Postgre. SQL Qlik Replicate In-Memory FILE MSSQL Log Stream Mongo. DB RDBMS MSSQL Kafka EDW Filter Transform Databricks FILE SAP Postgre. SQL STREAMING Azure Storage Azure Event Hubs