Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

connectivity qlikview to PS campus solution

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

Thanks for your help in advance.

11 Replies

connectivity qlikview to PS campus solution

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

Not applicable

connectivity qlikview to PS campus solution

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

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

Not applicable

connectivity qlikview to PS campus solution

Hi,

Let me see whether PS has ODBC Connection in it.

connectivity qlikview to PS campus solution

Hi,

   Ok

Regards,

Kaushik Solanki

danielrozental
Honored Contributor II

connectivity qlikview to PS campus solution

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.

Not applicable

connectivity qlikview to PS campus solution

Hi,

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

danielrozental
Honored Contributor II

connectivity qlikview to PS campus solution

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.

Not applicable

connectivity qlikview to PS campus solution

Hi daniel,

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

Community Browser