Q&A BY TAG 'MYSQL'
Denodo 7.0 supports MySQL innoDB cluser 5.7?
answered
17-11-2021 06:19:01 -0500
Hi Team, The underlying Mysql is going to upgrade to EE innoDB 5.7 version. I am concerned about whether Denodo 7.0 supporets this architecture or not. We can connect with Mysql right now but really concern about the comapatibility of Denodo for innoD...
Answers:
1
Data Source creation in Denodo 7.0
answered
25-11-2020 05:35:09 -0500
Hi Team, I am getting error while saving the data source created for MYSQL using Denodo 7.0. I am able to connect with data source successfully. But when I am saving the data Source a window popup with ysntax error message saying "Syntax error: Unknow...
Answers:
2
DEN70EDUD02 MySQL server connection issues for DEN70EDUD2002LAB04
answered
11-12-2019 07:54:39 -0500
I am trying to go through DEN70EDUD2002LAB04 and noticed there are issues with connection to a MYSQL server. I followed the steps of adding the jar file from the MYSQL website (adding both the 5.x and 8.x jar files in the lib-external/jdbc-drivers/mysq...
Answers:
3
base view fals when select granted on columns subset
answered
04-04-2019 08:01:57 -0400
Hallo Denodo Team I am experimenting with authorizations and permissions. On a mysql database I gave select grant to a user on a subset of a table's columns. I created denodo base views as an "unrestricted" user. When I log into denodo as the "restrict...
Answers:
3
Access to Derived Views from Mysql or Postgres
answered
02-04-2019 08:18:09 -0400
I have created some derived views and I need to read the data from those views and process the data and save it in an external database (Mysql, postbres), in a custom table. How you could do that? Or is possible to publish the information that I get fr...
Answers:
1
Issues connecting to a MSQL Data Source
answered
23-02-2017 05:09:53 -0500
I am have issues connecting to a MYSQL data source. I am using " mysql-connector-java-5.1.40\ " driver along with "com.mysql.jdbc.Driver" Connection is local : jdbc:mysql://localhost:port- (assigned port) /dbname - ( My dbname). I keep getting the erro...
Answers:
1
empty dates in MySQL problem
answered
28-10-2016 19:21:22 -0400
I'm connect Denodo to a MySQL server. I have a table with datatime columns. Some of the values are empty, thich look like '0000-00-00'. These are not null values, these are empty values. It appears Denodo cannot handle these values and reports an error...
Answers:
1