topic Re: getting Database into qlikview in QlikView

getting Database into qlikview

rathnam_qv — Mon, 12 Aug 2013 07:04:38 GMT

hi all,

when i am connecting to database through qlikview it's not showing that particular database,,how to add that...

can any one help me ...it's urgent

Thanks in advance!!!

Smiley

Re: getting Database into qlikview

tresB — Mon, 12 Aug 2013 07:20:21 GMT

Which database? for ODBC/OLEDB, you have to create a connection first(Control Panel->Administrative Tools->Data Sources(ODBC)...), once that is created properly, that should be visible there in QV connection.

Re: getting Database into qlikview

Anonymous — Mon, 12 Aug 2013 08:42:03 GMT

Simley

This could be due to the user does not have permission on that particular database.

Please provide the following details to be able to help you more :

1 - Database

2 - Version

3 - OLEDB or ODBC?

Regards

MultiView

Re: getting Database into qlikview

rathnam_qv — Tue, 13 Aug 2013 04:14:01 GMT

Hi Multiview,

i am using DB2...in that DDV01SBX is a data source...

when i am trying to connect to that Data source through ODBC..it's not presented in the list...

how to add the DDV01SBX data source to that...(i am selecting ODBC...then Clicking on Connect...then it wl display no.of Data Sources...in the list DDV01SBx is not there..)

Re: getting Database into qlikview

Siva_Sankar — Tue, 13 Aug 2013 06:32:39 GMT

You can use ODBC to connect to db2 ... and for the select ,... is pretty much the standard way of doing it... http://publib.boulder.ibm.com/infocenter/idm/v2r1/index.jsp?topic=/com.ibm.datatools.sqlbuilder.tutorial.doc/topics/sqlquery_introduction.html regards. siva

Re: getting Database into qlikview

rathnam_qv — Wed, 14 Aug 2013 08:28:16 GMT

can u send me the steps...how to create it

Thanks in advance!!!!

Smiley

Re: getting Database into qlikview

peschu123 — Wed, 14 Aug 2013 09:03:58 GMT

Check if you installed the odbc driver correctly and the dsn is present.

On Windows in administrative tools --> odbc data sources (might be a little different depending on win version)

You need local admin rights to install the odbc driver(I needed it..).

Re: getting Database into qlikview

Anonymous — Wed, 14 Aug 2013 09:15:08 GMT

DB2 ODBC driver wont be found on Windows by default. You may need to install it. Test installing the DB2 client on your local machine before installing on the Server. Also check the compatibility of the driver with your operating system.

Please follow the steps below to :

1 - Install the client

2 - Configure it

http://fmepedia.safe.com/articles/How_To/Creating-a-connection-to-IBM-DB2

If you are still not able to see your database using the username and password, then you may need to contact the DBA in your company and explain that you do not have permission to that database.

NB: You may need to create System DSN on the server, so that any user who connects to the server could see use the same.

I hope this helps!

Regards

MultiView