topic Re: Server Location Basic Question in QlikView

Server Location Basic Question

Anonymous — Tue, 19 Jul 2016 00:18:07 GMT

May be a silly question, but need clarity on this.

We store the include files, images, themes etc in server hard disk (in Test or Production).

How a developer using Qlikview desktop can access server files or images from the server while developing an application?

What is the standard procedure on this?

Thanks,

Karthick S

Re: Server Location Basic Question

qlikviewwizard — Tue, 19 Jul 2016 01:24:04 GMT

Hi karthick01

Can you elaborate with an example?

Re: Server Location Basic Question

Anonymous — Tue, 19 Jul 2016 02:05:33 GMT

Example,

I am working on an Application (Qlikvew Desktop) and I need to use an Include statement (which is already stored in the Qlikview Server and that Include statement has the Connection String). How can I use that Include in my application?

Re: Server Location Basic Question

qlikviewwizard — Tue, 19 Jul 2016 02:39:33 GMT

Apparently you can use the same connection string/include statement if credentials are same.

Re: Server Location Basic Question

rwunderlich — Tue, 19 Jul 2016 02:56:20 GMT

Typically, people make a copy of the folders and artifacts on a shared drive to be used for development. And then promote them to the production folders when they have been updated and tested.

It's also possible to share the production folders and make them available to developers, if that is consistent with your security policies and development philosophy,

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Server Location Basic Question

pavandbs — Tue, 19 Jul 2016 02:56:47 GMT

For my project,

UAT we map physically Server hard drive location.

Production we have to setup a key exchange to access respective files with server.

Re: Server Location Basic Question

qliksus — Tue, 19 Jul 2016 04:38:37 GMT

How will you handle the below scenario

a) If the server include file has a ODBC connection simply using the server file wont solve the issue unless you create the same ODBC in your local desktop

b) If the include files has some relative path set to a variable you will have to recreate this in your local desktop as well

So its better you use some shared folder or carry on your development activity directly in your test server

Re: Server Location Basic Question

amit_saini — Tue, 19 Jul 2016 05:09:17 GMT

Hi Karthick,

If the user is having right access to the folders , he/she can call file path from the server (Production or Test) through "File name" and select target file.

Result:

Hope this will help you!

Thanks,

Re: Server Location Basic Question

Anonymous — Wed, 20 Jul 2016 23:49:54 GMT

Thanks Rob. this is helpful

Re: Server Location Basic Question

Anonymous — Wed, 20 Jul 2016 23:50:31 GMT

Thanks Amit.

Re: Server Location Basic Question

Anonymous — Wed, 20 Jul 2016 23:52:23 GMT

Thanks Pavan.

Could you please explain the Key Exchange Setup in detail.

I am interested in knowing how we change the server name (from dev to prod). Does Qlikview Admin have any tool to do that or do they manually edit the server name?

Re: Server Location Basic Question

Anonymous — Thu, 21 Jul 2016 04:31:46 GMT

Thanks Rob.I am not exposed to Admin side.So, I am interested in knowing how we change the server name (from dev to prod) in the Script editor. Does Qlikview Admin use any tool to do that or do they manually edit the server name in Prod?

Re: Server Location Basic Question

amit_saini — Thu, 21 Jul 2016 05:11:54 GMT

Hi Karthick,

I'm helping u below with an example:

Let's suppose you have one dedicated machine for QlikView , Say "XYZ" as below blue marked

From below example , I'm having qvdev (Development) and qvprod (Production) folders :

Inside qvdev and qvprod Folders: Below is the example of Sub-folders (Application folders like Finance,Operations ,HR,ISC...etc) , which you should maintain in side these Dev and Pro folders

Note : Would be great if we are having same sub-folders name and structure inside qvdev and qvprod.

In above screenshot you can see a folder named "Include" , which is having all connection strings

So based on Test or Production connection string , you can name ur .txt file

For example : In my case D29_100.txt is having connection string for Test and in KTX_100.txt for Production

How this works???

Suppose being a developer , I have created an application inside qvdev -> Operations Folder and using D29_100.txt

for connecting with the database.

Link:

Now if I want to shift this application to "Production" , I need to manually change my include statement as below:

I have given u just one example according to ur situation , but there in no hard and fast rule to follow such folder strucrure.

Even you can have 2 different machines for Dev and Prod , but u and ur team has to create such an setup , which is clear to ur Deb and Prod team and easy to use.

Hope this will help u!

Thanks,

Re: Server Location Basic Question

Digvijay_Singh — Thu, 21 Jul 2016 05:27:53 GMT

You can have same name same folder qvs file having connection string. the dev connection string will point to dev path and prod connection string will point to prod path. No script changes would be required.

Chk page 6 in the attachment -

Re: Server Location Basic Question

Anonymous — Fri, 22 Jul 2016 00:30:39 GMT

Thank you so much for clearly explaining