{"id":776,"date":"2017-05-22T15:10:46","date_gmt":"2017-05-22T13:10:46","guid":{"rendered":"https:\/\/www.thediar.com\/?p=776"},"modified":"2019-07-09T19:40:40","modified_gmt":"2019-07-09T17:40:40","slug":"google-data-studio-got-problems-mysql-take-good-care-time-zones","status":"publish","type":"post","link":"https:\/\/www.thediar.com\/en\/blog\/google-data-studio-got-problems-mysql-take-good-care-time-zones\/","title":{"rendered":"Google Data Studio: got problems with MySQL? Take good care of your time zones."},"content":{"rendered":"

We love\u00a0tools<\/strong>. We love\u00a0data visualization<\/strong>. We strongly believe that data visualization should not be expensive, so we’ve wondered whether\u00a0Google Data Studio\u00a0<\/strong>could be, at some point, one of the leaders in the market such as Qlik, Tableau or PowerBI.<\/p>\n

We are vey aware that Google Data Studio<\/strong> is not there\u00a0yet when it comes to the features the top tools have, but we want to share some of the experiences we have found so far. Today, concretely, we want to highlight an issue with the time zones<\/strong> when a connection to a\u00a0MySQL<\/strong> database is required.<\/p>\n

Google Data Studio\u00a0allows to use many data sources<\/h2>\n

This is obvious. For some months now, Google Data Studio allows to use\u00a0several data sources<\/strong> for reporting, and they are continuously adding more. At the moment when can bring data (when will be able to cross it efficiently?) from MySQL, plain files, Google Analytics, Big Query, etc:<\/p>\n

\"\"<\/p>\n

Right now\u00a0we miss<\/strong> sources such as SalesForce (or SugarCRM), Oracle, Facebook, MailChimp, among others. Time to time, as we can imagine that Google’s developers have them in their\u00a0roadmap<\/strong>.<\/p>\n

We started to experience issues with the MySQL connector<\/h2>\n

Some weeks ago we built a report that used as data source a MySQL data base (actually it was a DWH that was integrating data from many sources – we insist, again, on the topic of being able to\u00a0integrate<\/a> data in the same interface). Everything was perfect until we found an error<\/strong> message\u00a0<\/strong>when we tried to refresh the report or edit the connection parameters:<\/p>\n

\"\"<\/p>\n

It must be said that the error message was pretty\u00a0useless<\/strong>. Searching in the forums and boards we realized that we were not the only ones<\/strong> experiencing issues with Google Data Studio’s MySQL connector. We were starting to get dissappointed when, some hours later (maybe it was a bug) when we refreshed the report we obtained a much more concrete message. Nevertheless it was highly puzzling:<\/p>\n

\"\"<\/p>\n

Wow! Houston, we got a problem with the time zone: CEST<\/a> time zone is not recognized! We kindly ask Google Data Studio developers some support to avoid the fact of having the server time being modified, because we were not able<\/strong> to solve the issue by modifying the URL in the JDBC<\/strong> call: the only way to overcome the situation was to change the server time, to UTC in this case, and,\u00a0voil\u00e0<\/em>, we were able to reestablish the connection without further issues:<\/p>\n

\"\"<\/p>\n

Since that moment we experienced no further problems when refreshing the report, even if the table feeding it gets larger and larger every day (of course, we make sure the tables are properly indexed<\/strong> – some day we will test the performance of Google Data Studio when connecting to MySQL tables not having their indexes in place).<\/p>\n

Summary: a better support is needed<\/h2>\n

Google solved this issue last May 18th. Between May 12th and May 18th it was necessary to use the mentioned workaround if you wanted to use your MySQL tables as source in Google Data Studio. Of course, there are companies and situations that can’t allow to be such time without data. For such urgent issues, Google must enable a support system enabling them to solve important issues the same day.<\/p>\n

 <\/p>","protected":false},"excerpt":{"rendered":"

We love\u00a0tools. We love\u00a0data visualization. We strongly believe that data visualization should not be expensive, so we’ve wondered whether\u00a0Google Data Studio\u00a0could be, at some point, one of the leaders in the market such as Qlik, Tableau or PowerBI. We are […]<\/p>\n","protected":false},"author":2,"featured_media":777,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","clearfix"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.thediar.com\/wp-content\/uploads\/data-studio.png?fit=240%2C160&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p8d1gX-cw","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/posts\/776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/comments?post=776"}],"version-history":[{"count":8,"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/posts\/776\/revisions"}],"predecessor-version":[{"id":1906,"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/posts\/776\/revisions\/1906"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/media\/777"}],"wp:attachment":[{"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/media?parent=776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/categories?post=776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thediar.com\/en\/wp-json\/wp\/v2\/tags?post=776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}