How to write analyzed data from wso2 DAS to custom database for API manager

Question

In my case i'm using wso2 api manager and Data analytic server. I need to show the analyzed data on the api manager publisher or subscriber accounts which are analyzed by the DAS. I rifer reference source

In the DAS side I can see the results perfectly. But can't see the statistics from the API manager side. Only I can see "Data Publishing Enabled, Generate some traffic" message. Not getting any error too. please guide me how can I resolve this.

[Edited]I got this exception after following the steps mentioned in the @Prabudda Sri Rahal 's answer.

So how can I resolve this issue.

Answer 1

Need to add API_Manager_Analytics.car file to DAS as a carbon application. Then it creates all the necessary streams, event receivers. But it doesn't create event publishers to publish these data to our custom database. For that need to create event publishers manually to write on the database tables by mapping correct stream attributes with the database column names. Refered: enter link description here