topic STT - Troubleshooting Qlik Data Gateway - Direct Access in Techspert Talks

topic STT - Troubleshooting Qlik Data Gateway - Direct Access in Techspert Talks https://community.qlik.com/t5/Techspert-Talks/STT-Troubleshooting-Qlik-Data-Gateway-Direct-Access/m-p/2411324#M190 <P>This Techspert Talks session covers:</P> <UL> <LI>How Data Gateways for Direct Access works</LI> <LI>What to do if things go wrong</LI> <LI>Troubleshooting best practices</LI> </UL> <P><div class="video-embed-center video-embed"><iframe class="embedly-embed" src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FSmJ_w3pjDp4%3Ffeature%3Doembed&display_name=YouTube&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DSmJ_w3pjDp4&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FSmJ_w3pjDp4%2Fhqdefault.jpg&type=text%2Fhtml&schema=youtube" width="600" height="337" scrolling="no" title="STT - Troubleshooting Qlik Data Gateway - Direct Access" frameborder="0" allow="autoplay; fullscreen; encrypted-media; picture-in-picture;" allowfullscreen="true"></iframe></div></P> <P> </P> <P><FONT size="6"><SPAN>Chapters: </SPAN></FONT></P> <UL> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=69s" target="_blank" rel="noopener">01:09</A></SPAN><SPAN> - What is Direct Access Gateway?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=128s" target="_blank" rel="noopener">02:08</A></SPAN><SPAN> - Best Practices</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=203s" target="_blank" rel="noopener">03:23</A></SPAN><SPAN> - Setting up Direct Access Data Gateway</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=325s" target="_blank" rel="noopener">05:25</A></SPAN><SPAN> – Configuration</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=452s" target="_blank" rel="noopener">07:32</A></SPAN><SPAN> - Creating a connection</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=586s" target="_blank" rel="noopener">09:46</A></SPAN><SPAN> - Creating an ODBC connection</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=703s" target="_blank" rel="noopener">11:43</A></SPAN><SPAN> - Correcting Data Preview error</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=830s" target="_blank" rel="noopener">13:50</A></SPAN><SPAN> - Troubleshooting failed tasks</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1062s" target="_blank" rel="noopener">17:42</A></SPAN><SPAN> - Setting up Notifications</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1126s" target="_blank" rel="noopener">18:46</A></SPAN><SPAN> - Q&A: Why are date field read as text?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1244s" target="_blank" rel="noopener">20:44</A></SPAN><SPAN> - Q&A: Difference between Direct Access and Data Movement?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1324s" target="_blank" rel="noopener">22:04</A></SPAN><SPAN> - Q&A: Can only users in a space access the connection?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1377s" target="_blank" rel="noopener">22:57</A></SPAN><SPAN> - Q&A: Which connector to use for SAP HANA?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1432s" target="_blank" rel="noopener">23:52</A></SPAN><SPAN> - Q&A: What 3rd party connectors were tested?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1469s" target="_blank" rel="noopener">24:29</A></SPAN><SPAN> - Q&A: What white listing is necessary?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1502s" target="_blank" rel="noopener">25:02</A></SPAN><SPAN> - Q&A: How to resolve "Invalid argument" error?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1553s" target="_blank" rel="noopener">25:53</A></SPAN><SPAN> - Q&A: Does Direct Access require an extra license?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1569s" target="_blank" rel="noopener">26:09</A></SPAN><SPAN> - Q&A: Are there performance best practices?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1641s" target="_blank" rel="noopener">27:21</A></SPAN><SPAN> - Q&A: Do customer connector perform better?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1685s" target="_blank" rel="noopener">28:05</A></SPAN><SPAN> - Q&A: Any issues with multiple connections?</SPAN></LI> </UL> <P> </P> <P><FONT size="6">Resources:</FONT></P> <UL> <LI><A href="https://community.qlik.com/t5/Official-Support-Articles/How-To-collect-Windows-Event-Logs/ta-p/1713419" target="_blank" rel="noopener">How To collect Windows Event Logs</A></LI> <LI><A href="https://community.qlik.com/t5/Official-Support-Articles/How-to-Collect-Performance-Data-for-Data-Gateway-Direct-Access/ta-p/2098244" target="_blank" rel="noopener">How to Collect Performance Data for Data Gateway - Direct Access</A></LI> <LI><A href="https://community.qlik.com/t5/Official-Support-Articles/How-to-collect-dump-files-for-the-Qlik-Data-Gateway-Direct/ta-p/2107958" target="_blank" rel="noopener">How to collect dump files for the Qlik Data Gateway - Direct Access ODBC connector crashes</A></LI> <LI><A href="https://help.qlik.com/en-US/video/Z6buZY5r8MeGtyeqeYffBh" target="_blank" rel="noopener">Installing Qlik Data Gateway Direct Access</A></LI> <LI><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway-setting-up.htm#anchor-1" target="_blank" rel="noopener">Best practices when using Qlik Data Gateway - Direct Access</A></LI> <LI><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/ODBC-DrectAccess/ODBC.htm" target="_blank" rel="noopener">ODBC Connector (via Direct Access gateway)</A></LI> <LI><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/ODBC-DrectAccess/sample-connection-strings.htm" target="_blank" rel="noopener">Sample connection strings and syntax</A></LI> </UL> <P> </P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Community400x200.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/159443i6B1D996B3FBEB917/image-size/medium?v=v2&px=400" role="button" title="Community400x200.png" alt="Community400x200.png" /></span> </SPAN></P> <P> </P> <P><SPAN> </SPAN></P> <P><SPAN><A href="https://community.qlik.com/t5/Video-Transcripts/STT-Troubleshooting-Qlik-Data-Gateway-Direct-Access/ta-p/2411321" target="_blank" rel="noopener">Click here to see video transcript</A></SPAN></P> <P><SPAN> </SPAN></P> <P><SPAN><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/22488">@NadiaB</a> </SPAN></P> <P><SPAN> </SPAN></P> Fri, 13 Sep 2024 08:41:38 GMT Troy_Raney 2024-09-13T08:41:38Z STT - Troubleshooting Qlik Data Gateway - Direct Access https://community.qlik.com/t5/Techspert-Talks/STT-Troubleshooting-Qlik-Data-Gateway-Direct-Access/m-p/2411324#M190 <P>This Techspert Talks session covers:</P> <UL> <LI>How Data Gateways for Direct Access works</LI> <LI>What to do if things go wrong</LI> <LI>Troubleshooting best practices</LI> </UL> <P><div class="video-embed-center video-embed"><iframe class="embedly-embed" src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FSmJ_w3pjDp4%3Ffeature%3Doembed&display_name=YouTube&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DSmJ_w3pjDp4&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FSmJ_w3pjDp4%2Fhqdefault.jpg&type=text%2Fhtml&schema=youtube" width="600" height="337" scrolling="no" title="STT - Troubleshooting Qlik Data Gateway - Direct Access" frameborder="0" allow="autoplay; fullscreen; encrypted-media; picture-in-picture;" allowfullscreen="true"></iframe></div></P> <P> </P> <P><FONT size="6"><SPAN>Chapters: </SPAN></FONT></P> <UL> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=69s" target="_blank" rel="noopener">01:09</A></SPAN><SPAN> - What is Direct Access Gateway?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=128s" target="_blank" rel="noopener">02:08</A></SPAN><SPAN> - Best Practices</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=203s" target="_blank" rel="noopener">03:23</A></SPAN><SPAN> - Setting up Direct Access Data Gateway</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=325s" target="_blank" rel="noopener">05:25</A></SPAN><SPAN> – Configuration</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=452s" target="_blank" rel="noopener">07:32</A></SPAN><SPAN> - Creating a connection</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=586s" target="_blank" rel="noopener">09:46</A></SPAN><SPAN> - Creating an ODBC connection</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=703s" target="_blank" rel="noopener">11:43</A></SPAN><SPAN> - Correcting Data Preview error</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=830s" target="_blank" rel="noopener">13:50</A></SPAN><SPAN> - Troubleshooting failed tasks</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1062s" target="_blank" rel="noopener">17:42</A></SPAN><SPAN> - Setting up Notifications</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1126s" target="_blank" rel="noopener">18:46</A></SPAN><SPAN> - Q&A: Why are date field read as text?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1244s" target="_blank" rel="noopener">20:44</A></SPAN><SPAN> - Q&A: Difference between Direct Access and Data Movement?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1324s" target="_blank" rel="noopener">22:04</A></SPAN><SPAN> - Q&A: Can only users in a space access the connection?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1377s" target="_blank" rel="noopener">22:57</A></SPAN><SPAN> - Q&A: Which connector to use for SAP HANA?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1432s" target="_blank" rel="noopener">23:52</A></SPAN><SPAN> - Q&A: What 3rd party connectors were tested?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1469s" target="_blank" rel="noopener">24:29</A></SPAN><SPAN> - Q&A: What white listing is necessary?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1502s" target="_blank" rel="noopener">25:02</A></SPAN><SPAN> - Q&A: How to resolve "Invalid argument" error?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1553s" target="_blank" rel="noopener">25:53</A></SPAN><SPAN> - Q&A: Does Direct Access require an extra license?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1569s" target="_blank" rel="noopener">26:09</A></SPAN><SPAN> - Q&A: Are there performance best practices?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1641s" target="_blank" rel="noopener">27:21</A></SPAN><SPAN> - Q&A: Do customer connector perform better?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=SmJ_w3pjDp4&t=1685s" target="_blank" rel="noopener">28:05</A></SPAN><SPAN> - Q&A: Any issues with multiple connections?</SPAN></LI> </UL> <P> </P> <P><FONT size="6">Resources:</FONT></P> <UL> <LI><A href="https://community.qlik.com/t5/Official-Support-Articles/How-To-collect-Windows-Event-Logs/ta-p/1713419" target="_blank" rel="noopener">How To collect Windows Event Logs</A></LI> <LI><A href="https://community.qlik.com/t5/Official-Support-Articles/How-to-Collect-Performance-Data-for-Data-Gateway-Direct-Access/ta-p/2098244" target="_blank" rel="noopener">How to Collect Performance Data for Data Gateway - Direct Access</A></LI> <LI><A href="https://community.qlik.com/t5/Official-Support-Articles/How-to-collect-dump-files-for-the-Qlik-Data-Gateway-Direct/ta-p/2107958" target="_blank" rel="noopener">How to collect dump files for the Qlik Data Gateway - Direct Access ODBC connector crashes</A></LI> <LI><A href="https://help.qlik.com/en-US/video/Z6buZY5r8MeGtyeqeYffBh" target="_blank" rel="noopener">Installing Qlik Data Gateway Direct Access</A></LI> <LI><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway-setting-up.htm#anchor-1" target="_blank" rel="noopener">Best practices when using Qlik Data Gateway - Direct Access</A></LI> <LI><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/ODBC-DrectAccess/ODBC.htm" target="_blank" rel="noopener">ODBC Connector (via Direct Access gateway)</A></LI> <LI><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/ODBC-DrectAccess/sample-connection-strings.htm" target="_blank" rel="noopener">Sample connection strings and syntax</A></LI> </UL> <P> </P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Community400x200.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/159443i6B1D996B3FBEB917/image-size/medium?v=v2&px=400" role="button" title="Community400x200.png" alt="Community400x200.png" /></span> </SPAN></P> <P> </P> <P><SPAN> </SPAN></P> <P><SPAN><A href="https://community.qlik.com/t5/Video-Transcripts/STT-Troubleshooting-Qlik-Data-Gateway-Direct-Access/ta-p/2411321" target="_blank" rel="noopener">Click here to see video transcript</A></SPAN></P> <P><SPAN> </SPAN></P> <P><SPAN><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/22488">@NadiaB</a> </SPAN></P> <P><SPAN> </SPAN></P> Fri, 13 Sep 2024 08:41:38 GMT https://community.qlik.com/t5/Techspert-Talks/STT-Troubleshooting-Qlik-Data-Gateway-Direct-Access/m-p/2411324#M190 Troy_Raney 2024-09-13T08:41:38Z Re: STT - Troubleshooting Qlik Data Gateway - Direct Access https://community.qlik.com/t5/Techspert-Talks/STT-Troubleshooting-Qlik-Data-Gateway-Direct-Access/m-p/2480435#M202 <P>Thanks for sharing!</P> Mon, 09 Sep 2024 11:29:04 GMT https://community.qlik.com/t5/Techspert-Talks/STT-Troubleshooting-Qlik-Data-Gateway-Direct-Access/m-p/2480435#M202 F_B 2024-09-09T11:29:04Z