Integration with Qlik Analytics tool

You have a couple of options:

1. Use the enhanced data pipeline. This enables other tools to connect directly to your Appian data source and use the data for reporting.
2. Use a shared database. You can connect Appian to an external database which is shared with Qlik or other tools. 
3. Use a sync. This is not ideal since you mentioned you want to report in real time; however, you could create a process in Appian that runs on a schedule (e.g. every night) and sends the updated data to an external system where it can be used in reporting.

Have you also considered building reports in Appian? If you want to use option (3) above, you could build reports that require real-time reporting in Appian and reports that use historical data in other tools.

You have a couple of options:

1. Use the enhanced data pipeline. This enables other tools to connect directly to your Appian data source and use the data for reporting.
2. Use a shared database. You can connect Appian to an external database which is shared with Qlik or other tools. 
3. Use a sync. This is not ideal since you mentioned you want to report in real time; however, you could create a process in Appian that runs on a schedule (e.g. every night) and sends the updated data to an external system where it can be used in reporting.

Have you also considered building reports in Appian? If you want to use option (3) above, you could build reports that require real-time reporting in Appian and reports that use historical data in other tools.

Thanks Peter, Considering our business scenario, 1st option seems to be worth exploring  . Thanks a lot for providing the details.