11 Replies Latest reply: Jan 7, 2015 7:44 AM by Neeharika Chu RSS

    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

        • Re: Help on Batch File
          jagan mohan rao appala

          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.

            • 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

                • Re: Help on Batch File
                  jagan mohan rao appala

                  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.

                    • 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.

                    • Re: Help on Batch File
                      Rajesh Vaswani

                      Hi,

                       

                      Batch will finally call QlikView from command line.

                       

                      It will understand the connection string.

                       

                      thanks,

                      Rajesh Vaswani

                  • Re: Help on Batch File
                    Peter Cammaert

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

                      • 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>

                          • Re: Help on Batch File
                            Peter Cammaert

                            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