Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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