Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
marcel_olmo
Partner - Specialist II
Partner - Specialist II

Challenge. How can I read data from an stored copy of an SQL?

Hi guys,

I have some data in a copy of a sql database that I'd like to read directly from Qlik Sense. Is it possible?

I know that I can import the SQL data in a SQL environment and then read it with Qlik Sense, but the point is that I want to avoid this step.

For this purpose I've attached a SQL Server sample database of bikes, in case any of you know how to do it, could show the community how is made the loading script 😄

Kind regards, Marcel.

 

Labels (1)
5 Replies
vikasmahajan

Hi,

Requirement is not clear can you elaborate what exact you are trying to achieve ?

 

Vikas 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
marcel_olmo
Partner - Specialist II
Partner - Specialist II
Author

Hi @vikasmahajan , 

my customer receives every week a copy of an external SQL database of a company they've recently bought.

They want to read it with Qlik scripting processes instead to create a DWH project, that's why I'm asking here if it could be possible.

Kind regards, Marcel.

jbhappysocks
Creator
Creator

Hi @marcel_olmo .

Your example file BikeStores Sample Database - load data.sql is basically just a text file, if you convert it to a text format you can read it without problems. 

So if you actual data is the same format I would say convert it to text. Then you need to create a loop that identifies and separates the rows in your file that contains data and create QVD's. Don't know how comfortable you are building such loops, but from a quick look at the example data it looks very doable. Let me know if you need any assistance.

This is based on the example file, I have no other experience of reading copies like this so I don't know if it will automatically be the same for you actual data. 

 

 

marcel_olmo
Partner - Specialist II
Partner - Specialist II
Author

Thanks @jbhappysocks for the advice. The point here is that the real example is far more complicated and for the personalized looping for each table maybe it can cost a big effort, but if there's no other way, we'll do it.

Kind regards, Marcel.

jbhappysocks
Creator
Creator

Yes, I almost figured the example was a bit oversimplified. But as long as it follows a strict logic like your example you shouldn't need to make any personalized looping for each table, as long as the structure is the same for all tables it's just a standard loop for all tables.