Hello all,
We are looking to use the OData connector in Matillion to source data from SAP ERP data sources, specifically the Operational Data Provisioning (ODP) models.
I am able to connect and extract full data loads successfully, but when trying to use delta mode I can't get the parameters right.
Based on this blog post:
https://snapanalytics.co.uk/get-your-sap-data-into-snowflake-with-matillion-using-odata/
have setup, but when using the Connection Options to set the CustomURLParams to include !deltatoken='....' it either fails with error 400 (if include leading "!") or doesn't recognise the token and just initialises again if I include it.
It also seems problematic when trying to include multiple CustomURLParams, in this case we need to provide both sap-client & deltatoken. Using the document for OData to define how to specify parameters.
https://matillion-docs.s3.eu-west-1.amazonaws.com/datamodels/OData.html#RSBOData_p_FeedURL.htm
Wondering if anyone has been able to successfully get this working. We are using Matillion 1.51 - had some issues upgrading in the past.
Thanks,
Michael