The Cognite SAP Extractor is now generally available to CDF users!

Great news @Christian Mueller 

It may sound like a simple question, but does it always extract a full data load, or is it prepared for Change Data Capture (CDC)?

Hi @andrelcalves!

When running the extractor against OData services built on SAP Gateway having the LastChangeDateTime field, the extractor supports delta loads. For more details please refer to the Load Data Incrementally section of the SAP Extractor documentation.

Best Regards,

Christian

Hi @Christian Mueller 

I noticed that the video previously available in the post is no longer accessible. If you could share it again, I would really appreciate it.

Additionally, I have a question that I hope you can clarify. Perhaps I am misunderstanding something, but I thought that whenever I need to retrieve work orders and operations from SAP, they should go to the cdf_idm space. If that’s the case, do I need to design any specific data model for that? Below is an example of a transformation using the Cognite Toolkit.

externalId: sap_maintenance_order_{{ source }}
dataSetExternalId: {{ dataset }}
name: Maintenance Order Transformations for {{ sourceName }}
destination:
  type: nodes
  view:
    space: cdf_idm
    externalId: CogniteMaintenanceOrder
    version: v1
  instanceSpace: {{ instanceSpace }}
ignoreNullFields: true
isPublic: true
conflictMode: upsert
authentication:
  clientId: ${SAP_SPRINGFIELD_S4HANA_CLIENT_ID}
  clientSecret: ${SAP_SPRINGFIELD_S4HANA_CLIENT_SECRET}
  tokenUri: ${IDP_TOKEN_URL}
  cdfProjectName: ${CDF_PROJECT}
  audience: ${CDF_URL}
  scopes:
  - ${IDP_SCOPES}

Thanks for the heads up @Andre Alves ! 

Have moved the video and re-added the link to this post.

Thanks, @Thomas Sjølshagen ! We're always focused on SAP integration matters, so I really appreciate the update.

Can this extractor subscribe to SAP Operational Data Provisioning Framework for Change data Capture. 

Some SAP objects don't have a create date/modified date column that we can use for ingestion state management. Also we can't identify physical delete using ODATA approach.

Can this extractor subscribe to SAP Operational Data Provisioning Framework for Change data Capture. 

Unfortunately, no it does not.