topic Re: Challenge. How can I read data from an stored copy of an SQL? in App Development

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

marcel_olmo — Thu, 27 Jan 2022 12:47:51 GMT

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.

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

vikasmahajan — Fri, 28 Jan 2022 04:39:34 GMT

Hi,

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

Vikas

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

marcel_olmo — Fri, 04 Feb 2022 10:52:58 GMT

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.

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

jbhappysocks — Wed, 09 Feb 2022 09:51:12 GMT

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.

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

marcel_olmo — Wed, 09 Feb 2022 09:56:09 GMT

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.

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

jbhappysocks — Wed, 09 Feb 2022 10:04:54 GMT

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.