Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sql server synchronization

How to sql server synchronization in qlikview server

6 Replies
ziadm
Specialist
Specialist

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

Not applicable
Author

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.

ziadm
Specialist
Specialist

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 ..

Not applicable
Author

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

ziadm
Specialist
Specialist

May this Qlikview Console Management helps

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

Anil_Babu_Samineni

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;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful