Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ipauldur
Contributor

Connect with MS Project

Hello,

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

6 Replies
Not applicable

Connect with MS Project

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

ipauldur
Contributor

Connect with MS Project

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.

Not applicable

Connect with MS Project

Hi Durai,

Looks like MS does not provide this option.

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

Regards,

Narayanan

disqr_rm
Valued Contributor III

Connect with MS Project

Why don't you just use ODBC?

MVP & Luminary
MVP & Luminary

Connect with MS Project

Hi Durai,

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

- Ralf

quiquehm
New Contributor III

Re: Connect with MS Project

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