Q&A BY TAG 'MYSQL'

You must sign in to ask a question. If you do not have an account, you can register here

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

MYSQL Data Source

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

Denodo_MySQL MYSQL vm

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

Grant MySQL pass-through

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

external Database PostgreSQL MySQL

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

MYSQL

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

mysql