View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Acces to the Database with a report tool ? - ProjeQtOr
 

Acces to the Database with a report tool ?

More
13 Fév 2019 10:14 - 13 Fév 2019 10:15 #1 by dnaton
Acces to the Database with a report tool ? was created 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 v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2
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
Replied by babynus on topic Acces to the Database with a report tool ?

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
Replied by dnaton on topic Acces to the Database with a report tool ?
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 v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

Please Connexion or Create an account to join the conversation.

More
20 Fév 2019 10:43 #4 by babynus
Replied by babynus on topic Acces to the Database with a report tool ?

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
Replied by TOST on topic Acces to the Database with a report tool ?
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: babynus, protion
Time to create page: 0.039 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form