Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
florespablo86
Partner - Contributor
Partner - Contributor

Conectar App Qlik SaaS (cloud) con IBM DB2 for LUW

Buenas,

Es posible realizar una conexion de datos con DB2 desde Qlik Cloud sin utilizar Qlik Data  Integration, y así  para poder levantar las tablas desde la App realizando la conexión en la misma?

 

Muchas gracias

3 Replies
Daniele_Purrone
Support
Support

Hi @florespablo86 : you would like to connect to DB2 using Qlik Cloud Analytics.
In order to do that, you will need to setup a Direct Access gateway and connect via ODBC via a DB2 ODBC driver: https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/OD... 

Daniele - Principal Technical Support Engineer & SaaS Support Coordinator at Qlik
If a post helps to resolve your issue, please accept it as a Solution.
florespablo86
Partner - Contributor
Partner - Contributor
Author

Hola @Daniele_Purrone ,

La base de datos IBM DB2 esta en un servidor Linux, y en Qlik SaaS solo nos permite acceder a la conexión ODBC (via direct access) que Direct Access solo se puede instalar en Windows (para Linux esta Data Movement).

Se adjuntan las imágenes, del conector ODBC que nos ofrece Qlik SaaS y de la descarga de Direct Access Gateway.

¿Hay alguna forma de realizar la conexion de Qlik SaaS con DB2 en un servidor linux que no sea Data Integration?

¿Se puede instalar Access Direct Gateway en el servidor donde tengo instalado Qlik Sense On premise o solo puede instalarse en el servidor que esta dedicado a DB2?

Muchas gracias

qsaas1.pngqsaas2.jpeg

Daniele_Purrone
Support
Support

Hi @florespablo86 , you will need to install the Direct Access Gateway on a Windows Machine and connect to Linux from there.
The Gateway should always be installed on a dedicated server, never on a machine where you have databases or other relevant software.

Daniele - Principal Technical Support Engineer & SaaS Support Coordinator at Qlik
If a post helps to resolve your issue, please accept it as a Solution.