Considering options for ingesting SAP ERP data into BigQuery. Plan is to ingest raw data and then process as needed (so ELT pattern). Two main options are:
What are pros and cons of each? Especially financial ($$$) ones? When is best to use which approach? Main concern – if we use CDC option, would this result in large BQ ingestion costs? Mainly because BigQuery Connector for SAP uses the BigQuery streaming API.