Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhelms
Creator
Creator

Find all ODBC Connections

I am trying to find what ODBC connections each of our documents connects to. Is there a way to do this short of opening all of our documents and looking at them? I have looked in the document log, but it only shows it like below. It takes the name of the connection out of the log. Does anyone know of a way to do this?

ODBC CONNECT*

3 Replies
bhelms
Creator
Creator
Author

I am again working on something that needs to find this information. Does anyone have any ideas how I could go about this?

Clever_Anjos
Employee
Employee

Maybe using this tool http://qlikviewcookbook.com/download/script-log-analyzer/ and searching for CONNECT

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Script Log Analyzer looks at logs. which the OP has pointed out removes the actual connect string.


The tool I would recommend that allows you to search raw script is:

Qlikview Cookbook: Script Repository http://qlikviewcookbook.com/recipes/download-info/script-repository/

I believe you can also use the QlikView Governance Dashboard which includes Connect strings as part of the lineage data.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com