topic Re: QlikView with Multiple data sources in QlikView

QlikView with Multiple data sources

nancy_sbeity — Fri, 20 Nov 2020 18:02:30 GMT

Hello,

Is there any existing application (demo) that shows qlikview loading data from many data sources (Excel , SQL ...)

Note: I need these multiple data sources in one application.

Thank you in advance.

Re: QlikView with Multiple data sources

swuehl — Thu, 08 Oct 2015 08:14:52 GMT

I believe that is the standard setting for an average application, loading data from multiple sources.

I would recommed looking at the book QlikView 11 for developers

QlikView 11 for Developers | PACKT Books

which demonstrates this with with some demo data sources you can download.

If you only want to see some script code. There should be some samples around here in the forum and on Qlik Demo.

Basically, it's just combinations of CONNECT for defining DBMS access and LOAD for table data load from DBMS or directly from file.

Re: QlikView with Multiple data sources

Anonymous — Thu, 08 Oct 2015 08:55:52 GMT

Hi NAncy,

Are you interested in the process of connecting to multiple data sources or just in having a demo app which uses multiple data sources?

The Qlik YouTube channel has many helpful videos showing connection to different data types. For example, look at New to QlikView: Load Data from ODBC - YouTube for multiple tables from a database, or look at New to QlikView: Load Data from Excel - YouTube to load data from Excel.

If you are just looking for a demo app, many of the app on Qlik Demos: See QlikView in Action | Demo.Qlik.Com are built using multiple sources, it is just transparent when using the actual application.

Re: QlikView with Multiple data sources

Anonymous — Thu, 08 Oct 2015 08:59:35 GMT

hi ,

check below post:

New to QlikView Videos

Re: QlikView with Multiple data sources

nancy_sbeity — Thu, 08 Oct 2015 09:06:38 GMT

Hi,

Thank you for your help but what I need is to show Qlikview loading data from multiple sources specially CRM, SQL in the same application. I mean I need a demo. Is there any solution?

Re: QlikView with Multiple data sources

Anonymous — Thu, 08 Oct 2015 09:17:59 GMT

If you want to see a demo of building an app from multiple data sources then maybe you want to have a look at the Getting Started with QlikView webinar I presented a while back. This shows connecting to multiple data sources, joining the data together and then building an application from it. You should be able to access it at the following link

Play recording

If you need to show the demo from your own data sources then your best bet is either to build it yourself, using the material above as a guide, or contact your local Qlik sales team to talk through your requirements and try to arrange a one on one session, though there might be a local charge for this depending on your region.

Re: QlikView with Multiple data sources

Thu, 08 Oct 2015 09:56:42 GMT

Hi,

I saw some good explanation and examples for this in QlikView 11 for Developers .

Better to go through cookbook once for more data analytical concepts

Re: QlikView with Multiple data sources

raghvendrasingh — Thu, 08 Oct 2015 10:14:31 GMT

Hi Nancy,

You can find several applications for excel source from community.

Anybody can't provide you the app having the source SQL,SAP... etc.

Because for making the connection to SQL you need to require credentials user name and password.

These credentials are server specific.

So best option is there, you need to go through the book ( QlikView 11 for Developers) and can watch youtube videos.

Thanks,

Raghvendra

Re: QlikView with Multiple data sources

sivaramr — Wed, 08 May 2019 13:45:57 GMT

Hi Abh,

I need to accomplish the same (connect multiple data source like oracle, mysql & mongodb and map the record using case id and populate it as a result in separate sheet) in my project. Could you please provide access to your Webex recording