Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Help on Batch File

Hi All,

I have created a batch file and text file(Which contains ETL server user ID and Password) to get the DONE FIle.

Everything is working fine.

But in the text file i dont want the user id and password to be straight forward. It should be in encrypted form. Can i store in encrypted form?? IS it possible?? Is yes please provide solution.

Best Regards,

Neeh

11 Replies
jagan
Not applicable

Re: Help on Batch File

Hi,

Generate ODBC connection string by using the Scramble Connect User Credentials option in

Edit Script -> Settings Tab(In the bottom of the script window) -> Select Scramble Connect User Credentials

Now generate the ODBC or OLE DB connection string and copy this to the text file.

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Help on Batch File

Hi Jagan,

Batch file is not executed by QLIKVIEW rt? So if we scramble as you have suggested it will take those credentials only and will fail to login.

Example:

If user id is ABC, Password is 123 and after scramblling userID will be xbshy and password will be 12hTGs.

So when we execute the batch file in the prompt for UserID and Password it will take

userID as xbshy

password as 12hTGs which will actually fail.

Any comments from your side please let me know

jagan
Not applicable

Re: Help on Batch File

Hi,

Put the encrypted string in text file and Include that text file in Qlikview script editor by using

Edit Script-> Insert -> Include Statement

Now reload the Dashboard using Batch file and it will reload the Dashboard, by doing so there is no problem of encrypting password.

Regards,

Jagan.

Not applicable

Re: Help on Batch File

HI Jagan,

PLease correct me if I am wrong:

What you have said is:

Run the batch file and using the bacth file we need to trigger one QLikview document where the script(text file) is written to get the done file from ETL server is placed (Script which is maintained in the text file is now should be included in Qlikview document using include)??

In this case how QLikview can get the file from ETL server and place in required location??

Because it is not Qlikview scripting.

Peter_Cammaert
Not applicable

Re: Help on Batch File

Can you post the content of your batch file (without the credentials)? What is it doing exactly?

Not applicable

Re: Help on Batch File

Hi Peter,

It will just open ETL server, get the done file and paste in QV server and delete from ETL server

open <SERVER NAME>

user

password

user <usER NAME>  <PASSWORD>

prompt off

type binary

lcd  <LOCATION OF QLIKVIEW SERVER WHERE IT SHOULD PASTE THE DONE FILE>

cd    <LOCATION OF ETL SERVER WHERE THE DONE FILE IS LOCATED>

get <DONE FILE NAME>

delete <DONE FILE NAME>

Peter_Cammaert
Not applicable

Re: Help on Batch File

Oh, these are commands for some sort of ftp client program?

QlikView may offer methods to generate an ad-hoc command file where you replace $() placeholders with the actual username and password. Those can be lifted from a secure file (possibly encrypted). But that is too cumbersome, I think.

How about using QlikView itself to transfer the data from the ETL server. LOADs can be programmed to get their source data from an ftp-server, and support for username and password is included as well. That would mean that the transfer can be scheduled under task control, and that usernames and passwords are only residing inside a QVW (with its own security features).

See Script editor->Data tab->Data From Files. Enable the FTP checkbox, and click the Table Files button.

Dunno if you can drop the source file from inside QlikView though. But that could be handled by a batch job on the ETL-server.

Peter

rajeshvaswani77
Not applicable

Re: Help on Batch File

Hi,

Batch will finally call QlikView from command line.

It will understand the connection string.

thanks,

Rajesh Vaswani

Not applicable

Re: Help on Batch File

Hi Peter,

Thank you for your reply.

In your case how Qlikview will bring the Done file and place in the required QV server ??

Can you elabrote more??