topic Re: Data Dictionary for SQL Server in QlikView

Data Dictionary for SQL Server

Anonymous — Sun, 27 Apr 2014 21:29:00 GMT

There used to be a data dictionary .qvw that someone developed for SQL Server but I can't find it. It was several years ago that I saw it here in the Community. Please let me know if you know where I can find it.

Re: Data Dictionary for SQL Server

MK_QSL — Sun, 27 Apr 2014 21:55:08 GMT

Direct Discovery_Demo_Adworks_11.2_SR5.qvw

Sql from Direct Discovery

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/08/qlikview-112-and-direct-discovery

Direct Discovery Sample

Re: Data Dictionary for SQL Server

stevedark — Sun, 27 Apr 2014 23:29:23 GMT

Hi Brian,

I have been meaning to upload my SQL Server schema viewer for a while, but want to put some more finishing touches to it first. Here it is in a nearly completed state. I hope it is useful to you.

I will post a link to the finished document when I have uploaded it.

Cheers,

Steve

Re: Data Dictionary for SQL Server

Anonymous — Sun, 27 Apr 2014 23:54:39 GMT

Excellent, thanks Steve!

BTW, my goal is to eventually allow designated users to enter comments about tables & columns by writing those comments, along with appropriate key of course, to an Excel or text file. This file will be loaded whenever the app gets reloaded, but it'll also perform a partial reload so that comments are visable right away. I'm already doing something very similar in another app where customer support reps want to be able to write a status and some comments on orders.

Re: Data Dictionary for SQL Server

stevedark — Mon, 28 Apr 2014 07:09:32 GMT

Hi Brian,

I did a similar solution in ASP and SQL Server, where a user could navigate the schema then write metada back to the database about each object. It would be possible to replicate this, I would imagine, with an Extension linking out to an ASP page.

Excel would also work.

Steve

Re: Data Dictionary for SQL Server

Anonymous — Wed, 03 Dec 2014 02:33:52 GMT

Hey Steve, did you ever finish this up?

Re: Data Dictionary for SQL Server

stevedark — Wed, 03 Dec 2014 09:03:23 GMT

Hi Brian,

The ASP/SQL solution was in a former life, before I discovered QlikView. I've never had a go at doing the same in QlikView - as yet.

Steve

Re: Data Dictionary for SQL Server

Anonymous — Wed, 03 Dec 2014 16:20:45 GMT

I was referring to the SQL Server Schema Viewer .qvw file you uploaded. I took your message to mean you were putting some finishing touches on that app.

- Brian

Re: Data Dictionary for SQL Server

stevedark — Wed, 03 Dec 2014 19:48:17 GMT

Hi Brian,

Yes, that app is still lacking those finishing touches! Hopefully one day I will have it in a state I am happy to upload it to Qlik Community. In the mean time I will be happy to send you a copy directly.

Steve

Re: Data Dictionary for SQL Server

Anonymous — Wed, 03 Dec 2014 20:48:21 GMT

Thanks, I’ll message you my email address.

- Brian