topic Re: connecting to Primavera Database in QlikView

connecting to Primavera Database

Tue, 13 Dec 2011 20:38:46 GMT

I am new to Qlikview and we are just implementing. I have been playing hooking to excel tables, however I believe there is a way to connect to the full P6 database, does anyone have and answer for me?

connecting to Primavera Database

Ferran_Garcia_Pagans — Wed, 14 Dec 2011 00:58:21 GMT

Hi,

As long as I know Oracle Primavera uses 2 Oracle Database schemas, isn't it?

You can use an ODBC.

Ferran.

Re: connecting to Primavera Database

Wed, 14 Dec 2011 01:00:21 GMT

It does and We use sql database, when connecting do I use the database username and password or do I use the sql user name and password?

Thank You,

Mary E. Jones

Project Controls Lead

2155 Robertson Dr.

Richland, WA 99354

Ph: (509) 943-6706 or (800) 322-6706

Fax: (509) 943-1835

mjones@mceng.com

Visit our website at: www.go2mce.com<http://www.go2mce.com>

The information contained in this message is privileged and intended only for the recipients named. If the reader is not a representative of the intended recipient, any review, dissemination or copying of this message or the information it contains is prohibited. If you have received this message in error, please immediately notify the sender, and delete the original message and attachments.

connecting to Primavera Database

Ferran_Garcia_Pagans — Wed, 14 Dec 2011 01:18:45 GMT

Hi Mary,

I think you only need to acces an Oracle database schema. To do that you need a Oracle db user with acces to the schema.

When you have an ODBC Connection you can use from the script to connect with Oracle.

Look in this article:

http://techiedan.com/2010/08/12/linking-qlikview-and-oracle-using-odbc/

Hope this help, F.

Re: connecting to Primavera Database

Sri1223 — Thu, 25 Mar 2021 13:54:32 GMT

Hello, Ferran_Garcia_Pagans

Thanks for sharing the article-connecting to Primavera Database.

To configure an ODBC connection to Oracle I usually use the Oracle client. You need to install it in the QV Server box and in the machine your are using for development (QV Desktop). Be careful with the Oracle client version. We will note this and I get back to you very soon. I hope this may help you -Here we have a Primavera P6 Tutorial expertise in implementing Project Portfolio Management solutions.

Regards,

Srija.

Re: connecting to Primavera Database

mango123 — Thu, 15 Apr 2021 03:53:11 GMT

Primavera P6 Database Connection Configuration Details

In the login dialog, click on the Database field's ellipse button.
In the Edit Database Connections dialog, select the PMDB database.
Click on the Configure.
In the Select or Create Alias dialog, choose the following settings.
Click Next.