Slide 50
Slide 50 text
3. メッセージのPublish
4. ロード・アプリケーションの実行
Copyright © 2023, Oracle and/or its affiliates
Oracle SQL access to Kafka(OSaK)
例:KafkaデータをOracle Databaseのテーブルにロード
SQL> DECLARE
v_records_inserted integer;
BEGIN
v_records_inserted := 2;
DBMS_KAFKA.EXECUTE_LOAD_APP(‘KAFKACLUS1’, ‘AddressApp’, ‘address’, v_records_inserted);
END;
/
$KAFKA_HOME/bin/kafka-console-producer.sh –bootstrap-server cell-1.streaming.ap-Tokyo-
1.oci.oraclecloud.com:9092 –topic OSaKtestStream –producer.config $KAFKA_HOME/config/producer.properties
>Fred Flintstone,2 BamBam Way,Bedrock,PA,04040
>Barney Rubble,2 Dino Dr,Bedrock,PA,04040
50