Connecting to IBM Rational Doors Databse

[Anonymous]

Hi All,

The data I am trying to manipulate in Power BI is stored on a IBM DOORS 9.5 database and curently I am having to export the data into a excel file to view it in Power BI.

Is there a way of connecting directly to a IBM DOORS database?

Many thanks

[Anonymous]

@Anonymous,

Based on my research, it seems that you can access the database through OSLC Rest API. You can use web entry in Power BI Desktop or directly add power query code in Power BI Desktop to extract data from the API, for more details, please review the following blogs.

https://www.ibm.com/developerworks/rational/library/oslc-services-rational-doors/index.html
https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

Regards,
Lydia