GoodData-MySQL Integration Details

When setting up direct data distribution from your MySQL database, pay attention to the considerations and best practices listed in this article.

This article is applicable to all use cases of GoodData and MySQL integration:

Contents:

Ports Used

You can use any port from within the range of 1024-65535.

User Access Rights

We recommend that you grant the following access rights to the user who is referenced in Data Sources:

GRANT SELECT ON {database_name}.* TO '{user_name}'@'%'; --Grants read permission to a user.
GRANT SELECT ON {database_name}.* TO '{role_name}'; --Grants read permissions to all users in the specified role.

Data Types

During mapping the MySQL schema and the GoodData logical data model (LDM), data types are automatically converted from a MySQL data type to a GoodData LDM data type. Only the MySQL data types listed in the table are supported. If you want to prevent automatic changes, update the schema manually.

MySQL Data TypeGoodData LDM Data Type
bigintBIGINT
booleanVARCHAR(5)
charVARCHAR
dateDATE
datetimeDATE
decimalDECIMAL(12,2)
doubleDECIMAL(12,2)
double precisionDECIMAL(12,2)
floatDECIMAL(12,2)
intINTEGER
integerINTEGER
numericDECIMAL(12,2)
textVARCHAR (10000)
timestampDATE
varcharVARCHAR
othersUNSUPPORTED
Powered by Atlassian Confluence and Scroll Viewport.