ProjeQtOr free project management software - Acces to the Database with a report tool ? - ProjeQtOr

Formations en Amérique du Nord

Une formation est organisée par un de nos partenaires à Montréal.

Pour de plus amples informations, ou pour vous inscrire, rendez-vous sur notre planning de formations.

 

Acces to the Database with a report tool ?

More
13 Fév 2019 10:14 - 13 Fév 2019 10:15 #1 by dnaton
Hello,

The "report" section of Projeqtor give some interssant reports but each company would have specific report and it has nos sense to developp all the reports on ProjeQtor (or develop a BI tool in ProjeQtor).

In my company, we use PowerBi (BI software from Microsoft).

I have some questions :
  • Is there a way to connect the Projeqtor Database with PowerBi ? If yes, could you give me some informations to do that ? (main steps for begining :)
  • Is there a schema or documentation of the database to understand relations between tables ?

Thanks for any ideas, informations or help :-)

Regards,
Damien
ProjeQtOr v7.3.5 - Apache v2.4.25 - MariaDB v10.1.21 - PHP v7.2.13
Plugins installed : ScreenCustomization 5.3 - PersonalizedTranslations 1.3 - TranslationFrench 1.4
Last edit: 13 Fév 2019 10:15 by dnaton.

Please Connexion or Create an account to join the conversation.

More
14 Fév 2019 15:46 #2 by babynus

Is there a way to connect the Projeqtor Database with PowerBi ? If yes, could you give me some informations to do that ? (main steps for begining :)

No

Is there a schema or documentation of the database to understand relations between tables ?

No

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
20 Fév 2019 10:37 #3 by dnaton
Ok. thanks for response.

And if not possible with PowerBi, is it possible with other BI tools ? (like QlikView or Qlik Sence,Eclipse Birt,,...)

Is there anybody here who have install and use such solution in relation with ProjeQtor ?

If no, I'm interrested to know how you manage reporting ? :-)

Regards,
Damien
ProjeQtOr v7.3.5 - Apache v2.4.25 - MariaDB v10.1.21 - PHP v7.2.13
Plugins installed : ScreenCustomization 5.3 - PersonalizedTranslations 1.3 - TranslationFrench 1.4

Please Connexion or Create an account to join the conversation.

More
20 Fév 2019 10:43 #4 by babynus

And if not possible with PowerBi, is it possible with other BI tools ? (like QlikView or Qlik Sence,Eclipse Birt,,...)

My previous answer was not about impossibility to connect to PowerBi, but there is no information on how to do this.
You may try : projeqtor db is just a MySql database so you may connect any BI/Report/Query tool, but I don't know about existing help on that point.

I know about users who connected db woth ODBC and generate reports with Excel.
This requires basic DB knowledge and good Excel skills.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
26 Fév 2019 09:35 #5 by TOST
Hi,
i've managed to do this in PowerBI, with nice results. I have created a dedicated RO user in mysql, enabled connections from the outside, then connected pretty easily.
The only "Pain" is that the database is very well designed in a Star schema, so there's a lot of tables and relationships to take care about, and of course some business logic to "recreate" to obtain correct results.

Stefano

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.039 seconds