Can you send me a link of your API documentation? And do you also have any documentation about the internal database of Intelligence Central?
"May I know what will happen once daily load process finishes? Some sql script will run, send some HTTP request, run some batch script or what's others?"
Nothing special happens except than sending the reports. Once the daily Datawarehouse ETL is complete, we just trigger the custom events we configured on the BI platform.
So the best would be:
- Having a page on TIC to define custom events
- When clicking on an automation script on TIC, under schedule, selecting the custom event
- From our ETL, trigger the custom event when needed (by any mean: TIC database update, http request, API call, etc).
- Then, TIC would run all automation scripts attached to the custom event just triggered.
We have build many custom events. Examples: Daily load complete, End of month after load, End of period after load, End of week after load, End of fiscal quarter after load, etc.
So, depending on the target time frame of their reports (daily, weekly, monthly, etc), We have a custom event for that. So for example, they don't need to know when the fiscal quarter ends, they just choose the custom event "End of fiscal quarter after load" and our custom event will take care of delivering the report at the right time.