Forum Discussion

Siva_Venna's avatar
Siva_Venna
Contributor
7 years ago

Load .xlxb workbook with multiple sheets to oracle table. Load only one or specific sheet data only

I have .xlsx file on remote server. My requirement is to load the file content into an oracle table.
Any help is appreciable, Thanks in advance.

14 Replies

  • vyasyash's avatar
    vyasyash
    New Contributor III

    Hello Eguo,

    Thanks for suggesting the way to capture the input/output document of snaps.

    I’m new to SnapLogic world, and come from traditional ESB background. Wanted to understand if SnapLogic provides any out of the box feature to capture the input & output document for auditing and logging purpose (both in case of synchronous and async scenario). In production scenarios input/out payload will come handy to conduct RCA of the failed interface pipeline.

    Thanks in advance.

    Best,
    Yashu Vyas

    • eguo's avatar
      eguo
      Former Employee

      @vyasyash, welcome to the post-ESB paradigm!

      No there is no out of box feature to persist messages like in traditional ESB, hence created the approach in this post to enable troubleshooting activities.

      Benefits of this approach:

      • It avoids introducing new I/O endpoints into the pipeline. As a result, the pipeline has less state to manage in the runtime.
      • You could use Pipeline Monitoring API to consume the captured information to satisfy certain use cases.

      Limitations:

      • Only the last rolling hundred sub-pipeline’s runtime logs will be kept by SL platform therefore visible in the dashboard and accessible via the Pipeline Monitoring API.
      • A runtime log will be kept in SL platform for 90 days.
      • Can not enable the reuse in the pipeExec snap.

      Eddy

  • vyasyash's avatar
    vyasyash
    New Contributor III

    Thanks Eddy for your response.

    If for some specific business requirement we’ve to build a reusable pipeline for payload auditing purpose, do you suggest to use the Copy snap to capture the payload or SnapLogic follows a proprietary message structure for internal processing from where document data can be directly accessed ?

    Best,
    Yashu Vyas

  • @eguo

    Do you know like we have it in the typical ESB system, for error handling. If the error occurred at say 5th step then it would roll back and end up at the 1st step where we generally handle them.

    However it does not seem to be same in SnapLogic. Hence we need to have error handling at each step?

    /Krupali

    • eguo's avatar
      eguo
      Former Employee

      Hi @krupalibshah, thank you for sharing the information about typical ESB system. Created this post as I solved a problem I had and like to share it with the community. Wasn’t prepared to engaged into a conversation to either compare SL with ESB nor cover state management/error handling topic. In future, when I do have something worth to share on these topics, I will remember to link back to this thread.

      Eddy