Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
millan123
Not applicable

How to create the ODBC/OLEDB connection for DB2 server ?

Hello All,

Please help me on How to create the ODBC/OLEDB connection for DB2 server ? Please give help me?

Thanks in Advance

Clark

1 Solution

Accepted Solutions
mohitd910
Not applicable

Re: How to create the ODBC/OLEDB connection for DB2 server ?

1. Search for ODBC Data Source (64 Bit)

2. in System DSN Tab, (

In Control Pannel  adminstration tools click on ADD.)

3. Choose Database from list

4. Provide Server Details with Username and Password.

Then in Qliksense,

In App,1.  Go to Load Editor

2. Click on Create Connection

3. Select ODBC/OLEDB

4. Select DB name From System DSN

5. Provide Username and Password.

6. Test Connection

4 Replies
shraddha_g
Not applicable

Re: How to create the ODBC/OLEDB connection for DB@ server ?

On Server, Click on Windows,

1. Search for ODBC Data Source (64 Bit)

2. in System DSN Tab, click on ADD.

3. Choose Database from list

4. Provide Server Details with Username and Password.

Then in Qliksense,

In App,1.  Go to Load Editor

2. Click on Create Connection

3. Select ODBC/OLEDB

4. Select DB name From System DSN

5. Provide Username and Password.

6. Test Connection

7. if Successful, provide name of the connection and click on Create.

I hope it is helpful.

agigliotti
Not applicable

Re: How to create the ODBC/OLEDB connection for DB2 server ?

You can use Qlik ODBC Connectors in Qlik Connectors download page.

mohitd910
Not applicable

Re: How to create the ODBC/OLEDB connection for DB2 server ?

1. Search for ODBC Data Source (64 Bit)

2. in System DSN Tab, (

In Control Pannel  adminstration tools click on ADD.)

3. Choose Database from list

4. Provide Server Details with Username and Password.

Then in Qliksense,

In App,1.  Go to Load Editor

2. Click on Create Connection

3. Select ODBC/OLEDB

4. Select DB name From System DSN

5. Provide Username and Password.

6. Test Connection

millan123
Not applicable

Re: How to create the ODBC/OLEDB connection for DB2 server ?

Thanks for all you are replay's