topic How to connect QV to MYSQL hosted on another server in QlikView https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194646#M714774 <HTML><HEAD></HEAD><BODY><P>1. Install the mySQL ODBC driver to create a new mySQL ODBC connection</P><P>2. Define the settings for the ODBC connection. Note: you can use a FQDN or an IP address or a web address for the Server</P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/27/5342.sql.png"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/27/5342.sql.png" /></A></P><P>3. Access the ODBC connection in the Script dialog in Qlikview as per any other live data source</P><P>4. Load, Store and access tables as per any other data source!</P></BODY></HTML> Thu, 22 Apr 2010 03:07:58 GMT 2010-04-22T03:07:58Z How to connect QV to MYSQL hosted on another server https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194643#M714771 <HTML><HEAD></HEAD><BODY><P>Hi we have some time using QV, now we like to expand the QV usage by accesing some data on MYSQL, someone can please tell me which are the steps to connect to a MYSQL database hosted on another server.</P><P></P><P>Thanks for your help,</P><P></P><P>Camilo Lund R.</P></BODY></HTML> Wed, 21 Apr 2010 22:04:32 GMT https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194643#M714771 camilo 2010-04-21T22:04:32Z How to connect QV to MYSQL hosted on another server https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194644#M714772 <HTML><HEAD></HEAD><BODY><P>That's a good question and I'd like to know as well. I guess a textfile or csv file export first from MySQL and then importing these files into Qlikview could be an option.</P><P>However I hope that more elegant solutions are out there??</P><P>Thx</P><P>Ludwig</P><P></P></BODY></HTML> Thu, 22 Apr 2010 00:40:41 GMT https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194644#M714772 2010-04-22T00:40:41Z How to connect QV to MYSQL hosted on another server https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194645#M714773 <HTML><HEAD></HEAD><BODY><P>Hello, I did a mysql connection once and I do not remember the details, but I remember I got an odbc connector from the mysql site, once you have you can configure and odbc datasource. As i said before, I do not quite remember the configuration on the odbc, but I am almost sure that you can type the ip address of the remote server. Hmmm... I almost forgot, one thing I noticed is that you can't use the wizard to explore the tables and fields from the mysql db, for some reason they just do not appear, so you have to do all the sql selects by hand.</P><P>Hope this helps.</P><P>Regards</P></BODY></HTML> Thu, 22 Apr 2010 00:53:01 GMT https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194645#M714773 2010-04-22T00:53:01Z How to connect QV to MYSQL hosted on another server https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194646#M714774 <HTML><HEAD></HEAD><BODY><P>1. Install the mySQL ODBC driver to create a new mySQL ODBC connection</P><P>2. Define the settings for the ODBC connection. Note: you can use a FQDN or an IP address or a web address for the Server</P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/27/5342.sql.png"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/27/5342.sql.png" /></A></P><P>3. Access the ODBC connection in the Script dialog in Qlikview as per any other live data source</P><P>4. Load, Store and access tables as per any other data source!</P></BODY></HTML> Thu, 22 Apr 2010 03:07:58 GMT https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194646#M714774 2010-04-22T03:07:58Z How to connect QV to MYSQL hosted on another server https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194647#M714775 <HTML><HEAD></HEAD><BODY><P>Hi Matt,</P><P>Thanks for the information. Is it possible to perform joins in the loadscript with this driver?</P><P>Any other driver limitations you know of?</P><P>Thx again</P><P>Ludwig</P></BODY></HTML> Thu, 22 Apr 2010 14:22:22 GMT https://community.qlik.com/t5/QlikView/How-to-connect-QV-to-MYSQL-hosted-on-another-server/m-p/194647#M714775 2010-04-22T14:22:22Z