topic Connect with MS Project in QlikView

Connect with MS Project

ipauldur — Mon, 29 Jun 2009 13:00:23 GMT

Hello,

Can we connect Qlikview with MicroSoft Project? If yes, How? Which connector will support to do this.

Connect with MS Project

Thu, 02 Jul 2009 14:13:49 GMT

Hi,

QlikView should be able to pull data out of MS Project using OLEDB for MS Projects. Just install the connect version of OLEDB connector and rest of the connection should be straight forward.

- Narayanan

Connect with MS Project

ipauldur — Thu, 02 Jul 2009 20:32:22 GMT

Dear Narayanan,

Thanks for your reply,

I am using MS project 2007. But i am not able to find the oledb provider for MS project.

How i can get , or from where i can download the Oledb provider for Project 2007.

Thanks,

Durai.

Connect with MS Project

Thu, 02 Jul 2009 22:03:19 GMT

Hi Durai,

Looks like MS does not provide this option.

http://office.microsoft.com/en-us/project/HA101691651033.aspx

Regards,

Narayanan

Connect with MS Project

disqr_rm — Fri, 28 Aug 2009 03:15:17 GMT

Why don't you just use ODBC?

Connect with MS Project

rbecher — Thu, 24 Nov 2011 11:45:06 GMT

Hi Durai,

why not export MS Project to Excel and then load it into QlikView?

- Ralf

Re: Connect with MS Project

quiquehm — Wed, 19 Sep 2012 15:51:17 GMT

Hi Rakesh

Could you please give me some details on how to setup the ODBC connection ? I am using MS Project 2002 standard edition ( standalone , no server edition ) and Qlikview 8.5 developer edition. I tried to open the ODBC connection on the qlikview script editor but I don´t see any MS Project "connector" there...the only datasources I see are : dBASE Files, Excel Files, ICAS Production, IIib Development, MS Access Database. When clicking the Create ODBC Source button at the bottom of the menuI don´t know what to do next to be honest.

Appreciate any guidance here.

I even tried the OLE DB Connection....where I can see an OLE DB Provider called Microsoft Project 10.0 OLE DB Provider...but when hitting Next it looks like you need to provide details of a server connection ....and what I just have is a MS Project project file ( mpp ) stored in my laptop to which I would like to connect from Qlikview.

Thanks a lot

Enrique