Automation of ODBC/OLEDB Connection in Qlikview Scripting

[Pulkit_Thukral]

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.

[Siva_Sankar]

Pulkit,

Check out here Passing userid and password to ODBC Connection

[Siva_Sankar]

Dynamically change data source

[ramasaisaksoft]

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

[Pulkit_Thukral]

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.

[Pulkit_Thukral]

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

[Miguel_Angel_Baeyens]

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.