Skip to Content
avatar image
Former Member

Consume c4codata type fields from SAP OData service in BODS4.2

Hi all,

When we are consuming a SAP Odata Service using Odata Feed or from BODS 4.2 Adapter service, we are noticing that any fields with the following data types go missing in the table schema and not even get populated as fields.

c4codata.ENCRYPTED_LONG_Name (will have language and content)

c4codata.LOCALNORMALIZED_DateTime (will have timezone and datetime)

c4codata.ENCRYPTED_EXTENDED_Name (will have language and content)

c4codata.Amount (this will have currency code and and value)

Did anyone run into similar issue and could suggest a work-around for this please?

When testing the service via MS Excel Odata Feed also these columns show in the preview but will be missing in the spreadsheet output.

When we try using Custom OData Service and consume it via BODS or Excel we do not get all the text fields for a key in one table and we have to use many text tables and use LEFT join in the datawarehouse.

Thanks,

Anil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers