Solved: Zoho Databridge JDBC driver problem with European time zones and MySQL

Solved: Zoho Databridge JDBC driver problem with European time zones and MySQL

If you are running in problems with following configuration:

- Zoho Analytics and Zoho Databridge
- MySQL on Windows server
- default timeZone configuration 



just run following commands in mysql:

SET GLOBAL time_zone = '+1:00';

or

SET GLOBAL time_zone = 'Europe/Vienna';

At CEYOND we are using Zoho Analytics and Zoho Databridge to get the customers' data from their local datacenters into the world of Zoho. Inside of Zoho Analytics we transform and prepare the data to load/sync it into Zoho CRM and Zoho Books. That's is really a great way to handle a lot of data from different data sources.