Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Requirement is not clear can you elaborate what exact you are trying to achieve ?
Vikas
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.
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.
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.
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.