Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sap Connector

While extracting data , every time its asking dsn name and pwd . can anybody tell a solution so that we dont have to repeat the excersize

1 Reply
disqr_rm
Partner - Specialist III
Partner - Specialist III

You can include user/password in your connection strin in the QVW script itself. Then, it won't ask it every time you reload.

As matter of fact, you can have this whole string stored in an XML file, and load it in every QVW. This way your string is secured as well, and if you change your app server ip or name, just change here in the XML and all your QVW are running again -> No change needed in 100s of QVW files. 🙂

To find the complete string, open a new QVW, connect to SAP from custom data source, enter system, client user and password. When you press ok, it will paste the complete connection string. Just copy this in every QVW or in a common XML/QVS file. The password you will get will be encrypted --> no security issues.

Hope this helps.