IBM FileNet Integrated Document Management (IDM) - Is there a way to throw a query to it from PQ?

[Anonymous]

Hello,

I was just wondering if the underlying database of an IBM FileNet Integrated Document Management (IDM) could be 'queried' from Power BI. You can produce Excel Reports out of it, but even to produce those is a pain in that platform... it would be so good to be able to! No offense, for sure it's a sound and safe software, but the Power BI is so easy and straightforward at reporting that now every piece of software looks like ante-diluvian.

Thanks in advance

Javier

[v-yuezhe-msft]

@Anonymous,

Which database system do you store the underlying database of IDM in? In Power BI Desktop, there are different database connectors such as SQL Server, Oracle, IBM DB2 and so on, for more details, please review the following article.

https://docs.microsoft.com/en-us/power-bi/desktop-data-sources

Regards,
Lydia

[Anonymous]

Thanks for your reply Lydia,

In fact, that's part of the problem. These files are safely stored -that's fine ;)- in our Servers in India, so I don't even know which is the underlying database scheme, filetypes, etc. This is under IT watch, again fine, but here start the problems for the 'query&error' exercise that I normally do for the many source types I need to fetch out there (especially websites, which I can easily throw 20 queries before I succeed! (if I eventually do...), That's why I would like to make sure that is possible to do so before even bothering chasing IT department to grant me access to the source, which normally takes time and thousand emails. In any case, for now, I'm working on the basis of a self-service BS (Business Smart ;).., so until I get my closest management on board the BI thing, if that happens at some point, I won't get support to get access to those servers.

So, summarizing, I didn't know that FN could have different underlying DB formats, so, for now, and until I get support from someone else, I will shelf this.

Many thanks for your help anyway,

Codaste

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Please firstly determine the specific source database system, then connect to the source in Power BI.

Regards,
Lydia

[Anonymous]

Thanks Lydia,

As said, I don't know. So I shelf this for now

Best,

Javier