Hello Devanand! I want to bring awareness to a feature that we have in the works to help cover some of the use cases to bring data into a BI tool without the need to transform the data into an external data warehouse.
https://genesyscloud.ideas.aha.io/ideas/ANLS-I-1082 This feature that we have in development will leverage the export capabilities included in all the UI's analytics views to produce a regularly updated CSV file that BI tools can reference as their data source. This will enable a business user to get data they see in our UIs into a BI tool without any custom development work. As Brad noted, the data transformation route can be a complex or expensive undertaking.
We're on track to have this functionality available early 2023. If your use cases for your users can be satisfied by getting the data available in our existing analytics views, then this feature we're building may be what you're looking for.
------------------------------
Ryan Legner
Staff Product Manager, Genesys Cloud CX
------------------------------