Created by Ardhi Catur Kurniawan on Jan 19, 2023

Summary

Issue

  1. We need to provide card transaction report to Euronet in .txt format and pipe “|” delimiter

  2. The report should be generated at the end of the day

  3. Below is minimum spec for the report

Result

  1. We will use cloud SQL exporter then store it to the GCS bucket and provide the SFTP host to EN

  2. Cloud scheduler should give trigger each end of the day to Pub/Sub and the message will be consumed by cloud function and cloud function will send command to export the data and store to the bucket, see schema below

Action:

  1. SAF-1213 - POC on cloud SQL exporting csv Backlog

  2. Permission Setup (Request to SRE)

Related:

  1. https://cloud.google.com/sql/docs/postgres/import-export/import-export-csv#rest-v1

  2. https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler

Attachments:

CBS_File_Specification.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document)
CBS_File_Specification.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document)