topic Re: sql server synchronization in QlikView

sql server synchronization

Wed, 25 Nov 2020 16:16:04 GMT

How to sql server synchronization in qlikview server

Re: sql server synchronization

ziadm — Fri, 12 May 2017 19:12:01 GMT

what exactly you are looking for .. there is no such thing as SQL server sync ..

Re: sql server synchronization

Fri, 12 May 2017 19:21:44 GMT

I mean ODBC& OLEDB connections to extract from sql server data to qlikview application. But how to extract and synchronization sql server in qlikview server.

Re: sql server synchronization

ziadm — Fri, 12 May 2017 19:26:46 GMT

Create a Qlik view application that connects to MS Sql either OLEDB or ODBC and then you need to schedule this application on Qlikview server to extract data from SQL every week/day/ or hour ... or specific dates.

Qlik scheduler is part of Qlikview server to Sync Data ..

Re: sql server synchronization

Fri, 12 May 2017 19:34:12 GMT

Thank u Giving the answer can u explain briefly how to do that.

Re: sql server synchronization

ziadm — Fri, 12 May 2017 19:48:47 GMT

May this Qlikview Console Management helps

https://www.youtube.com/watch?v=SCLJfZOkQPA

Re: sql server synchronization

Anil_Babu_Samineni — Sun, 14 May 2017 17:46:01 GMT

If you got answer, Please close this thread

Assume, If you are fetching the data from 2 Data sources one is SQL Server and one more SAP

Sql Server Connection

Load * From Sql Server Data Source;

SAP Connection

Load * From SAP;

Then concatenate them like below

Sql Server Connection

Load * From Sql Server Data Source;

Concatenate

SAP Connection

Load * From SAP;