topic connectivity qlikview to PS campus solution in QlikView

connectivity qlikview to PS campus solution

Thu, 21 Jul 2011 05:48:04 GMT

Is there a way to connect Qlikview to PeopleSoft Campus solution as a sourse data provider?

Thanks for your help in advance.

connectivity qlikview to PS campus solution

kaushiknsolanki — Thu, 21 Jul 2011 06:06:50 GMT

Hi,

I dont have any idea about Peoplesoft, But if it has the ODBC or OLEDB connection, you can use them to connect to PeopleSoft.

Regards,

Kaushik Solanki

connectivity qlikview to PS campus solution

Thu, 21 Jul 2011 06:12:15 GMT

Hi Kaushik,

Thanks for your reply i appreciate, It would be more helpful for me if you could send me a link or document containing steps connect to third party application through ODBC or OLEDB.

connectivity qlikview to PS campus solution

kaushiknsolanki — Thu, 21 Jul 2011 06:22:10 GMT

HI,

All you have to is create a OBDC connection with your thirdparty application(database).

Steps are.

Start -> Control Panel -> Administrative tools -> ODBC -> Here create a connection to your third party application.

Open qlikview -> File -> New

File -> Edit Script -> you will see the a dropdown, here select OBDC and the name of the connection you have created.

Regards,

Kaushik Solanki

connectivity qlikview to PS campus solution

Thu, 21 Jul 2011 06:25:09 GMT

Hi,

Let me see whether PS has ODBC Connection in it.

connectivity qlikview to PS campus solution

kaushiknsolanki — Thu, 21 Jul 2011 06:27:52 GMT

Hi,

Regards,

Kaushik Solanki

connectivity qlikview to PS campus solution

danielrozental — Thu, 21 Jul 2011 13:58:08 GMT

PS has a database underneath, ORACLE, SQL Server, Informix, DB2, etc. so for sure you can connect to it using OLEDB or ODBC.

There is also an ODBC connector to peoplesoft queries, same that is used by crystal reports in PS.

connectivity qlikview to PS campus solution

Fri, 22 Jul 2011 04:25:26 GMT

Hi,

Thanks Daniel let me check with the PS. Also kindly let me know if there is anyother ways to connect these two applications.

connectivity qlikview to PS campus solution

danielrozental — Fri, 22 Jul 2011 12:34:36 GMT

There are other ways, like using files, soap messages and other things but I worked as a PeopleSoft technical consultant for several years and those two I mentioned before are the ones I would use.

connectivity qlikview to PS campus solution

Mon, 25 Jul 2011 11:07:24 GMT

Hi daniel,

Thanx for your valuable information. I will try connecting it through the ODBC and check the performance of report.

Re: connectivity qlikview to PS campus solution

Wed, 23 Nov 2011 05:11:01 GMT

DataRoket connects directly to all PeopleSoft data natively through QlikView. Let us know what detail you need. For more information: http://tinyurl.com/4x4n7zj

Re: connectivity qlikview to PS campus solution

Wed, 18 Feb 2015 18:00:38 GMT

Hi dilip,

Weere you able to connect PSFT through ODBC?