topic Re: Automation of ODBC/OLEDB Connection in Qlikview Scripting in QlikView

Automation of ODBC/OLEDB Connection in Qlikview Scripting

Pulkit_Thukral — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to automate complete process of Qlikview Applciations development.

As step 1 ,requirement is to auto -setup odbc connection with the source db if provided with Service Name, DB Name ,user id and Password. How can this be achieved ?

Example:-

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=---;Data Source=PRD;Extended Properties=""] (XPassword is ------);

How can above statement be automatically written in qlikview scripting with provided details for setup.

Re: Automation of ODBC/OLEDB Connection in Qlikview Scripting

Siva_Sankar — Mon, 10 Apr 2017 09:15:07 GMT

Pulkit,

Check out here Passing userid and password to ODBC Connection

Re: Automation of ODBC/OLEDB Connection in Qlikview Scripting

Siva_Sankar — Mon, 10 Apr 2017 09:15:34 GMT

Dynamically change data source

Re: Automation of ODBC/OLEDB Connection in Qlikview Scripting

ramasaisaksoft — Mon, 10 Apr 2017 09:37:56 GMT

Hi Pulkit,

while we retrieving data from RDBMS like Oracle,MS Sql server then we will choose in Script Connect button and choose either OLDB or ODBC connection.

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=---;Data Source=PRD;Extended Properties=""] (XPassword is ------);

crating a ODBC connection

OLE DB/ ODBC connection to data sources in Qlikview - Mindmajix

use the ODBC connection in Qlikview

https://www.tutorialspoint.com/qlikview/qlikview_database.htm

Re: Automation of ODBC/OLEDB Connection in Qlikview Scripting

Pulkit_Thukral — Mon, 10 Apr 2017 09:45:08 GMT

Hi Sivasankar,

This works partially in my requirement.

For first time ODBC setup,Service Name ,DB Name are also required.

Is there a way to completely automate ODBC setup where in a similar way user can provide Service Name and other details which automatically can be used for ODBC Setup.

Re: Automation of ODBC/OLEDB Connection in Qlikview Scripting

Pulkit_Thukral — Mon, 10 Apr 2017 12:15:37 GMT

Need is to automate this complete this process without opening qlikview scripting part Rama.

Re: Automation of ODBC/OLEDB Connection in Qlikview Scripting

Miguel_Angel_Baeyens — Mon, 10 Apr 2017 12:46:36 GMT

What is the result? Not writing anything for the connection string?

Then you can use an $(Include=) in the script and define an external file with the connection strings for every environment.