Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to sql server synchronization in qlikview server
what exactly you are looking for .. there is no such thing as SQL server sync ..
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.
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 ..
Thank u Giving the answer can u explain briefly how to do that.
May this Qlikview Console Management helps
If you got answer, Please close this thread
Or
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;