Question Related to Data Integration

Putra
Putra Active Partner
First Comment First Anniversary Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board
in Platform

I have some question related to Board I hope that i will be able to get help for this, it would be really appreciated

Here is the question :

1. Is it possible to board to import data with an insert update mode ( where there is a difference in the cell it will be updated , but if there is none it will be left as it is, and also insert at the same time ) as when i play with add or replace time slice in data reader , its either adding the value or clear the cube and replace it with the data from reader (replace time slice). is there any way around ?

2. Identifying Scheduler Procedure Failures and Mitigation:

What is the best way to identify if a procedure has failed in the scheduler, and what mitigation steps can be taken? for example : A procedure within the scheduler is not executing or the data reader in a procedure is not functioning.

3. REST API Functionality:

Is it possible in Board to retrieve and parse data located in the header of a REST API request rather than the body? in my case, the token itself is located in the header not the body, the body is only resulting in message "success".

4.when we are using ALM to move the package from development to production, the data reader or procedure inside should be resetting up to the new file path / connection path, is it possible to set it up in the alm or we need to do it manually after its been restored to production

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    edited January 27 Answer ✓

    Hi @Putra ,

    1.
    Board's DataReaders will either add values to existing ones or replace the entire timeslice given by the current selection. There is no other way.

    2.
    Procedures and DataReaders don't have a return code. If you put protocol steps at the beginning and end of a procedure, you can identify it as not running or not having been executed at all. Any recent protocol will show the procedure's execution.
    With DataReaders, that's a bit trickier because you'd need to define thresholds identifying "good" and/or "bad" as a result of their execution (can there be discarded records, and if yes, how many (meaningfully in %)?). Then you would need to process the DataReader's log to identify the errors.

    3.
    No.

    4.
    You can't set that as step of the transport procedure, you'll have to do it manually after the transport has been executed.

    Best,
    Helmut

Answers

  • Kevin Kowalski
    Kevin Kowalski Employee, Community Captain
    Fourth Anniversary 10 Comments 25 Up Votes First Answer

    Hi @Putra

    About Point 4 :

    Of course the best practice is to trigger "Data Readers" from a Procedure and use this variable : %computername%

    example :

    image.png


    About ALM if you do have specific scripts to trigger depending the instance we are using this workaround on different projects.

    Create a new Entity called "Instances" with members (s1, s2… c1, c2…) and populate a cube with a 1 following the instance. Then use this flag with a step "IF THEN ELSE" at the start of your procedure to automatically trigger the right specific group.

    image.png


    With this workaround you can use ALM all the time without any additional work in PRODUCTION, but you must configure all the groups…

    Kind Regards

    Kevin

Categories