2

Trigger a Incorta Load through a script or similar

We have an external scheduling tool from which can run shell/cmd scripts on a machine..

we want to trigger an incorta job load using this tool (Appworx,Autosys etx)

Can you please let me know how can we trigger the same.

9replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Incorta provides a command line interface for submitting an incorta job load.

    You can find those shell scripts under <incorta home>/IncortaNode/bin where it contains a sample: load_stagging_sample.sh

    #$incorta_cmd <load type> $session <Schema Name>

    The valid <load type> key words are
    load_schema
    load_schema_incremental

    Reply Like
  • Thanks Dylan Wan

    can we also add parameter to load a specfic table in the schema ? 

    Reply Like
    • Gnaneshwar Muthaluri  It supports load individual tables when you are using load_schema as the load type .

      #$incorta_cmd load_schema $session <Schema Name> <table name>

      Reply Like
  • Thanks Dylan Wan

    I have tried it and it worked fine.

    but when we submit the command it does not wait until the load is completed and does not share the status of the load.

    Can you please guide if there is way to get the status of the load or any other statistics regarding the load.

    Reply Like
  • We are having a similar issue. The script does not wait for the load to complete. How do we get the status of the load ?  In case of errors we prefer to send a notification email to our support team.

    Reply Like
  • Ok, we have modified the load cli command to add few options like 

    1. Wait for the load to complete in synchronous mode before control returns

    2. Display some stats about the tables how many rows loaded etc, success, failure.

    3. Option to redirect output to a file instead of displaying on screen so that scheduling systems can read that file

    We are testing this script and will share with you shortly.

    Reply Like 1
  • Great.. Thank you for you prompt response... will wait to hear from you.

    Reply Like
    • Sure, you are welcome.

      Reply Like
    • Mateen Mohammed  - is the script ready ?

      Reply Like
Like2 Follow
  • Status Answered
  • 2 Likes
  • 1 mth agoLast active
  • 9Replies
  • 124Views
  • 8 Following