SAP BW / Board connection - issue on data read preview

Daniele Di Lorenzo
Daniele Di Lorenzo Customer
Fourth Anniversary 250 Up Votes 100 Likes 100 Comments
in Platform

Hello

 

I've succesfully tested a connection from SAP BW to BOARD using the trial version of the SAP Connector, but:

 

1)

From the BOARD Connector Designer I can see the preview of the query but in Board SAP Data Reader I cannot see the preview: all fields contains a string like "abc###".

This makes really difficult mapp the fields and set properly ETL rule, or debug the application if something is not correctly updated.

 

Anyway , figures are uploaded in Board correctly.

Has anyone experienced this behaviour? Due to? How can I fix it?  

 

2)

Than, I cannot save some settings in BOARD Connector such as decimals and column separator, but maybe this is due to the trial version. Can someone confirm this?

 

See attachment, containing some screenshots

 

thanks!

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited June 2022 Answer ✓

    Hi Daniele Di Lorenzo,

     

    1. Fields containing “abc###” is usual behavior with this connector – the connector doesn’t really extract data at this stage, no fix available
    2. can be due to the trial version, although I’m not quite sure, sorry. But in my experience, the trial and the official version are working exactly the same way.

     

    Kind Regards,

    Helmut

Answers

  • Leone Scaburri
    Leone Scaburri Employee
    Fourth Anniversary 100 Comments 5 Answers 25 Likes

    When you use the Browse option from a datareader, BOARD execute the extractor in preview mode to display a small set of data in short time.

    The preview function is not “fully” supported for all SAP object. This limitation is due to some SAP objects, like BAPI or SAP Query, because it is necessary to complete the execution of the process to get the preview, losing the benefits of this function.

    For these objects, when you run an extractor in preview mode, BOARD Connector check all parameters and configuration but doesn't run the process on SAP and shows dummy values.

     

    Regards,

    Leone

Categories