https://community.qlik.com/t5/App-Development/Issue-Configuration-of-Netezza-OLEDB-ODBC-Driver-into-QlikSense/m-p/1912540#M75215 <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="0" data-number-of-phrases="17"><SPAN>Hello,</SPAN></SPAN> </SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="2" data-number-of-phrases="17"><SPAN>We need to connect Qlik Sense to an IBM Netezza database, for this we have installed the Netezza OLEDB driver on a Central node.</SPAN></SPAN> <SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="4" data-number-of-phrases="17"><SPAN>The installation/configuration went well, then we created the user DSN/System DSN with the database connection information.</SPAN></SPAN> </SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="6" data-number-of-phrases="17"><SPAN>We tested the connection through an application and the test was succeded, however we found that users do not have access to this connection to load tables.</SPAN></SPAN> <SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="8" data-number-of-phrases="17"><SPAN>We tried to create a new application based on this data connection, but we no longer have the list of Netezza users .</SPAN></SPAN> </SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="10" data-number-of-phrases="17"><SPAN>Conclusion: The connection string was assigned to the user who created the application, i.e. one token per user and per application.</SPAN></SPAN> </SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="12" data-number-of-phrases="17"><SPAN>Have you encountered this problem before?</SPAN></SPAN> </SPAN></P> <UL> <LI><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="14" data-number-of-phrases="17"><SPAN>QlikSense release: November 2018 patch 1</SPAN></SPAN> </SPAN></LI> <LI><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="16" data-number-of-phrases="17"><SPAN>Driver Version: IBM Netezza 64bit v.11.2.2.1</SPAN></SPAN></SPAN></LI> </UL> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="16" data-number-of-phrases="17"><SPAN>Best Regards</SPAN></SPAN></SPAN></P> Thu, 31 Mar 2022 14:07:30 GMT TH 2022-03-31T14:07:30Z https://community.qlik.com/t5/App-Development/Issue-Configuration-of-Netezza-OLEDB-ODBC-Driver-into-QlikSense/m-p/1912540#M75215 <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="0" data-number-of-phrases="17"><SPAN>Hello,</SPAN></SPAN> </SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="2" data-number-of-phrases="17"><SPAN>We need to connect Qlik Sense to an IBM Netezza database, for this we have installed the Netezza OLEDB driver on a Central node.</SPAN></SPAN> <SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="4" data-number-of-phrases="17"><SPAN>The installation/configuration went well, then we created the user DSN/System DSN with the database connection information.</SPAN></SPAN> </SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="6" data-number-of-phrases="17"><SPAN>We tested the connection through an application and the test was succeded, however we found that users do not have access to this connection to load tables.</SPAN></SPAN> <SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="8" data-number-of-phrases="17"><SPAN>We tried to create a new application based on this data connection, but we no longer have the list of Netezza users .</SPAN></SPAN> </SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="10" data-number-of-phrases="17"><SPAN>Conclusion: The connection string was assigned to the user who created the application, i.e. one token per user and per application.</SPAN></SPAN> </SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="12" data-number-of-phrases="17"><SPAN>Have you encountered this problem before?</SPAN></SPAN> </SPAN></P> <UL> <LI><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="14" data-number-of-phrases="17"><SPAN>QlikSense release: November 2018 patch 1</SPAN></SPAN> </SPAN></LI> <LI><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="16" data-number-of-phrases="17"><SPAN>Driver Version: IBM Netezza 64bit v.11.2.2.1</SPAN></SPAN></SPAN></LI> </UL> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="fr" data-phrase-index="16" data-number-of-phrases="17"><SPAN>Best Regards</SPAN></SPAN></SPAN></P> Thu, 31 Mar 2022 14:07:30 GMT https://community.qlik.com/t5/App-Development/Issue-Configuration-of-Netezza-OLEDB-ODBC-Driver-into-QlikSense/m-p/1912540#M75215 TH 2022-03-31T14:07:30Z