topic Re: Testing connection to MySQL in QlikView

Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 13:39:19 GMT

Hi Friends -

I have been tasked to test the connection to MySQL and I have been told that the MySQL Connector has been installed on the QA server. I have no idea how to test the connection. Would someone be able to lay out steps to test the connection. Do I need to install MySQL on my machine also?

All inputs will be greatly appreciated.

Best,

Sunny

Re: Testing connection to MySQL

antoniotiman — Tue, 11 Oct 2016 14:04:38 GMT

Hi Sunny,

You don't need to install MySQL in Your computer.

You install MySQL connector (I use ODBC 5.3 64 bit).

Then configure Windows ODBC Data Source, like

Regards,

Antonio

Re: Testing connection to MySQL

mohitd910 — Tue, 11 Oct 2016 14:07:38 GMT

Sunny Yes you need to install MYSQL in your server. Without MYSQL how can you test your connector or string.

You must need to install.Only then you can test your connector or string.

2) Or if the MY Sql is installed on the server and server has public IP then you can test from anywhere. If public ip is available on Server and MYSQL installed without installing in your system.

3.) Neet to take care ports are open or not for data reading.

Thanks

Re: Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 14:07:42 GMT

Antonio -

This would test the connection on my computer, right? How would I test this on QA Server? MySQL Connector is already installed on QA Server, I just need to test the connection to make sure that it is ready to pull data when needed.

Thanks,

Sunny

Re: Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 14:11:31 GMT

Mohit my expertise are very basic in this (probably 0) and you will have to go easy on your use of the terminology. I get the first point, but have no idea about the second and third bullet point.

Re: Testing connection to MySQL

mohitd910 — Tue, 11 Oct 2016 14:20:43 GMT

2.) Bro if you are able to access your Server outside your organisation. then you have public IP .

Then you need to check in your Server MYSQL is installed or not. If installed then you can check directly without installing in your system.

3.) In 3 point need to check to rules for the user. you have reading access for that user or not bro.

Re: Testing connection to MySQL

antoniotiman — Tue, 11 Oct 2016 14:21:37 GMT

If Test on Your computer is OK, then QA Server is ready to pull data to other Client.

However You can make same test on QA Server (Windows or Linux ?)

Re: Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 14:28:00 GMT

Thanks Mohit -

-> I think we I would try to connect to the QA Server through my personal computer, it won't let me login. So I think that would mean that the server doesn't have public IP.

-> MySQL connector is installed on the server. Is that different to MySQL or do you mean MySQL connector?

-> I don't know what access I have, but that is something I can check.

Re: Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 14:30:14 GMT

It is Windows 2008 R2

Re: Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 14:32:13 GMT

antoniotiman‌ - How do I reach here? I used it before, but can't remember the path

Re: Testing connection to MySQL

mohitd910 — Tue, 11 Oct 2016 14:35:37 GMT

1.) bro if you are unable to login then you dont have the public IP bro. you are correct.

2.) First bro if you are talking about the MYSQL database then no need to installed in your system. If you talking about to connector then you need to install in your system.

Re: Testing connection to MySQL

antoniotiman — Tue, 11 Oct 2016 14:36:04 GMT

Re: Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 14:43:20 GMT

antoniotiman - This is good progress. I see this on the QA Server

Now the problem is that there is no QlikView installed on the QA Server. All I see is this

If I am not missing anything, I would need to install QlikView on the QA Server to create an application which can test connection to the MySQL, right?

Re: Testing connection to MySQL

antoniotiman — Tue, 11 Oct 2016 14:46:31 GMT

Yes,right.

Re: Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 14:50:07 GMT

And the alternative to this is to install MySQL Connector on my machine and test the connection and put it on QA to test the connection? Can you share a download location for MySQL Connector?

Thanks,

Sunny

Re: Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 14:53:06 GMT

Is this good enough?

Re: Testing connection to MySQL

antoniotiman — Tue, 11 Oct 2016 14:57:12 GMT

Yes, according to MySQL Server version on QA Server (I assume >= 5)

Re: Testing connection to MySQL

sunny_talwar — Tue, 11 Oct 2016 20:28:37 GMT

Thanks guys. I learned something new today

Best,

Sunny