topic Re: How to Fetch DB name from connection string into excel sheet in qlikview in QlikView

How to Fetch DB name from connection string into excel sheet in qlikview

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

Hi All,

Can you please tell me,

I have a requirement to how to fetch DB name from connection string in Excel sheet or text object.

My Requirement is i have one connection string by using ODBC / OLE DB connection type in script.

I want a database(DB) name from that connection string.

EXample:

ODBC CONNECT TO (ORA-XXXX;DBQ=XXXXX) (XUSERID IS , XZXXXXXXXX PASSWORD IS ,XXXXXXXX);

In the above Connection string i want a ORA name and DBQ name.

Could you any one help me to this scenario, and please tell me to any code is there for fetching this information to Excel or any another Qlikview Object. And have any run macro for this information retrieve to tables object or any qlikview object.

Regards,

Bakshu.

Re: How to Fetch DB name from connection string into excel sheet in qlikview

Anonymous — Wed, 27 Jun 2018 07:03:09 GMT

after creating connection with the database , u have to select sql statement as shown below

ODBC CONNECT TO cipla_devl (XUserId is KIPEVZFMND, XPassword is CYeFbZFMAKMSDcUGaE);

select DB_Name() as dbname,

DB_Name() is use to fetch current database name and store it under dbname field

;

Re: How to Fetch DB name from connection string into excel sheet in qlikview

BalaBhaskar_Qlik — Wed, 27 Jun 2018 17:56:44 GMT

In OLEDB connection, Data Source (server IP), Initial Catalog(DB Name), used to appear normally, without encryption.